查看数据库的库和表各占用大小

use information_schema;


show binary logs;

select concat(round(sum((DATA_LENGTH+INDEX_LENGTH)/1024/1024),2),'MB') as data from TABLES where 1=1 
#and table_schema='数据库名称' 
#and table_name='表名'
;

SELECT 
table_schema,
sum(DATA_LENGTH+INDEX_LENGTH) size,
sum(TABLE_ROWS) rowcount,
concat(sum(round((DATA_LENGTH+INDEX_LENGTH)/1024/1024,2)), 'MB') as data FROM TABLES WHERE 1=1
#and TABLE_SCHEMA='数据库名称'
group by table_schema
order by size desc
;

SELECT 
table_schema,
TABLE_NAME,
DATA_LENGTH+INDEX_LENGTH,
TABLE_ROWS,
concat(round((DATA_LENGTH+INDEX_LENGTH)/1024/1024,2), 'MB') as data FROM TABLES WHERE 1=1
and TABLE_SCHEMA='数据库名称'
order by DATA_LENGTH+INDEX_LENGTH desc
;