The TABLE_STATISTICS table

The TABLE_STATISTICS table holds accrued counters of handler operations for each table in the table definition cache. The counters are incremented for each specific operation on a handler instance and once the handler instance is closed, the counters are accrued in the table definition stored in the definition cache. If the table definition is altered or flushed, the counters are lost.

Column name	Description
TABLE_SCHEMA	The database containing the table.
TABLE_NAME	The table name.
HANDLER_READ_FIRST	The number of times the first entry in an index was read.
HANDLER_READ_LAST	The number of requests to read the last key in an index.
HANDLER_READ_KEY	The number of requests to read a row based on a key.
HANDLER_READ_NEXT	The number of requests to read the next row in key order.
HANDLER_READ_PREV	The number of requests to read the previous row in key order.
HANDLER_READ_RND	The number of requests to read a row based on a fixed position.
HANDLER_READ_RND_NEXT	The number of requests to read the next row in a table.
HANDLER_DELETE	The number of requests to delete a row in a table.
HANDLER_UPDATE	The number of requests to update a row in a table.
HANDLER_WRITE	The number of requests to insert a row in a table.