mysql磁盘占用情况

最新推荐文章于 2024-07-29 20:17:55 发布

大种马

最新推荐文章于 2024-07-29 20:17:55 发布

阅读量756

点赞数 1

分类专栏： java 文章标签：数据库 mysql sql

本文链接：https://blog.csdn.net/GodPluto/article/details/121857590

版权

java 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

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
group by table_schema
order by sum(data_length) desc, sum(index_length) desc;

所有的数据库,以及该数据库下各个表的占用的空间是多少MB,以及各个表的

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
	TABLE_SCHEMA DESC,
	DATA_LENGTH DESC,
	INDEX_LENGTH DESC