View usage statistics for tables. This statement displays metrics like rows read, changed, and updated for each table.
SHOW TABLE_STATISTICSThe SHOW TABLE_STATISTICS statement is part of the feature. It was effectively replaced by the generic SHOW TABLE STATISTICS statement. The table shows statistics on table usage.
The SHOW TABLE_STATISTICS statement is part of the feature. The table shows statistics on table usage.
The system variable must be set to 1 to activate this feature. See the and articles for more information.
This page is licensed: CC BY-SA / Gnu FDL
SHOW TABLE_STATISTICS\G
*************************** 1. row ***************************
Table_schema: mysql
Table_name: proxies_priv
Rows_read: 2
Rows_changed: 0
Rows_changed_x_#indexes: 0
*************************** 2. row ***************************
Table_schema: test
Table_name: employees_example
Rows_read: 7
Rows_changed: 0
Rows_changed_x_#indexes: 0
*************************** 3. row ***************************
Table_schema: mysql
Table_name: user
Rows_read: 16
Rows_changed: 0
Rows_changed_x_#indexes: 0
*************************** 4. row ***************************
Table_schema: mysql
Table_name: db
Rows_read: 2
Rows_changed: 0
Rows_changed_x_#indexes: 0