• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1087
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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