MariaDB 5.2 introduced the User Statistics feature.
SHOW TABLE_STATISTICS
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.
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
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/show-table_statistics/