Mysql查看库、表占用文件大小

最新推荐文章于 2024-07-22 03:04:41 发布

hzsnone

最新推荐文章于 2024-07-22 03:04:41 发布

阅读量2.2k

点赞数

分类专栏：技术文档数据库管理文章标签： mysql

本文链接：https://blog.csdn.net/qq625281334/article/details/84768399

版权

技术文档同时被 2 个专栏收录

17 篇文章 0 订阅

订阅专栏

数据库管理

4 篇文章 0 订阅

订阅专栏

1、查看数据库所占用空间

SELECT CONCAT(TRUNCATE(SUM(data_length)/1024/1024,2),'MB') AS data_size,
CONCAT(TRUNCATE(SUM(max_data_length)/1024/1024,2),'MB') AS max_data_size,
CONCAT(TRUNCATE(SUM(data_free)/1024/1024,2),'MB') AS data_free,
CONCAT(TRUNCATE(SUM(index_length)/1024/1024,2),'MB') AS index_size
FROM information_schema.tables WHERE TABLE_SCHEMA = '数据库名';

2、查看表所占空间

SELECT CONCAT(TRUNCATE(SUM(data_length)/1024/1024,2),'MB') AS data_size,
CONCAT(TRUNCATE(SUM(max_data_length)/1024/1024,2),'MB') AS max_data_size,
CONCAT(TRUNCATE(SUM(data_free)/1024/1024,2),'MB') AS data_free,
CONCAT(TRUNCATE(SUM(index_length)/1024/1024,2),'MB') AS index_size
FROM information_schema.tables WHERE TABLE_NAME = '表名';

3.查询数据库指定库的表大小，按大小排序

SELECT TABLE_NAME, CONCAT(TRUNCATE(data_length/1024/1024,2),' MB') AS data_size,
CONCAT(TRUNCATE(index_length/1024/1024,2),' MB') AS index_size
FROM information_schema.tables WHERE TABLE_SCHEMA = '数据库名'
GROUP BY TABLE_NAME
ORDER BY data_length DESC;