首页 > 数据库技术 > 详细

mysql查看每个数据库所占磁盘大小

时间:2019-01-29 14:35:34      阅读:187      评论:0      收藏:0      [点我收藏+]

#查看每个数据库所占磁盘大小

 

SELECT
  TABLE_SCHEMA AS "库名",
  TRUNCATE(SUM(`DATA_LENGTH`) / 1024 / 1024, 2) AS "表所占空间(MB)",
  TRUNCATE(SUM(`INDEX_LENGTH`) / 1024 / 1024, 2) AS "索引所占空间(MB)",
  TRUNCATE((SUM(`DATA_LENGTH`) + SUM(`INDEX_LENGTH`)) / 1024 / 1024,2) AS "空间累计(MB)"
FROM
  information_schema.`TABLES`
GROUP BY `TABLE_SCHEMA`;

 

 #查看某个数据库各表所占磁盘大小

 

SELECT
    TABLE_NAME,
    TRUNCATE (DATA_LENGTH / 1024 / 1024, 2) AS "DATA_SIZE(MB)",
    TRUNCATE (INDEX_LENGTH / 1024 / 1024, 2) AS "INDEX_SIZE(MB)"
FROM INFORMATION_SCHEMA. TABLES
WHERE TABLE_SCHEMA = db_name
GROUP BY TABLE_NAME
ORDER BY DATA_LENGTH DESC;

 

mysql查看每个数据库所占磁盘大小

原文:https://www.cnblogs.com/yanglei-xyz/p/10333739.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!