各テーブルのデータサイズ

mysql> SELECT table_name,
    ->        round(((data_length + index_length) / 1024 / 1024), 2) as 'Size in MB'
    -> FROM information_schema.tables
    -> WHERE table_schema = 'isupipe';
ERROR 2013 (HY000): Lost connection to MySQL server during query
No connection. Trying to reconnect...
Connection id:    8
Current database: isupipe

+----------------------------+------------+
| TABLE_NAME                 | Size in MB |
+----------------------------+------------+
| icons                      |       0.02 |
| livecomment_reports        |       0.02 |
| livecomments               |       0.16 |
| livestream_tags            |       0.52 |
| livestream_viewers_history |       0.02 |
| livestreams                |       2.52 |
| ng_words                   |       3.03 |
| reactions                  |       0.09 |
| reservation_slots          |       0.48 |
| tags                       |       0.03 |
| themes                     |       0.06 |
| users                      |       0.44 |
+----------------------------+------------+
12 rows in set (0.05 sec)
taiwork / isucon13

各テーブルのデータサイズ #22
