Syntax
------

SHOW TABLE_STATISTICS

Description
-----------

The SHOW TABLE_STATISTICS statementis part of the User Statistics feature. It
was removed as a separate statement in MariaDB 10.1.1, but effectively
replaced by the generic SHOW information_schema_table statement. The
information_schema.TABLE_STATISTICS table shows statistics on table usage

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

URL: https://mariadb.com/kb/en/show-table-statistics/