Syntax\n------\n\nSHOW TABLE_STATISTICS\n\nDescription\n-----------\n\nThe 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.\n\nThe SHOW TABLE_STATISTICS statement is part of the User Statistics feature. The information_schema.TABLE_STATISTICS table shows statistics on table usage.\n\nThe 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.\n\nExamples\n--------\n\nSHOW TABLE_STATISTICS\\G\n************************ 1. row *********************\n           Table_schema: mysql\n             Table_name: proxies_priv\n              Rows_read: 2\n           Rows_changed: 0\nRows_changed_x_#indexes: 0\n********************* 2. row *********************\n           Table_schema: test\n             Table_name: employees_example\n              Rows_read: 7\n           Rows_changed: 0\nRows_changed_x_#indexes: 0\n********************* 3. row *********************\n           Table_schema: mysql\n             Table_name: user\n              Rows_read: 16\n           Rows_changed: 0\nRows_changed_x_#indexes: 0\n********************* 4. row ************************\n           Table_schema: mysql\n             Table_name: db\n              Rows_read: 2\n           Rows_changed: 0\nRows_changed_x_#indexes: 0\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-table-statistics