Need Help ASAP: High website traffic error message
1. Would a "corrupted database file" even make sense as a possible issue?
No, this doesn't make sense as it this was the issue, you would get the error consistently.
Probably the issue is that the client is on a shared hosting account with hundreds of other sites. And when the other sites get lots of traffic, the whole server hosting them all slows to the point of not being able to handle all the requests.
Can you ask the host how many other sites are hosted on the same server?
Also, when you are getting the error, run the _test_mysql.php script and note the time so you can let the host know you were getting a mySQL error running a standalone test script (send them a link to it). This way, they can't try to say it is a CMS Builder issue.
Hire me! Save time by getting our experts to help with your project.
Here's another thing you can try to determine which MySQL queries causing the problem.
- Download the "Developer Console" plugin here: https://www.interactivetools.com/add-ons/developer-console/
- Install it
- Go to: Admin > Plugins > Developer Console > MySQL Console
- Run this query: SHOW FULL PROCESSLIST
That will show you all the MySQL requests happening at the current moment, which might give us some clue as to what pages could be causing the problem. However, keep in mind that if it's a slow or overloaded server, even the most optimized pages are going to have problems.
Let us know what you find out, thanks!