SHOW STATUS confusion

[Maximilian Treiber]

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

[Maximilian Treiber]

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

[Maximilian Treiber]

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