Eduardo Fuerte
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:
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.
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;
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
So, I guess the command I used is sufficient, isn't it?
ASKER
Hi
After a few days no problems arrives.
I guess the command applied is OK.
Any other suggestions?
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?
ASKER
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.
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.
ASKER
Thank you for help.
ASKER
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)