Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
up vote 1 down vote favorite

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

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

http://img3.imageshack.us/img3/2448/screenshot20120912at101.png

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.

Thanks!

share|improve this question
2  
What leads you to believe that the mysql configuration is your bottleneck? Have you tried running mysqltunner.pl 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? – Clustermagnet Sep 13 '12 at 5:46
1  
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! – Clustermagnet Sep 13 '12 at 5:58

1 Answer

up vote 0 down vote

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.

https://dev.mysql.com/doc/refman/5.5/en/user-resources.html

Hope it helps!

share|improve this answer

Your Answer

 
discard

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.