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}