如何查看数据库总量大小
mysql> select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data from information_schema.TABLES;
+----------+
| data |
+----------+
| 433.96MB |
+----------+
1 row in set (0.03 sec)
mysql> select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data from information_schema.TABLES;
+----------+
| data |
+----------+
| 433.96MB |
+----------+
1 row in set (0.03 sec)