Data at Your Fingertips: Explore Our New Reporting and Statistical Capabilities By Ryan Ashbrook 23 hours ago
Maximilian Atlantis Posted April 1 Share Posted April 1 (edited) In my host provider IONOS on the database dashboard, the size of my forum database shows 2 GB of 2 GB used, but when I open the database - it shows 797 MiB. Support agent can't answer me the question where is hiding the rest 1,203 MiB... Edited April 1 by Maximilian Atlantis Link to comment Share on other sites More sharing options...
Randy Calvert Posted April 1 Share Posted April 1 (edited) This post was recognized by Marc Stridgen! Randy Calvert was awarded the badge 'Helpful' and 5 points. Unfortunately this is a question for your hosting provider. IPS can’t control what they report or how they report it. It’s possible the database needs optimized or repaired, but again that’s something they would have to assist with. Also… if they can’t figure it out… IPS cloud offerings don’t have those restrictions. There is no database limits or even limits on page views anymore. Edited April 1 by Randy Calvert Askancy, Maximilian Atlantis and Marc Stridgen 1 1 1 Link to comment Share on other sites More sharing options...
Adlago Posted April 1 Share Posted April 1 3 hours ago, Maximilian Atlantis said: In my host provider IONOS on the database dashboard, the size of my forum database shows 2 GB of 2 GB used, but when I open the database - it shows 797 MiB. Support agent can't answer me the question where is hiding the rest 1,203 MiB... A database backup size may also be added if your hosting account creates one Maximilian Atlantis and SJ77 1 1 Link to comment Share on other sites More sharing options...
Maximilian Atlantis Posted May 1 Author Share Posted May 1 no it's shows 2 GB of 2 GB used, but the actual size in phpmyadmin is 812mb Link to comment Share on other sites More sharing options...
Randy Calvert Posted May 1 Share Posted May 1 1 minute ago, Maximilian Atlantis said: no it's shows 2 GB of 2 GB used, but the actual size in phpmyadmin is 812mb Unfortunately then you would need to ask your host to explain it. The IPB software itself does not control how database sizes are reported. They're the user of the database, not the administrator of it. Link to comment Share on other sites More sharing options...
Marc Stridgen Posted May 2 Share Posted May 2 Its not releasing space correctly unfortunately, so yes it would be your hosting company that would correct this. I tend to see this happen more on myisam than innodb, so thats certainly something that would be worth checking too (you should be using INNODB tables) Link to comment Share on other sites More sharing options...
Maximilian Atlantis Posted May 3 Author Share Posted May 3 Thank you Link to comment Share on other sites More sharing options...
Maximilian Atlantis Posted May 3 Author Share Posted May 3 Here is the provider answer This is an update about your database issue. B quota showing in our system is accurate based on the quota checked in the MySQL server. PHPMyAdmin delivers wrong values for database size if used with innodb tables. PHPMyAdmin ignores data_free for innodb tables, even though innodb is the only storage engine which delivers realistic values for this value . The phpmyadmin developers consider that everybody uses innodb with file_per_table = 0 . If this would be the case all innodb files would be located within the ibdata1 file and no space could be reclaimed. In this case it would kind of make sense to report 0 as value for data_free. To fix this issue, database table needs to be optimize. wegorz23 1 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted May 4 Share Posted May 4 Glad to hear you have an answer to your issue there Link to comment Share on other sites More sharing options...
Maximilian Atlantis Posted May 4 Author Share Posted May 4 Well... how can I optimize the database table? Link to comment Share on other sites More sharing options...
Jim M Posted May 4 Share Posted May 4 1 minute ago, Maximilian Atlantis said: Well... how can I optimize the database table? You would need to speak with your hosting provider as the items they mentioned there are MySQL server configuration, not things we would optimize via the table schema itself. Link to comment Share on other sites More sharing options...
Maximilian Atlantis Posted May 4 Author Share Posted May 4 They answeredI would like to inform you that there is no issue with the actual MySQL database structure. The quota showing on the database is correct. The only way to fix the issue is to optimize the tables on that particular database. You need to reconsider the cache table on this website as well. Link to comment Share on other sites More sharing options...
Jim M Posted May 4 Share Posted May 4 1 minute ago, Maximilian Atlantis said: They answeredI would like to inform you that there is no issue with the actual MySQL database structure. The quota showing on the database is correct. The only way to fix the issue is to optimize the tables on that particular database. You need to reconsider the cache table on this website as well. Unfortunately, then if the database quota is correct then you would need to upgrade your hosting so that you aren't limited to 2GB. The database table structure would be all which we can assist with, everything outside of that would be on your hosting provider to carry out their configuration and maintenance. Link to comment Share on other sites More sharing options...
Maximilian Atlantis Posted May 4 Author Share Posted May 4 So, how could you assist with the database table structure? Link to comment Share on other sites More sharing options...
Jim M Posted May 4 Share Posted May 4 28 minutes ago, Maximilian Atlantis said: So, how could you assist with the database table structure? I'm not sure what you mean, it doesn't sound like you have a structure issue because there are no errors on your community or issues with indexes being accessed, etc... That is essentially the structure of the database tables. The maintenance and configuration of the MySQL server would handle when these items essentially need to have "garbage collection" done because the data has been deleted by a query/code and the server hasn't necessarily cleaned the space up yet to be used elsewhere. Link to comment Share on other sites More sharing options...
Maximilian Atlantis Posted May 4 Author Share Posted May 4 thank you Link to comment Share on other sites More sharing options...
Adlago Posted May 4 Share Posted May 4 43 minutes ago, Maximilian Atlantis said: So, how could you assist with the database table structure? And you check through phpMyAdmin which of the tables in your database actually has a large size. There is such a column - size, in the list of tables, just scroll and you will find which table has a strangely large size. This will direct help reasoning to you in the direction of solving the issue Maximilian Atlantis 1 Link to comment Share on other sites More sharing options...
Recommended Posts