MYSQL Query Limit Reached shutting down my site.
Posted 10 April 2011 - 08:22 PM
1226 - User 'wildvettes' has exceeded the 'max_questions' resource (current value: 75000)
select configuration_key as cfgKey, configuration_value as cfgValue from configuration
Should I switch hosts? Is it my website causing the problem? What steps should I take to switch hosts? What hosts does everyone use?
Posted 10 April 2011 - 09:12 PM
When I installed Mindsparx admin panel I must have just copied over because it deleted some of my addon files.
Long story short the Auto-Backup setup file was deleted, but the actual process itself and the code changes were still active. Basically it appears as though it was backing up my entire database constantly creating hundreds and hundreds of database backups.
Hopefully the problem will be rectified now.
*correction thousands and thousands*
Edited by wildvettes, 10 April 2011 - 09:16 PM.
Posted 10 April 2011 - 10:23 PM
Would like to know what steps you took to eliminate the issue. Because I get the same error and iPage told me after I exceed the limit, I have to wait one hour before I am able to access my site again. It is a very big pain in the ---! So if there is a fix, I would appreciate hearing about it, so that I will have not to look for another host.
Posted 10 April 2011 - 11:09 PM
My auto_backup_setup.php file was missing from my /admin/.
This allowed my auto_backup_db.php in my /admin/includes to run non-stop which was causing the query problems.
If you have this add-on I would check it is functioning properly first, if not you have something on your site caught in a check sql loop. I doubt your site could be busy enough to have thousands of customers an hour, but that is also a possibility.
Posted 11 April 2011 - 12:03 AM
What is even better was the fact that I have been away from my PC for the last 45 mins. So who exactly was doing the sql queries?
Edited by wildvettes, 11 April 2011 - 12:13 AM.
Posted 11 April 2011 - 12:31 AM
Otherwise I can't possible understand how I could be hitting 75,000 an hour. Unless something is going on with my host. I have all of the recommended security enhancements installed...is it possible the site has been hacked?
Nothing seems to be weird other than this message.
Posted 11 April 2011 - 02:41 AM