InnoDB as a MySQL engine and using phpMyadmin to administer our database. Under
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?