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

Tutorials > Database Management Systems > MySQL > Administration > 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.

Similar Tutorials:

• MySQL Performance Optimization Part II
• MySQL query to find all views in a database
• MySQL table_cache, information_schema, and open files limit
• How to find MySQL server uptime
• Initializing MySQL database after installation

Support Geeks Worldwide:

Link to us:

You can support us by putting a link to our website on your blog or website (code is below).

<a href="http://www.geeksww.com/">
Geeks Worldwide - Tutorials about Software Installation,
Configuration, Administration, Monitoring, Tools, Tips &
Tricks
</a>

OR a simple one.

<a href="http://www.geeksww.com/">
Geeks Worldwide - IT related Tutorials
</a>

Feedbacks:

We appreciate feedbacks and suggestions about our tutorials and Geeks Worldwide from readers. Please contact us using the form here and let us know what you think about the tutorial and the website in general.

Bookmark Us:

We are working on new features for the website, please keep visiting or bookmark us using your favourite bookmarking service.

Subscribe to RSS:

You can subscribe to our RSS feed here.