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