| Server statistics - COM_SET_OPTION [message #1249] |
Sun, 13 May 2007 14:54 |
 khast
Messages: 1
Registered: May 2007
Location: Russia |
Junior Member |
|
|
Hi all,
I used mysqlreport tool by hackmysql.com to examine possible bottlenecks of my production server. It summarizes output of SHOW GLOBAL STATUS and prints it human-readable form  . It is mentioned in documentation for this tool that normal server workload consist primarily of DMS commands (insert, select, update etc), so non-DMS Com_ commands should be minor part of client request. But in my case I received, that "non-DMS" Com_ commands are 71% of all requests.
When I studied output of SHOW GLOBAL STATUS, I've discovered that the most frequent is Com_set_option (440M counts out of 970M of Questions).
What exactly this command means and should I worry about such a low rate of DMS commands if overall Questions count (~ 8%)?
Thank you in advance
good luck,
khast
|
|
|
Members
Search
Help
Register
Login
Home
