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.

The 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:

ColumnDescription
TABLE_IDTable ID, matching the INNODB_SYS_TABLES.TABLE_ID value.
SCHEMADatabase name (XtraDB only).
NAMETable name, matching the INNODB_SYS_TABLES.NAME value.
STATS_INITIALIZEDInitialized if statistics have already been collected, otherwise Uninitialized.
NUM_ROWSEstimated number of rows currently in the table. Updated after each statement modifying the data, but uncommited transactions mean it may not be accurate.
CLUST_INDEX_SIZENumber of pages on disk storing the clustered index, holding InnoDB table data in primary key order, or NULL if not statistics yet collected.
OTHER_INDEX_SIZENumber of pages on disk storing secondary indexes for the table, or NULL if not statistics yet collected.
MODIFIED_COUNTERNumber of rows modified by statements modifying data.
AUTOINCAuto_increment value.
REF_COUNTCountdown to zero, when table metadata can be removed from the table cache. (InnoDB only)
MYSQL_HANDLES_OPENED(XtraDB only).
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.