search

agatan / isucon7-qualify

ISUCON7予選: 都営三田線東急目黒線直通急行日吉行
4 stars 0 forks source link

メモ #5

Open 0gajun opened 6 years ago

0gajun commented 6 years ago

MySQLのテーブル情報

mysql> SELECT table_name, engine, table_rows, avg_row_length, floor((data_length+index_length)/1024/1024) as allMB, 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 | table_rows | avg_row_length | allMB | dMB  | iMB  |
+------------+--------+------------+----------------+-------+------+------+
| image      | InnoDB |        925 |         333861 |   294 |  294 |    0 |
| message    | InnoDB |       9791 |            483 |     4 |    4 |    0 |
| user       | InnoDB |       1011 |            210 |     0 |    0 |    0 |
| haveread   | InnoDB |         91 |            180 |     0 |    0 |    0 |
| channel    | InnoDB |        100 |            163 |     0 |    0 |    0 |
+------------+--------+------------+----------------+-------+------+------+
5 rows in set (0.00 sec)