...

View Full Version : MySql error "max_questions"



bzzrd2
04-09-2007, 12:39 AM
Can someone help me undersand the max errors parameter on a MySql database? I'm getting #1226 - User 'XXXXXX' has exceeded the 'max_questions' resource (current value: 50000) Now I understand that it is a value put in by the databse admin. so as to not flood the server. Thing is, I get the message after inputting only 10 - 20 fields. They are only city names and streets. The site is not "live" so there are no other visitors. What does the 5000 mean? This did not happen with my last host. Thanks!

Fumigator
04-09-2007, 06:39 PM
This link to the MySQL manual may help you:

http://dev.mysql.com/doc/refman/5.0/en/user-resources.html

The max_questions is the maximum queries your account can do in an hour. It's set at 50,000. You are apparently doing a lot of queries that you don't realize you're doing, or your hosting company has MySQL configured wrong and you are sharing your user with other accounts, or something similar. If you can't track down in your scripts anywhere you are doing 50,000 queries, contact your hosting company and ask them about it.

bzzrd2
04-11-2007, 04:34 AM
Well, no way are my scripts doing 50,000 transaction per hour. Got hold of the host who gave me the runaround. After many times back and forth they told me to go into "My processes" in PHPMYadmin and it will give me details of the SQL queries. Well, it showed nothing but " SQL Query - SHOW PROCESSLIST. They have basically said " oh well" I was going to dump this host but discovered they only have a 5 day money back guarantee. (most have 1 month) Oh well, live and learn. Thanks Fumigator.

Fumigator
04-11-2007, 05:41 PM
Who is your hosting company, so we can all avoid them? That kind of customer service should put a company out of business just from word-of-mouth alone. And a 5 day refund period? Boo to them.

Hostmonster.com (http://www.hostmonster.com/track/onlinefamilyconnection/cf) has been very very good to me-- unlimited domains, good customer service. Try em out.

bzzrd2
04-16-2007, 05:27 PM
Servage.net
They have now offered me a max 80000 but I still can't monitir it.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum