mysql查询数据库容量的方法：1、打开dos窗口，然后进入mysql的bin目录下；2、执行“select table_schema as 'shujuku',table_name as 'biaoming',table_rows as 'jilushu',truncate (data_length / 1024 / 1024, 2) ...”语句即可查看所有数据库各表容量。
本教程操作环境：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怎么查询数据库容量的详细内容。