天天消息!mysql怎么查询数据库容量

时间:2023-03-25 17:05:59       来源:PHP中文网


(资料图片仅供参考)

本教程操作环境: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中文网其它相关文章!

关键词: