Mysql database or tablespace use query, mysql database tablespace

Mysql database or tablespace use query, mysql database tablespace

Directly add statements

Check the space occupied by 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;

Check the space occupied by the specified 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 = 'im _ db'

Group by TABLE_NAME

Order by data_length desc;