MySQL queries the size of disk space occupied by all databases and the size of all tables in a single database.

MySQL queries the size of disk space occupied 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_sizefrom information_schema.tablesgroup by TABLE_SCHEMAorder 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_sizefrom information_schema.tables where TABLE_SCHEMA = 'testdb' group by TABLE_NAMEorder by data_length desc;

Replace the above TestDB with the specific database name.