Mysql – display row count and size of tables

Mysql SHOW TABLE STATUS command can be used to display information about all or specified tables in mysql db. Here are some examples:

Show status of all tables

SHOW TABLE STATUS 


Here is the sample outcome
mysql-show-table-status

Show table status of tables matching pattern in specific db

SHOW TABLE STATUS FROM db_name LIKE 'pattern'
e.g.
SHOW TABLE STATUS FROM mydb LIKE 'table_prefix%'
Share this article: share on Google+ share on facebook share on linkedin tweet this submit to reddit

Comments

Click here to write/view comments