# Server statistics - COM\_SET\_OPTION

**URL:** <https://forums.percona.com/t/server-statistics-com-set-option/320>\
**Category:** Other MySQL® Questions\
**Created:** [May 13, 2007, 1:24pm UTC](https://forums.percona.com/t/server-statistics-com-set-option/320 "2007-05-13T13:24:06Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![khast](https://avatars.discourse-cdn.com/v4/letter/k/f475e1/32.png) [@khast](https://forums.percona.com/u/khast)\
**Post date:** [May 13, 2007, 1:24pm UTC](https://forums.percona.com/t/server-statistics-com-set-option/320/1 "2007-05-13T13:24:06Z")

</div>

Hi all,

I used mysqlreport tool by [hackmysql.com](http://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