• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1066
  • Last Modified:

MySQL Statistics - Total number of SET queries - The variable Com_set_option

Hello,
what exactly means the global variable Com_set_option and what could possibly
cause its high value? Our server shows the value of set_option much higher then other
usual types of queries (select, delete, update, insert)...

SHOW GLOBAL STATUS LIKE 'Com_se%';
+----------------+-----------+
| Variable_name  | Value     |
+----------------+-----------+
| Com_select     | 70734941  |
| Com_set_option | 443627648 |
+----------------+-----------+

Thanks,
A24Expert
0
a24expert
Asked:
a24expert
1 Solution
 
Tomas Helgi JohannssonCommented:
           Hi!

This variable shows how many times the SET command has been issued
http://dev.mysql.com/doc/refman/5.1/en/set-option.html
and that counter should be higher than com_select counter as set command is usually issued
more often than a select,update,insert or delete statement within a single transaction.
http://dev.mysql.com/doc/refman/5.1/en/mysql-proxy-scripting-structures.html

Hope this helps.

Regards,
   Tomas Helgi
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now