GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Server statistics - COM_SET_OPTION

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Server statistics - COM_SET_OPTION

    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
Working...
X