mysql怎么查看数据库中表的大小
1、查询整个baimysql数据库，整个库的du大小；单位转换为MB。select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as datafrom information_schema.TABLES
2、查询mysql数据库bai，某个库的大du小；
select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data
from information_schema.TABLES
where table_schema = 'testdb'
3、查看库中某个表的大小；
select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data
from 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 data
from information_schema.TABLES
where table_schema = 'testdb'
and table_name like 'test%';
页:
[1]