mysql-运维随笔
1、查看数据库、数据表的大小
use information_schema; //查看指定数据库的大小 select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data from TABLES where TABLE_SCHEMA='vr'; //查看指定数据库的各个表的大小 select TABLE_NAME,concat(DATA_LENGTH/1024/1024,'MB') as data from TABLES where TABLE_SCHEMA='vr';
1
# #