MySQL View data size statement

Query the SQL statement that all databases consume disk space size:

Select Table_schema, concat (Truncate (SUM (data_length)/1024/1024,2), ' MB ') as Data_size,

Concat (Truncate (SUM (index_length)/1024/1024,2), ' MB ') as Index_size

From Information_schema.tables

GROUP BY Table_schema

ORDER BY data_length Desc;

SQL statements that query the size of all table disks in a single library:

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 = ' TestDB '

GROUP BY TABLE_NAME

ORDER BY data_length Desc;

This article is from the "OPS rookie" blog, please be sure to keep this source http://ckl893.blog.51cto.com/8827818/1682253

MySQL View data size statement