Innodb statistics
- by user64204
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?
