Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    New Coder
    Join Date
    Jun 2005
    Posts
    83
    Thanks
    2
    Thanked 0 Times in 0 Posts

    MySql error "max_questions"

    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!

  • #2
    UE Antagonizer Fumigator's Avatar
    Join Date
    Dec 2005
    Location
    Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant
    Posts
    7,691
    Thanks
    42
    Thanked 637 Times in 625 Posts
    This link to the MySQL manual may help you:

    http://dev.mysql.com/doc/refman/5.0/...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.

  • #3
    New Coder
    Join Date
    Jun 2005
    Posts
    83
    Thanks
    2
    Thanked 0 Times in 0 Posts
    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.

  • #4
    UE Antagonizer Fumigator's Avatar
    Join Date
    Dec 2005
    Location
    Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant
    Posts
    7,691
    Thanks
    42
    Thanked 637 Times in 625 Posts
    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 has been very very good to me-- unlimited domains, good customer service. Try em out.

  • #5
    New Coder
    Join Date
    Jun 2005
    Posts
    83
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Servage.net
    They have now offered me a max 80000 but I still can't monitir it.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •