Background of the issue:
I'm trying to find the reason as to why my site is really slow. I've noticed that the options table is 289 MB and when I check its latest, it shows transient translations. When I search for the amount of transient, I have a number of 6,332. The issue can be seen at hidden link.
Symptoms:
The options table is 289 MB, and there are 6,332 transient translations, which may be causing the site to be slow.
Questions:
Why is the options table so large?
How can I reduce the number of transient translations?
Hello!
Many plugins and themes store values in transients.
From your screenshot I cannot determine the size of the values.
Perhaps you can try and check the sizes with an SQL query like:
SELECT
option_name,
LENGTH(option_value) AS size
FROM
wp_options
WHERE option_name LIKE "_transient_%"
ORDER BY
size DESC
LIMIT 100;
On another note, WPML does not translate transients.
also the same page is cached multiple times with a different key not to mention that within the option_value is the entire html code of the page and it's autoload is set to off
I see that you have some strange transients called _transient_translated_html_
The size of a transient as far as I can see at the biggest entry is about 400kb
To my knowledge, WPML does not generate transient of that sort so you should probably check which plugin, part of theme or custom code is responsible for this transient.
Alternatively, if you are willing, you can provide us with a temporary Duplicator package so that we can take a look at the code that your site is using and determine this.
