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?