Link to home
Start Free TrialLog in
Avatar of Eduardo Fuerte
Eduardo FuerteFlag for Brazil

asked on

Could you give an explanation on what is causing this MySQL error "exceeded the max_questions resource" ?

Hi Experts

Could you give an explanation on what is causing this MySQL error "exceeded  the max_questions resource" ?



I'm using MySQL 5.6 and before I had configured it out with:

GRANT USAGE ON  database_name.*
TO 'root'@'localhost'
WITH MAX_QUERIES_PER_HOUR 1000
MAX_CONNECTIONS_PER_HOUR 100;

Open in new window


That wasn't sufficient.

So, what  differentes:

max_questions resource that couldn't be resolved with:   MAX_QUERIES_PER_HOUR and  MAX_CONNECTIONS_PER_HOUR ?

How to manage this situation?

Thanks in advance.
SOLUTION
Avatar of David Favor
David Favor
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Eduardo Fuerte

ASKER

Hi David

That's make sense.
I'm using MySQL 5.6 so the commands doesn't correctly runs. Could you point the correspondent commands?
(I'm trying to find also)
So what I use is:

GRANT ALL ON database_name.* TO 'root'@'localhost'
         WITH MAX_QUERIES_PER_HOUR 0
              MAX_UPDATES_PER_HOUR 0
              MAX_CONNECTIONS_PER_HOUR 0
              MAX_USER_CONNECTIONS 0

Open in new window

ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
So, I guess the command I used is sufficient, isn't it?
Hi

After a few days no problems arrives.
I guess the command applied is OK.
Any other suggestions?
Do you have the same SQL error message now?
I didn't have.

Since this message occurs when to much connections / queries/ updates are done in a hour.

The users didn't notice any other messages until now. I think is ok, sufficient.
Thank you for help.