# h1

mysql> show tables;
+---------------------+
| Tables_in_xsuportal |
+---------------------+
| benchmark_jobs      |
| clarifications      |
| contest_config      |
| contestants         |
| notifications       |
| push_subscriptions  |
| teams               |
+---------------------+
7 rows in set (0.01 sec)

bench前のdb

mysql> SELECT
    ->     table_schema, sum(data_length) /1024/1024 AS mb
    -> FROM
    ->     information_schema.tables
    -> GROUP BY
    ->     table_schema
    -> ORDER BY
    ->     sum(data_length+index_length) DESC;
+--------------------+------------+
| TABLE_SCHEMA       | mb         |
+--------------------+------------+
| mysql              | 2.23437500 |
| xsuportal          | 0.18750000 |
| sys                | 0.01562500 |
| information_schema | 0.00000000 |
| performance_schema | 0.00000000 |
+--------------------+------------+
5 rows in set (0.01 sec)

mysql> SELECT
    ->     table_name, engine, table_rows AS tbl_rows,
    ->     avg_row_length AS rlen,
    ->     floor((data_length)/1024/1024) AS dmb,
    ->     floor((index_length)/1024/1024) AS imb
    -> FROM
    ->     information_schema.tables
    -> WHERE
    ->     table_schema=database()
    -> ORDER BY
    ->     (data_length+index_length) DESC;
+--------------------+--------+----------+-------+------+------+
| TABLE_NAME         | ENGINE | tbl_rows | rlen  | dmb  | imb  |
+--------------------+--------+----------+-------+------+------+
| benchmark_jobs     | InnoDB |      100 |   655 |    0 |    0 |
| notifications      | InnoDB |      312 |   157 |    0 |    0 |
| push_subscriptions | InnoDB |        0 |     0 |    0 |    0 |
| teams              | InnoDB |       10 |  1638 |    0 |    0 |
| clarifications     | InnoDB |        8 |  2048 |    0 |    0 |
| contest_config     | InnoDB |        1 | 16384 |    0 |    0 |
| contestants        | InnoDB |       51 |   321 |    0 |    0 |
+--------------------+--------+----------+-------+------+------+
7 rows in set (0.00 sec)