The TABLE_STATISTICS table

darnaut edited this page Feb 4, 2013 · 2 revisions

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.