1.查看所有数据库容量大小 select table_schema as "数据库", sum(table_rows) as "记录数", sum(truncate(data_length/1024/1024, 2)) as
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;
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
order by data_length desc, index_length desc;
例:查看Mysql库容量大小
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
where table_schema="mysql";
例:查看mysql库各表容量大小
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="mysql"
order by data_length desc, index_length desc;
--结束END--
本文标题: MySQL查看数据库表容量大小
本文链接: https://www.lsjlt.com/news/4990.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0