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

Category:

Tutorials > Database Management Systems > MySQL > Administration

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?

Buy me a coffee at ko-fi.com

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.

Comments (write a comment):

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

leave a comment on tutorial leave a comment