【データベースサイズの確認】

root@information_schema>select table_schema, sum(data_length+index_length) /1024 /1024 as MB
-> from information_schema.tables group by table_schema order by sum(data_length+index_length) desc;

+——————–+————-+
| table_schema | MB |
+——————–+————-+
| DB01 | 13.41426182 |
| DB02 | 9.38685513 |
| DB03 | 8.78778076 |
| DB04 | 1.59736252 |
| DB05 | 0.69472599 |
| mysql | 0.58031273 |
| DB06 | 0.28602695 |
| DB07 | 0.25055885 |
| test | 0.03125000 |
| information_schema | 0.00781250 |
+——————–+————-+
10 rows in set (0.04 sec)

root@information_schema>

【以下実際のデータベースフォルダー】

[root@SRV01 data]# du -h
14M ./DB01
9.9M ./DB02
9.2M ./DB03
1.9M ./DB04
1020K ./DB05
1.3M ./mysql
604K ./DB06
1.2M ./DB07
40K ./test
[root@SRV01 data]#