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