Solved

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

Posted on 2011-03-22
3
962 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
Foreword This article was written many years ago, in the days when PHP supported the MySQL extension (http://php.net/manual/en/function.mysql-connect.php).  Today (http://php.net/manual/en/migration70.removed-exts-sapis.php) you would not use MySQL…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

751 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