(资料图)

本教程操作环境：Windows10系统、MySQL5.7版、Dell G3电脑。

mysql怎么查询数据库容量？

MySql查看数据库及表容量大小并排序

MySql查看数据库及表容量并排序查看所有数据库容量

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)"FROM    information_schema. TABLESGROUP BY    table_schemaORDER BY    sum(data_length) DESC,    sum(index_length) DESC;

查看所有数据库各表容量

SELECT    table_schema AS "数据库",    table_name AS "表名",    table_rows AS "记录数",    TRUNCATE (data_length / 1024 / 1024, 2) AS "数据容量(MB)",    TRUNCATE (index_length / 1024 / 1024, 2) AS "索引容量(MB)"FROM    information_schema. TABLESORDER BY    data_length DESC,    index_length DESC;

查看指定数据库容量

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)"FROM    information_schema.tables where table_schema = "your_table_name";

查看指定数据库各表容量

SELECT    table_schema AS "数据库",    table_name AS "表名",    table_rows AS "记录数",    TRUNCATE ( data_length / 1024 / 1024, 2 ) AS "数据容量(MB)",    TRUNCATE ( index_length / 1024 / 1024, 2 ) AS "索引容量(MB)" FROM    information_schema.TABLES WHERE    table_schema = "指定的库名" ORDER BY    data_length DESC,    index_length DESC;

推荐学习：《MySQL视频教程》

以上就是mysql怎么查询数据库容量的详细内容，更多请关注php中文网其它相关文章！

推荐内容