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

#                                                                                                                     #