MariaDB 5.2 introduced the User Statistics feature.
 
Syntax
------ 
SHOW TABLE_STATISTICS
 
Description
----------- 
The SHOW TABLE_STATISTICS statement was introduced in
MariaDB 5.2 as 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
 
From MariaDB 10.0
 
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/