SHOW TABLE_STATISTICS

View usage statistics for tables. This statement displays metrics like rows read, changed, and updated for each table.

Syntax

SHOW TABLE_STATISTICS

Description

Current

The SHOW TABLE_STATISTICS statement is part of the User Statistics feature. It was effectively replaced by the generic SHOW TABLE STATISTICS statement. The information_schema.TABLE_STATISTICS table shows statistics on table usage.

< 10.1.1

The userstat system variable must be set to 1 to activate this feature. See the User Statistics and information_schema.TABLE_STATISTICS articles for more information.

Example

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

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