My host (hostgator) sent me this email that I have excessive MySQL activity. I was told that it is most likely from a long-running process that locks a table, causing other queries to back up. I would like to fix this issue, as I cannot upgrade to a dedicated server. Here is the email for more info:
"Unfortunately, we have been forced to temporarily restrict access to MySQL. Please take a moment to review this email in full as it contains important information and resources to assist you in resolving this issue. Please note that while this restriction is temporary, you should take actions to resolve the issue(s) which may have caused it in order to avoid further down-time/permanent restrictions.
- How can you resolve the issue?
We have two solutions available. Moving the account to a dedicated server, which will allow far greater hardware resources or you may try following the basic recommendations for optimizing your database.
- Why did this happen?
Per our terms of service ([login to view URL]) a single hosting account may use no more than 25% of the entire server's resources. Accounts are typically not actively restricted until they exceed those resource limitations exceptionally. Unfortunately, in this instance, we were forced to place a temporary restriction on your user to prevent service issues with the server's over-all system performance.
Excessive MySQL activity is usually caused by:
A long-running process that locks a table, causing other queries to back up
A query that is not optimized (e.g. select all from and/or a large or complex query)
Large table copies/maintenance during peak hours"