MySql查看大小

// 查看数据库大小
select concat(round(sum(DATA_LENGTH/1024/1024),2), ‘MB’) as data from information_schema.TABLES where table_schema=‘ts’;

// 查看数据库中的表大小
select concat(round(sum(DATA_LENGTH/1024/1024),2), ‘MB’) as data from information_schema.TABLES where table_schema=‘ts’ and table_name=‘hyuser’;