Solved

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

Posted on 2011-03-22
3
939 Views
Last Modified: 2012-05-11
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
Comment
Question by:a24expert
3 Comments
 
LVL 25

Accepted Solution

by:
Tomas Helgi Johannsson earned 500 total points
ID: 35219063
           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
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 37319191
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating and Managing Databases with phpMyAdmin in cPanel.
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question