473,320 Members | 1,865 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

SHOW STATUS confusion

Hi Group,

Im running a mysql+php+apache server and i tried do gather some
statistics for an rrd. Therefore i call "show status" on the server.
My Problem are the Com_* results and the Total Questions.
(see http://www.mysql.com/doc/en/SHOW_STATUS.html)

This is the result for Com_*:
| Com_admin_commands | 21134 |
| Com_change_db | 23488 |
| Com_delete | 9 |
| Com_insert | 9033 |
| Com_select | 23621 |
| Com_show_databases | 1 |
| Com_show_fields | 7 |
| Com_show_keys | 1 |
| Com_show_processlist | 1 |
| Com_show_status | 28 |
| Com_show_tables | 5 |
| Com_show_variables | 1 |
| Com_truncate | 2 |
| Com_update | 4923 |
.... all other Com_* are 0

and:
| Questions | 61735 |

How does this fit together ?
I know there are many Com_change_db's because the mysql lib in PHP is
calling this very frequently.
But what is Com_admin_commands ? Why is this that high ? It is
obvously not including Com_change_db because Com_change_db is bigger
than Com_admin_commands ...

and when i sum up all the Com_*'s without Com_admin_commands, i get
61120.
with Com_admin_commands is get 82254.
and with Com_admin_commands but without Com_change_db i get 58766.

But total amount of questions is 61735 ???

i just dont get it ...

any clue ?

Thanks a lot,

-Max
mt******@ph.tum.de
Jul 19 '05 #1
2 6547
If anyone is interrested, i found out by greping the source:

Com_admin_commands includes:
COM_TABLE_DUMP
COM_CHANGE_USER
COM_BINLOG_DUMP
COM_SHUTDOWN
COM_PING
COM_DEBUG

Questions includes everything WITHOUT:
COM_STATISTICS (this is "mysqladmin status" only)
COM_PING

If you sum up all Com_* WITHOUT Com_admin_commands you should get a
value smaller than Questions, because at least COM_TABLE_DUMP,
COM_CHANGE_USER, COM_BINLOG_DUMP, COM_SHUTDOWN and COM_DEBUG (and
probably some more ?) are missing.
If you sum up all Com_* WITH Com_admin_commands you should get a value
(probably) higher than Questions, because COM_PING is not included in
Questions.

In my case 82254-61120=21134 are missing ... quite a lot ... probably
php is calling COM_CHANGE_USER frequently OR there are some commands
in Questions which dont appear ind Com_* at all OR Questions includes
wrong Commands (like syntax errors, etc.) ?

-Max
mt******@ph.tum.de
Jul 19 '05 #2
If anyone is interrested, i found out by greping the source:

Com_admin_commands includes:
COM_TABLE_DUMP
COM_CHANGE_USER
COM_BINLOG_DUMP
COM_SHUTDOWN
COM_PING
COM_DEBUG

Questions includes everything WITHOUT:
COM_STATISTICS (this is "mysqladmin status" only)
COM_PING

If you sum up all Com_* WITHOUT Com_admin_commands you should get a
value smaller than Questions, because at least COM_TABLE_DUMP,
COM_CHANGE_USER, COM_BINLOG_DUMP, COM_SHUTDOWN and COM_DEBUG (and
probably some more ?) are missing.
If you sum up all Com_* WITH Com_admin_commands you should get a value
(probably) higher than Questions, because COM_PING is not included in
Questions.

In my case 82254-61120=21134 are missing ... quite a lot ... probably
php is calling COM_CHANGE_USER frequently OR there are some commands
in Questions which dont appear ind Com_* at all OR Questions includes
wrong Commands (like syntax errors, etc.) ?

-Max
mt******@ph.tum.de
Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Maximilian Treiber | last post by:
Hi Group, Im running a mysql+php+apache server and i tried do gather some statistics for an rrd. Therefore i call "show status" on the server. My Problem are the Com_* results and the Total...
0
by: John Yasaitis | last post by:
I seem to have replication set up correctly to only replicate one database named vmail.* Except when I try to update a table in vmail.* the changes do not replicate to the slave. Authentication...
0
by: Jerry | last post by:
The "SHOW TABLE STATUS" command seems to return a result set, just like "SELECT * FROM SomeTable". Therefore, since the following is valid: SELECT * FROM (SELECT * FROM SomeTable) I...
13
by: genetic.error | last post by:
I'm moving from Vb6 to VB.Net. I have a feeling this has come up before... The VS.Net MSDN file seems to state that the following should work: Form1.Show Form1.Visible = True Form1.Hide...
0
by: Homa | last post by:
Hi I'm working on a program that will have 3 forms: a main form, a status form and a sub-form. The main form and status form are always appear, and my sub-form is a singleton (for performance...
9
by: Simon Wigzell | last post by:
I have a little asp progress bar window that I open up with javascript, sized and located, all the extras turned off. It works by refreshing itself every second and displaying how much a file...
3
by: Jimmy | last post by:
I use a combo box to filter the results of a form. Sql for combo box is... SELECT StatusPriority, Status FROM tblStatus UNION Select = 0 as AllChoice, "Show All" as Bogus From tblStatus ORDER...
1
by: runway27 | last post by:
hi I am using MySQL - 4.1.22 when i use the following sql query $result = mysql_query("SHOW tablename STATUS FROM databasename;"); i have also tried = $result = mysql_query("SHOW tablename...
2
by: Sudhakar | last post by:
hi I am using MySQL - 4.1.22 when i use the following sql query $result = mysql_query("SHOW tablename STATUS FROM databasename;"); i have also tried = $result = mysql_query("SHOW tablename...
5
by: canajien | last post by:
I am trying to get a script to show a particular image when a field value = 1, otherwise it will show something else, and this is what I came up with: $i=0; while ($i < $num) { ...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.