- Sep 10, 2010
- 11,811
- 26,653
This is strange. Looks like your wp_options table is huge, which shouldn’t really be unless you are using some kind of plugin to write to that table.I was able to connect with Putty and I am checking. On the other hand Cloudways support replied as follows:
I hope this message finds you well. We have again thoroughly investigated the issue, monitoring traffic statistics and reviewing slow page loads and database queries over the past few hours. While traffic statistics appear normal, we've identified some slow MySQL queries that may intermittently stress the server's resources. Please refer to the screenshot below for details:
To address this issue, we recommend optimizing your database. You may find plugins such as Breeze, WP-Optimize, or WP-Sweep useful for this purpose. Should you require further assistance, please don't hesitate to reach out to us again.
As I have Ezoic I don't know if I can use one of those Plugins, now I will check with Ezoic who makes use Leap. Any recommendation?
Perhaps try putting an index on option_name column if it is not there. That might require a little more ram but those queries should become a lot faster.
Same goes for the post meta table. I suspect your db is not setup properly. These db queries should not take more than a second or two.
Also make sure your mysql db is not acting up strange, like getting restarted frequently. This would also mean that the db setup has problems or cannot handle the current setup.
