Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a web server which is quite heavy on the mysql server:

Here is a graph of questions being executed on the database:

Is there a way to increase the max questions allowed? You see how the graph tops off and stays around 5K while the web server is active?

Yes, other things are being done on the code side of things, just wondering what we can do in my.cnf. All tables are already being served from /dev/shm.


share|improve this question
What leads you to believe that the mysql configuration is your bottleneck? Have you tried running for example? Have you collect any cpu/ram/io stats? – Zoredache Sep 13 '12 at 5:34
Yes, absolutely, like I said, other things being done. Do you know what "questions" graph means? – CMag Sep 13 '12 at 5:46
a question is pretty much a command run.. so a select/update/delete and so on.. so there is no variable that sets the # of "questions" per minute. You are maxing out somewhere else and need to find that point. – Mike Sep 13 '12 at 5:51
so that graph is value per minute? Will investigate! thanks! – CMag Sep 13 '12 at 5:58

It is possible that there is a limit set on the number of queries a particular user is able to run per minute, and if your web service logs in to the database using the same user id for all queries, you may be hitting that limit.

Check this page out for more information, it will show you how to check and alter those limits on your system.

Hope it helps!

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.