(资料图)
本教程操作环境：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中文网其它相关文章！
关键词：
营业执照公示信息