max_questions = 1 ??

[bdunning]

My site has been showing this for the past couple of days:

User 'mca_bdunning' has exceeded the 'max_questions' resource (current value: 1)

What does that mean?

[tbonekkt]

That value should be 72000, not 1. This is the second instance of this that I've come across. I just emailed admins to see what the problem is.

[bdunning]

Thanks Tom, you rule!

[tbonekkt]

In the meantime, you can try to create a new database user and use it in your scripts.

That database is on mysql01, correct?

[chiriko]

I've been seeing the same problem on my forums on server 03. This has been going on for four days now; the max_questions value is set serverside at 1. 1 != 72000. =( Our forums are down because of this, but it's on powweb's end.

I thought I'd wait a couple of days before posting on it, but it's been 4 days now and y'all don't seem to have noticed.

[jck]

Same happened to my site over last two days. Anyone know what happened?

[nwndl]

I have the same problem at www.nwndragonlance.net/forum

User 'jesus' has exceeded the 'max_questions' resource (current value: 1)

:(

[nwndl]

database is on mysql04

[Shin]

I have similar problem on mysql05
Error message I got:

Error : 1226 User 'user' has exceeded the 'max_questions' resource (current value: 60)

Site was down of course.

[jck]

It seems you have to change your username for the database even if the max_questions thingo is wrong, then it works again... hmmm

[Ayesha]

Hi

Since friday my web was experimenting database problems. When I tried to go to PHPMYAdmin, I get

Error : 1226 User 'user' has exceeded the 'max_questions' resource (current value: 60)

Sometimes the web works for minutes, and sometimes not.

My web is balanced with the 3 database users like the Threads of this forum says.

So I put 3 trouble tickets to Powweb and they say that is my application. I don't think is it, because my statistics are similar the past months and I have not high traffic the last 3 days.

Anyway I optimized the code a bit else, and the problem persist.

My database server is mysql15, and after look this thead I think is a Powweb problem with its servers, but when I put tickets, they say that the web is ok and close my tickets.

I'd like to know what is happening with the server and when the problem will be resolved, because my users are complaining.

Thanks

[chiriko]

I'd like to know what is happening with the server and when the problem will be resolved, because my users are complaining.

Thanks

Seconded. I did nothing out of the ordinary on my forum, nor did anyone else -- the error message explicity said that the max was *1.* Renaming the "offending" member solved the problem, but this is clearly an issue on Powweb's end, for so many users to be having the EXACT same problem across a disparate field of circumstances and applications.

[tbonekkt]

This is the work of the new mysql abuse automation that our admins have implemented. If your database and/or database user is adversely impacting the mysql server, the max_questions will automatically be reduced until the abuse on the server stops.

[Ayesha]

So what can we do?? 60 connections is a very drastic control. When we can have statistics about database use?

And most important, why you dont tell us about this "abuse automation"??

[tbonekkt]

So what can we do?? 60 connections is a very drastic control.Don't abuse the server and it won't affect you in any way. If you find yourself getting this error a lot, you need to find a way to optimize your scripts to not monopolize server resources. It is drastic control - but with this being shared hosting, one user and can (and does) affect all the other users on the server in question. We have to do what's in the best interest of the majority to keep service running as smoothly as possible.

[Ayesha]

I have not any other idea to optimize the code, and I'd like to know some database statistics, because the web worked good until friday, and in this months you never told me that it was consuming many resources.

You say it affect other users, but also is not fair you take this control without tell us about it, and I cant understand how my web, with only 9,000 users per day can cause this high traffic.

[tbonekkt]

and I cant understand how my web, with only 9,000 users per day can cause this high traffic.You're confusing two different things here though. Traffic doesn't necessarily correlate to abusing server resources or vice versa. A poorly written script with 1 visitor can use more server resources than a well-written script with 1000 visitors.

[Ayesha]

SO... Where can I get statistics??? how can I optimize something if I don't know how high it is??

And anyway, this is not fair. I was very complaced with your services since friday.

[tbonekkt]

What statistics?

[Ayesha]

About the use of my database, and the queries, so I can optimize the code.

I OPTIMIZED the mostly of the code before moving to Powweb, and I have 3 database users, so I'd like to know if is worth to review again the code or move to other site.

[tbonekkt]

If you want to measure the number of queries you're using, you'll need to build that into your scripts.

[Ayesha]

Please let me know exactly how does this "control" acts? when the connections are up to the limit, they are reset to 60? and when the 60 can be increment?

It is not clear to me.

[Shin]

This that I got from support:
Hello,

Our admins has corrected the issue and your site is now working again. Our

admins has a script running that will change the value of the max_question
to
60 if your scripts is causing a high load. Our script is then suppose to
change that value back to 7200 once the load drops. If you encounter this
problem again, you may want to optimize your scripts.

If you have any further questions, please do not hesitate to let us know.

First. They did not correct the issue. I created new user and my forum works fine now.
Second. The script that suppose to change that value back to 7200 once the load drops did not chage it back for about 48 hours despite the fact there were no queries at all from this user.
Third. I did not hit database limits for abut two years and I did not chage anything on my site for about two moths and I had average number of users last friday.


Now I am reading
This is the work of the new mysql abuse automation that our admins have implemented. If your database and/or database user is adversely impacting the mysql server, the max_questions will automatically be reduced until the abuse on the server stops.

Tom S. could you please notify the person who implemented the new mysql abuse automation that there is a chance, that this automation does not work as it suppose to work sometimes. I do not ask you to admit the problem here.
Thanks