Maximilian Atlantis

found one more useless solution https://www.ionos.com/help/hosting/troubleshooting-mysql-databases/optimizing-mysqlmariadb-databases-to-prevent-exceeding-the-capacity-limit/ It grow one mb per day... even if I delete old posts... the problem was a long time ago Tech support made sometning and it grow again

Here is the techsupport answer Тhank you for reaching out regarding the persistent issue with your database size. I appreciate your patience, and I understand the importance of resolving this matter. Upon escalating the issue to our 2nd level support, here's what they were able to investigate: The discrepancy in the database size quota displayed in PHPMyAdmin compared to the Hosting Control Panel (HLT/CP) is likely due to the predominant use of InnoDB tables. InnoDB is the default storage engine for MySQL 5.7, and PHPMyAdmin may not accurately account for the space usage in InnoDB tables, particularly the data_free value. Here's a simplified explanation: InnoDB tables, which you likely use, have a high amount of "bloat" or data_free. PHPMyAdmin does not consider the data_free value for InnoDB tables, leading to a discrepancy in reported sizes. The reported size in HLT/CP is accurate based on the quota checked in the MySQL server. To resolve this issue, our recommendation is to optimize your database tables. This process involves reclaiming space by rewriting the tables, which is a normal database maintenance task. Unfortunately, database optimization is not within the scope of support provided by IONOS. Here are the suggested steps: 1. Access your PHPMyAdmin or database management tool. 2. Identify and optimize the InnoDB tables in your database. If you are not comfortable performing these steps or require further assistance, I recommend consulting with a web developer or a database administrator. They will be able to guide you through the optimization process and ensure that your database operates efficiently. Should you have additional questions or need further clarification, feel free to reach out. We appreciate your understanding and cooperation as we work towards a resolution.

This is doesn't work. All the sizes correct in DB

thank you

So, how could you assist with the database table structure?

They answered I 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.

Well... how can I optimize the database table?

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.

Thank you

no it's shows 2 GB of 2 GB used, but the actual size in phpmyadmin is 812mb

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...

Everything is working, thank you!

I've renamed plugins folder and renamed it back - and it's working now!

PHP 8.2 MySQL 5.7

I've update it manually - it doesn't work https://avvadon.org/forum/ Fatal error: Cannot use "parent" when current class scope has no parent in /homepages/42/d205474031/htdocs/avvadon/forum/system/Theme/Theme.php(2703) : eval()'d code on line 37