MySQL查询数据库表空间容量
mysql -h<ip> -P<port> -u<root> -p<password> <库> -e "select concat(round(sum(DATA_LEN_LENGTH/1024/1024),2)M,'MB') as data from information_schema.TABLES where table_schema='<库>' and table_name='表'"
MySQL查询数据库表空间容量
mysql -h<ip> -P<port> -u<root> -p<password> <库> -e "select concat(round(sum(DATA_LEN_LENGTH/1024/1024),2)M,'MB') as data from information_schema.TABLES where table_schema='<库>' and table_name='表'"