Hello. We recently found out that we have a huge wp_options table (over 70 GB!!!) and over 12 000 000 rows are filled with td transients. I am attaching you a screenshot here: https://prnt.sc/E806MILYD0T0
We started to delete them batch by batch because, even if we have a cutting edge webserver, it is impossible to run a query to delete 12 M rows.
Can you help us in preventing this situation since, in the past few days, we had few server dropdown because of this?
We are using TagDiv Newspaper 12.7.1, which is the latest version, with tagDiv Composer, tagDiv Cloud Library, tagDiv Mobile Theme, Official AMP for WP and tagDiv Standard Pack plugins activated and updated to the latest build.
Also, we using WordPress LiteSpeed Cache plugin with Litespeed Webserver.
Hi,
That is huge. Those seem to be transients from the theme, are you using the cache option for the blocks? – https://prnt.sc/XYn0HmoOEei7 The theme creates hose transients when that cache option for the blocks is used. But normally the transients expire and are deleted automatically, and new ones are created. Maybe something is preventing them from being deleted and they keep pilling up.
I see you are using litespeed. I suggest clearing the transients immediately https://prnt.sc/iF9V5OMErmtY There should be a setting in the database section of the litespeed plugin.
Then I suggest disabling the cache option from he theme for all the blocks where you activated it, to stop generating new ones and repeat the problem again.
If you need help doing these please send us an email at contact@tagdiv.com and provide admin login for the website. But until we get to check, Please try to follow my instructions if possible.
Thanks.
