数据库磁盘

最新推荐文章于 2024-07-03 12:23:53 发布

剪云者丶丶

最新推荐文章于 2024-07-03 12:23:53 发布

阅读量220

点赞数

文章标签：数据库

本文链接：https://blog.csdn.net/qq_29391861/article/details/126890548

版权

#查看实例中数据库占用
select TABLE_SCHEMA, concat(truncate(sum(data_length)/1024/1024,2),’ MB’) as data_size,
concat(truncate(sum(index_length)/1024/1024,2),‘MB’) as index_size
from information_schema.tables
group by TABLE_SCHEMA
order by data_size desc;

#表占用磁盘
SELECT table_name, data_length + index_length AS len, table_rows,
CONCAT(ROUND((data_length + index_length)/1024/1024,2),‘MB’) AS datas FROM information_schema.tables
WHERE table_schema = ‘tables’ ORDER BY len DESC;

#碎片查询
select TABLE_SCHEMA,TABLE_NAME,ENGINE,concat(splinter,‘G’) ‘碎片(G)’ from (
SELECT TABLE_SCHEMA,TABLE_NAME,ENGINE,ROUND((DATA_LENGTH+INDEX_LENGTH-TABLE_ROWS*AVG_ROW_LENGTH)/1024/1024/1024) splinter from information_schema.TABLES where TABLE_TYPE=‘BASE TABLE’
)a ORDER BY splinter DESC