View the amount of space occupied by each table in the MySQL database

Server operations, often want to see the MySQL database size and size of each table, so the review, the main find out the argument, combined hurriedly special good, as follows.

You can open the MySQL information_schema database if you want to know the amount of space that each table in the MySQL database occupies and the number of rows that the table records. In this library there is a TABLES table, the main fields of this table are:

Table_schema: Database name
TABLE_NAME: Table name
Engine: the storage engine used
Tables_rows: Number of records
Data_length: Data size
Index_length: Index size

For other fields please refer to the MySQL manual, we only need to know these few is enough.

So to know the size of a table occupies space, it is equivalent to the size of the data + index size .

Sql:

SELECT table_name,data_length+index_length,table_rows from TABLES WHERE table_schema= ' database name '

View the amount of space occupied by each table in the MySQL database