mysql中查看数据库和表的磁盘大小_navicat查看数据库磁盘空间-优快云博客

本文链接：https://blog.youkuaiyun.com/David__peng/article/details/83001341

本文提供SQL语句，用于查询MySQL数据库中所有数据库、特定数据库及指定表的磁盘使用情况，包括数据大小、最大数据大小、空闲空间及索引大小。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

查看mysql数据库中各数据库的磁盘大小

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, TABLE_SCHEMA FROM information_schema.tables group by TABLE_SCHEMA;

查询指定数据库的磁盘大小

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 = '数据库名';

查询数据库表的磁盘大小

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 = '表名';