The TABLE_STATISTICS
table was introduced in MariaDB 5.2.0 as part of the User Statistics feature.
The Information Schema TABLE_STATISTICS
table shows statistics on table usage.
This is part of the User Statistics feature, which is not enabled by default.
It contains the following columns:
Field | Type | Notes |
---|---|---|
TABLE_SCHEMA |
varchar(192) |
The schema (database) name. |
TABLE_NAME |
varchar(192) |
The table name. |
ROWS_READ |
int(21) |
The number of rows read from the table. |
ROWS_CHANGED |
int(21) |
The number of rows changed in the table. |
ROWS_CHANGED_X_INDEXES |
int(21) |
The number of rows changed in the table, multiplied by the number of indexes changed. |
SELECT * FROM INFORMATION_SCHEMA.TABLE_STATISTICS WHERE TABLE_NAME='user'; +--------------+------------+-----------+--------------+------------------------+ | TABLE_SCHEMA | TABLE_NAME | ROWS_READ | ROWS_CHANGED | ROWS_CHANGED_X_INDEXES | +--------------+------------+-----------+--------------+------------------------+ | mysql | user | 5 | 2 | 2 | +--------------+------------+-----------+--------------+------------------------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/information-schema-table_statistics-table/