MySQL 查看表的大小方法
本文原发布于 2023-02-03，从旧博客迁移至此处。 整理：Hermes
MySQL 查看数据库和表的大小
1. 查看所有数据库容量大小
CodeBlock Loading...
2. 查看所有数据库各表容量大小
CodeBlock Loading...
3. 清理表碎片
OPTIMIZE TABLE your_database_name.your_table_name;万籁俱寂，万字将成。
本文原发布于 2023-02-03，从旧博客迁移至此处。 整理：Hermes
OPTIMIZE TABLE your_database_name.your_table_name;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)',
SUM(TRUNCATE((data_length + index_length)/1024/1024, 2)) AS '总容量(MB)'
FROM information_schema.tables
GROUP BY table_schema
ORDER BY SUM(data_length) DESC;SELECT
table_schema AS '数据库',
table_name AS '表名',
table_rows AS '记录数',
TRUNCATE(data_length/1024/1024, 2) AS '数据容量(MB)',
TRUNCATE((data_length + index_length)/1024/1024, 2) AS '总容量(MB)'
FROM information_schema.tables
WHERE table_schema = 'your_database_name'
ORDER BY SUM(data_length) DESC LIMIT 0, 50;