Query the disk space used by all databases and the size of all tables in a single database _ MySQL-MySQL tutorial

SQL statement bitsCN.com used by MySQL to query the disk space used by all databases and the size of all tables in a single database

SQL statement used to query the disk space of all databases:

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 statement used to query the disk size of all tables in a single database:

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;

The preceding statement is valid. replace TestDB with the database name.

BitsCN.com