Innodb statistics

Posted by user64204 on Server Fault See other posts from Server Fault or by user64204
Published on 2012-04-16T09:04:56Z Indexed on 2012/04/16 11:33 UTC
Read the original article Hit count: 160

Filed under:
|
|
|
|

We're running InnoDB as a MySQL engine and using phpMyadmin to administer our database. Under Status -> Query statistics, phpMyadmin gives us the following:

enter image description here

We would like to know where these figures come from because we would like to create a Munin graph showing the evolution of these statistics over time.

When we run the SHOW STATUS; query here is what we get:

Innodb_rows_deleted 247555
Innodb_rows_inserted    822911
Innodb_rows_read    694934413
Innodb_rows_updated 15048

As you can see there is a substantial difference although both were taking almost at the same time.

Q: Do you know where phpMyadmin gets its values from?

© Server Fault or respective owner

Related posts about ubuntu

Related posts about mysql