mysql-运维随笔

1、查看数据库、数据表的大小

?

1 2 3 4 5 6 7

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

?

1	#                                                                                                                     #