1、查看指定数据库中各表占用空间的大小
select table_schema as '数据库', table_name as '表名', table_rows as '记录数', truncate(data_length/1024/1024, 2) as '数据容量(MB)', truncate(index_length/1024/1024, 2) as '索引容量(MB)' from information_schema.tables where table_schema='数据库名称' order by data_length desc, index_length desc
2、查看各数据库占用空间的大小
select
table_schema
as
'数据库'
,
sum(table_rows)
as
'记录数'
,
sum(truncate(data_length/1024/1024, 2))
as
'数据容量(MB)'
,
sum(truncate(index_length/1024/1024, 2))
as
'索引容量(MB)'
from information_schema.tables
group by table_schema
order by sum(data_length) desc, sum(index_length) desc;
2022年7月22日11:27:55