1 of 1

Information Schema TABLE_STATISTICS Table

The Information Schema TABLE_STATISTICS table provides usage statistics for tables, such as the number of rows read or changed.

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

Example

_{This page is licensed: CC BY-SA / Gnu FDL}

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 |
+--------------+------------+-----------+--------------+------------------------+

Information Schema TABLE_STATISTICS Table

hashtagExample

Information Schema TABLE_STATISTICS Table

hashtagExample

Example

Example