mysql SELECT table_schema lanselot_extreme sum data_length index_lengt

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
mysql> SELECT table_schema "lanselot_extreme", sum( data_length + index_length )/1024/1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema;
+--------------------+----------------------+
| lanselot_extreme | Data Base Size in MB |
+--------------------+----------------------+
| information_schema | 0.00781250 |
| lanselot_dedlain | 0.37892914 |
| lanselot_extreme | 526.14062500 |
| lanselot_notes | 0.62477875 |
| lanselot_nwsw | 0.43750000 |
| lanselot_only2 | 0.82812500 |
+--------------------+----------------------+
6 rows in set (0.16 sec)