Hi,
We have huge issues since october 2021. The td_011_settings and td_011 entries in the wp_options table are around 150 MB of size in total. This couldn’t be right and shouldn’t happen. Because ‘autoload’ is on this amount of data is being loaded on every page load with huge mysql timeouts as a result.
Please see also this screenshot of the database:
What is the best way to deal with this?
Thanks!
Hi,
Those 2 tables are from the theme, in them are saved all the changes that are made in the theme panel, pages and cloud templates. Also are saved the theme panel backups -> https://forum.tagdiv.com/import-export-theme-settings/ now there was added an option to stop the backups and even to delete the existent backups -> https://i.imgur.com/iGPDCVq.png
I hope this will help to reduce the database.
Thanks Calin,
I’m having trouble to load that specific tab in the theme settings. Probably because of the huge amount of data. Is there a way available to do this via PHPMyAdmin, through a filter or action or via the wp-cli?
Thanks!
Hi,
Yes, this can be done via PHPMyAdmin, but I do not recommend it, because if you do not have experience with this you can damage the database and the website will go down. But, in case that you have skills or you have someone that can handle this, then make sure that you make a full backup for your database, then go in PHPMyAdmin in wp_options and search for td_011_settings then just cut/delete the date from there. But place notice that if you are using standard template this can back the website layout (in this case set back the backup).
Thank you!
Is there any way to change this via the child theme code?
Thanks
Hi transcontinentaltimes,
Unfortunately, we do not have a code that can be applied in the child theme and this to remove the data from database. I believe it can be done, but I I believe that it is more danger then editing the database via PHPMyAdmin.
Thank you!
