Portal Home > Knowledgebase > Articles Database > limit mysql?
limit mysql?
Posted by yah0m, 05-15-2009, 11:01 AM |
basically, i dont want clients taking the servers I/O and server load over 4.00 when they do major update ect... querys on sql. is there a way to limit the ammount they can do?
|
Posted by Ranthalas, 05-15-2009, 11:09 AM |
Yes there is. You can limit each mysql user to a particular amount of queries per time frame, connections per time frame etc. Below is a link the the Mysql Reference Manual detailing the proper syntax:
http://dev.mysql.com/doc/refman/5.0/...resources.html
|
Posted by yah0m, 05-15-2009, 05:04 PM |
thanks.
also, how can i track queries and maybe find ones that take a long time to execute/run?
|
Posted by ServerManagement, 05-15-2009, 06:54 PM |
You can enable the slow query log in mysql and that will track it for you
|
Posted by yah0m, 05-16-2009, 01:12 AM |
do i need to assign a log file? and whats a good value for the slow query?
|
Add to Favourites Print this Article
Also Read