Hello, My hosting says that our theme has too many requests to the database, and to prevent an over-load server, our phpMyAdmin auto change password — then I need to reset the password to continue to work, but after a short time, I have the same problem. How to fix this issue
Hi,
Please let me know what php and theme version you have.
Also, please scan your website for malware.
Thank you!
No Malware Found
WP version 6.4.1
Theme version 12.6.2
PHP Version 7.4.13
Server software LiteSpeed
max_execution_time 300
max_input_vars 10000
Cache Plugin: LiteSpeed Cache
Redis: Enabled
Also, I just Paid for Cloudflare Cache to reduce load
Email to support send title: Too many requests to the database problem
Hi,
What we can suggest is to update the php version to v8.1 or v8.2 to have compatibility with WordPress version – https://wordpress.org/news/2023/10/wordpress-6-4s-php-compatibility/
Thank you!
Hello,
Thank You for the suggestion. I just changed the PHP version to v8.2
But this is the same problem: my database keeps disconnectig đ
On my cPanel, I just enabled hotlinking protection, and the website started working again, I have no clue if, at the same time, my host did something or this hotlinking cut access to my images – but this can be related somehow to the database load. ???
Hi,
Indeed the hotlinks can interfere and make extra request to display something on your website, when that option was enabled all those hotlinks have been blocked so the request to database that have been made by does now are stopped.
Thank you!
It looks like My host found the problem; this is what they send to me:
——
We have identified a query that causes high load and leads to blocking. This query is executed during the publication of a new post, as it additionally indexes all previous posts.
The problem seems to be typical for large WordPress sites. There are plugins created for WP that change the indexing method, improving query performance, for example: https://wordpress.org/plugins/index-wp-mysql-for-speed/
From our side, we can offer you a dedicated MySQL server.
—–
Can You confirm that https://wordpress.org/plugins/index-wp-mysql-for-speed/ can resolve this problem? or maybe you have a better solution?
And what do you think about dedicated MySql? Did we need this, or plugin can to resolve this problem?
When we create a new post, MySql makes a huge load and disconnects our database.
Our WordPress has over 116.000+ posts
Hi Media_Ex, since you have over 116.000+ posts you’ll need to have a strong and dedicate server that provides optimizations for database, so yes, the mentioned plugin will help, I’m not sure if will resolve the problem, but it should been see better results.
My suggestion is to start with the plugin and after that to go to the dedicate mysql server (indeed this will provide better results then the plugin, but will come with additional costs).
Thank you!
Ok, Thank You, I will try….
Do you have A2 hosting?
