Information Schema INNODB_SYS_TABLESTATS Table
The Information Schema
INNODB_SYS_TABLESTATS table contains InnoDB status information. It can be used for developing new performance-related extensions, or high-level performance monitoring.
PROCESS privilege is required to view the table.
Note that the MySQL InnoDB and Percona XtraDB versions of the tables differ (see XtraDB and InnoDB).
It contains the following columns:
|Table ID, matching the INNODB_SYS_TABLES.TABLE_ID value.|
|Database name (XtraDB only).|
|Table name, matching the INNODB_SYS_TABLES.NAME value.|
|Estimated number of rows currently in the table. Updated after each statement modifying the data, but uncommited transactions mean it may not be accurate.|
|Number of pages on disk storing the clustered index, holding InnoDB table data in primary key order, or |
|Number of pages on disk storing secondary indexes for the table, or |
|Number of rows modified by statements modifying data.|
|Countdown to zero, when table metadata can be removed from the table cache. (InnoDB only)|