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.

Please feel free to use the comments form below if you have any questions or need more explanation on anything.

Tags

mysql, database, table, table-status, size,

Popular Searches

php, linux, mysql, ubuntu, mysql mysql, tools, install mysql, gearman, source code, java

more>>

Comments (write a comment):

0 comments so far. Be the first one to leave a comment on this article.

 

Comment
 

 
| Members | Support Us | Using this site means you accept its terms | Contact Us | Site Map |