When activating the amp version on my site I noticed that it was very slow, so when checking the database, I noticed that there were many transients related to the amp images.
Every time I deleted the transients they came back, so I had to deactivate the amp version and to remove all trasients that were inflating my database that was over 1 gigabyte, I made the following command
SELECT *
FROM wp_options
WHERE autoload = ‘no’
AND option_name LIKE ‘% _transient_timeout_amp%’
My cpu usage was about 66% and after removing the transients dropped to 5%
I wonder if you already have a solution to this absurd amount of transients that is created in the database wp-options, which often causes sluggishness and sometimes even causes errors like “Error connecting to database “
Hello !
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.
More informations that could be helpfull can be found here: https://forum.tagdiv.com/topic/amp-wp_options-transients/
Thank you!
