MySQL tables statistics (size, engine, no. of rows etc.)

MySQL provides statistical data for users to get more knowledge about the tables in databases. The command to get this useful information is "mysql table status".

SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr]

Assuming you have selected a database and run the following command:

SHOW TABLE STATUS LIKE '%'

MySQL returns information about all the tables in the selected database. For more info about what MySQL returns, click here. If you want to see information about a particular table in a particular database then you run the command as follows:

SHOW TABLE STATUS FROM <database name> LIKE '<table name>'

Replace <database name> with your database name and <table name> with the table name.

Did this tutorial help a little? How about buy me a cup of coffee?

Please feel free to use the comments form below if you have any questions or need more explanation on anything. I do not guarantee a response.

IMPORTANT: You must thoroughy test any instructions on a production-like test environment first before trying anything on production systems. And, make sure it is tested for security, privacy, and safety. See our terms here.

Great blog. Posted by: santa on Dec 20, 2012

Similar Tutorials:

• Download all Aspersa MySQL tools/scripts through a single command
• How to find if MySQL supports partitioning or not?
• all-schemas: Tool to run multiple SQL queries on a MySQL database server
• MySQL query to find all views in a database
• Fast, parallel restore from SQL dumps (mysqldump) for MySQL

Tutorials in 'Database Management Systems > MySQL' (more):

• What should be monitored on a busy Database/MysQL server?
• How to speed up a Mysql replica?
• The server requested authentication method unknown to the client [phpmyadmin]
• How to set default values for MySQL JSON columns
• How to delete rows in table when PK is referenced in another table

Recent Tutorials:

• How to create and maintain a fixed length queue in dart?
• What should be monitored on a busy Database/MysQL server?
• Options to store data locally in a flutter app
• Dart - x positional argument(s) expected, but 0 found.
• ?? - the null-coalescing operator in Dart