@davecoledave Could you please ask your host to increase the value of max_allowed_packet in my.cnf file and then try to load the page and check if it helps to fix the issue?
in [mysqld]
max_allowed_packet = 100G
and in [mysqldump]
max_allowed_packet = 500M
which should I increase?
@davecoledave Could you please increase the value for mysqldump?
I have increased it from 500M to 100G but still same page opening.
@davecoledave Could you send me a copy of your server’s PHP Error log?
You can find this log through your web hosting control panel (typically cPanel). If you are unsure where to find the PHP Error log, you can ask your hosts to provide it.
You can copy and paste the logs here https://pastebin.com and share the link with us.
Here is the Php error log: https://pastebin.com/1AX3ArfQ
Additionally, I use wp rocket and now my website database sql size is 36GB+
wp_options contains 36.1GB of size. It has thousands of rows with rocket_rucss_warmup_resource_fetcher_batch
May be this is the cause of 100% CPU load and wp optimize doesn’t load properly.
@davecoledave The error logs didn’t help much, I suspect the 36GB size of the wp_options table could be the issue, please check with wp rocket support and ask them if its okay to clean rocket_rucss_warmup_resource_fetcher_batch entries from the wp_options table, then you can clean the entries from phpMyAdmin and check if it helps to fix the issue.
They told me to clean those entries but I don’t know how to clean thousands of entries at once.
I have deleted all of them. Now working fine. Thank you
