mysql如何查询数据库的大小

mysql查询数据库的大小的方法：

1、查询整个mysql数据库，整个库的大小；单位转换为MB。select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as datafrom information_schema.TABLES

2、查询mysql数据库，某个库的大小；select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as datafrom information_schema.TABLES where table_schema = 'testdb'

3、查看库中某个表的大小；select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as datafrom information_schema.TABLES where table_schema = 'testdb'and table_name = 'test_a';

4、查看mysql库中，test开头的表，所有存储大小；select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as datafrom information_schema.TABLES where table_schema = 'testdb'and table_name like 'test%';以上就是mysql如何查询数据库的大小的详细内容，更多请关注小潘博客其它相关文章！