查看数据库的每个表占用 磁盘大小
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
;
TestDB 为库名
原文连接:https://www.cnblogs.com/Fooo/p/9183661.html