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