Mysql – display row count and size of tables

on

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%'

Suggested posts:

  1. Display keys added to ssh-agent using ssh-add
  2. Install php 7 on Amazon Linux 2
  3. How to kill unresponsive ssh session using escape sequence
  4. WordPress – get posts/pages with missing meta key
  5. Mysql 5.7 root password after installation
  6. Git – rename local branch
  7. AngularJS format date using date filter
  8. prevent wordpress xmlrpc.php attack
Share this article: share on facebook share on linkedin tweet this submit to reddit
Posted in | Tagged , ,