Home / server / Questions / 426960
In Process
CMag
Asked: 2012-09-13 21:17:55 +0800 CST

mysql questions variable

  • 772

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!

mysql

1 Answers

  1. 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!

    • 0