View the size of individual tables in a single MySQL database

The SQL command is:

SELECT Table_name,data_length+index_length,table_rows,concat (Round (data_length+index_length)/1024/1024,2), ' MB ' As data from TABLES WHERE table_schema= ' dbmysql ';

Or

Select table_name, concat (Truncate (data_length/1024/1024,2), ' MB ') as Data_size,concat (truncate (index_length/1024/ 1024,2), ' MB ') as index_size from information_schema.tables where table_schema = ' dbmysql ' GROUP BY table_name ORDER by DA Ta_length desc;

Description

Table_schema: Database name

TABLE_NAME: Table name

Engine: the storage engine used

Data_length: Data size

Index_length: Index size

Tables_rows: Number of records

View the size of individual tables in a single MySQL database