首先进入数据库
mysql -uroot -p123456
查看每个数据库所占磁盘大小
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;
转载：https://www.cnblogs.com/yanglei-xyz/p/10333739.html
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 举报，一经查实，本站将立刻删除。
文章由极客之音整理，本文链接：https://www.bmabk.com/index.php/post/75793.html
