My host has a 1Gb limit on out MySQL Database. This is fine as it sits around 200Mb on a normal day.
However. I activated the mobile theme. Activated AMP and within 24hours 900Mb of transients related to AMP were added to Wp_Options table before I realised what was going on. The transients all relate to AMP.
I ran a transient delete plugin. This removed them from table but only moved then to overhead in the database.
My host has placed a read lock on my database until I get it back below 1Gb.
But I can’t optimise the table to be rid of the overhead as the database is read / write locked!!!
So I have a 200Mb table and over 900Mb in overhead I can’t delete to recover access to my database.
Our host is kicking it up their support levels but it doesn’t look like they will help much.
As a news site we have been crippled for the weekend by not being able to add any articles as the database is in read / write state and WordPress is reporting all sorts of errors.
When the database is restored IF it is. Then I don’t the untold damage to the site.
Searching this forum other users have encountered the same transient and wp_options table issue in relation to AMP.
Where was the warning from TagDiv about transients and steps to take avoid these issues.
I DID try the mobile site and AMP on a test site. But obviously with reduced traffic on a test site. This issue did not appear.
Help!
Hi,
Please check this article about How to Manage and Delete Transients in WordPress -> https://www.wpbeginner.com/plugins/how-to-manage-and-delete-transients-in-wordpress/
You can check this article to: 7 Tips To Reduce WordPress Database Size -> https://www.webhostingsecretrevealed.net/blog/wordpress-blog/7-tips-to-reduce-wordpress-database-size/
Hope this will help you!
Tank you!
The response is disappointing.
You are suggesting i need to install and run a plugin manually every 24hrs to delete the excessive transients being created.
The second article also cannot help as the MqSQL database is in read lock situation.
I have had to export out and import in the tables into a new database and reconfigure wp_config just to get my site operational again.
The core issue here is that with mobile theme and AMP activated wp_options is being flooded with transients. 900mb worth inside 24hrs.
I am on my own searching clear i am not the sole person to have this issue:
https://forum.tagdiv.com/topic/the-amp-gate-is-becoming-a-nightmare/
https://forum.tagdiv.com/topic/what-this-in-wp-options-table-_transient_timeout_amp_img_/
I need TagDiv to know the problem, investigate and fix it.
There also seems to be wider issues with AMP ?
https://wordpress.org/support/topic/database-is-being-spammed-very-hardly-by-amp-plugin/
Hi,
I’ve note this problem on our investigation list and our developers will take a look to this problem.
Until the problem will be fix, you should use plugin that automatically delete the transients at one hour set.
Thank you!
Do you know if this issue is addressed in 9.7.4 ?
Hi,
There were some few modifications/fix for AMP in Newspaper v9.7.4 but I do not know if this one is treated by those changes, from what I can see this problem is still on our fix list, that means that there still need to be made some modifications in order to solve this problem entirely.
Thank you for your understanding!
No problem. I will hold off attempting the mobile elements until the fix is made. Thanks for the update.
