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 recommend thoroughy testing on a production-like test system first before moving to production.
tags cloud
popular searches
free download for mysql database server 5.1.5, php, linux, gearman, bison, java, ubuntu, mysql, mysql mysql, install mysql, mysql initialization, source code, tools, install cairo, laptop
Similar Tutorials:
- Download all maatkit scripts through a single command
- all-schemas: Tool to run multiple SQL queries on a MySQL database server
- opensource-db-tools - A set of open source tools for MySQL
- How to install MySQL Gearman UDF on Ubuntu/Debian Linux
- MySQL Query Cache not necessarily a bad thing
Tutorials in 'Database Management Systems > MySQL' (more):
- How to delete rows in table when PK is referenced in another table
- Unique primary keys(PKs) for MySQL using Redis
- How to rename MySQL DB by moving tables
- How to set innodb_flush_log_at_timeout in MySQL 5.6?
- Is MySQL 5.6 slower than MySQL 5.5? No, it's faster
Comments (write a comment):
Great blog. Posted by: santa on Dec 20, 2012