MySQL Max Queries...I think there's a server problem. [Archive]

BrainSlushy

7-5-04, 04:31 AM

I've run into the max queries problem many times over the last year. I updated my forum config to use the three users as described in the sticky thread and that has worked fine and without incident over the last several months. However today, at approx 8pm EST I noticed I was getting the 'SQL Error : 1226 User 'ardatabase' has exceeded the 'max_questions' resource (current value: 72000)' error. I am only getting this one 2 of the 3 usernames I have setup to connect to the database. But here's my concern...its now 4:30 AM EST and I'm still experiencing the same problem. I know that I don't have any user load at this time of the day, except for maybe myself or one or two others at most. I thought this was supposed to reset after 60 minutes. Has that value changed? Is there something wrong with the server? Is there a way I can tell if I have user sitting out there just clicking refresh over and over and over again?

Any thoughts? Thanks.

HalfaBee

7-5-04, 04:38 AM

You might have to email support@powweb.com , the mysql server must have a slight problem.
It normally resets every hour, but problems somtimes occur.

For a temp fix try deleting the user causing the problem and add a newuser with a different name.
You will have to change any scripts using the changed user.