Comments (16)
@antonve @wakwak3125 主にアプリケーション側
@yamadayuki 主にインフラ側
from isucon-2017.
13:47: pull in DB
$ scp [email protected]:/home/isucon/isubata/db/isucon7q-initial-dataset.sql.gz isucon7q-initial-dataset.sql.gz
from isucon-2017.
13:51
$ local/go/bin/go version
go version go1.9.1 linux/amd64
from isucon-2017.
13:57: Initialized DB locally
from isucon-2017.
14:18 nginx の設定していく
from isucon-2017.
from isucon-2017.
import db
gzcat isucon7q-initial-dataset.sql.gz | mysql -u username -p database_name
from isucon-2017.
14:38
getIcons みたいなのがたくさん叩かれていて、icon はDBから引き出してきている。
get された時に directory に書き出して、nginx で返すようにする。
from isucon-2017.
go-wrk -d 5 -H="User-Agent: go-wrk 0.1 bechmark\nContent-Type: text/html;\nCookie:session=MTUwODU2Mzc2OXxEdi1CQkFFQ180SUFBUkFCRUFBQUl2LUNBQUVHYzNSeWFXNW5EQWtBQjNWelpYSmZhV1FGYVc1ME5qUUVCQUQtQjlJPXxMhiXvUdpnPKE54mW4uogvzcCA0zb12oKm7r7cD2zBig==;" http://localhost:5000
go-wrkでベンチマークできるコマンド、自分のクッキーを使ってください。
$ go-wrk -n=1000 -H="User-Agent: go-wrk 0.1 bechmark\nContent-Type: text/html;\nCookie:session=MTUwODU2Mzc2OXxEdi1CQkFFQ180SUFBUkFCRUFBQUl2LUNBQUVHYzNSeWFXNW5EQWtBQjNWelpYSmZhV1FGYVc1ME5qUUVCQUQtQjlJPXxMhiXvUdpnPKE54mW4uogvzcCA0zb12oKm7r7cD2zBig==;" http://localhost:5000
==========================BENCHMARK==========================
URL: http://localhost:5000
Used Connections: 100
Used Threads: 1
Total number of calls: 1000
===========================TIMINGS===========================
Total time passed: 2.85s
Avg time per request: 247.93ms
Requests per second: 351.49
Median time per request: 245.63ms
99th percentile time: 426.82ms
Slowest time for request: 427.00ms
=============================DATA=============================
Total response body sizes: 1792000
Avg response body per request: 1792.00ms
Transfer rate per second: 629872.99 Byte/s (0.63 MByte/s)
==========================RESPONSES==========================
20X Responses: 1000 (100.00%)
30X Responses: 0 (0.00%)
40X Responses: 0 (0.00%)
50X Responses: 0 (0.00%)
Errors: 0 (0.00%)
from isucon-2017.
15:08 nginx のログを解析するために
» ~/Desktop/alp -f ./log/access.log.201710211505
+-------+-------+--------+---------+-------+-------+--------+--------+--------+------------+------------+--------------+------------+--------+-----------------------------------------------------+
| COUNT | MIN | MAX | SUM | AVG | P1 | P50 | P99 | STDDEV | MIN(BODY) | MAX(BODY) | SUM(BODY) | AVG(BODY) | METHOD | URI |
+-------+-------+--------+---------+-------+-------+--------+--------+--------+------------+------------+--------------+------------+--------+-----------------------------------------------------+
| 80 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 20127.000 | 20127.000 | 1610160.000 | 20127.000 | GET | /fonts/glyphicons-halflings-regular.eot |
| 80 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 4162.000 | 4162.000 | 332960.000 | 4162.000 | GET | /js/chat.js |
| 80 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1741.000 | 1741.000 | 139280.000 | 1741.000 | GET | /css/main.css |
| 80 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 18028.000 | 18028.000 | 1442240.000 | 18028.000 | GET | /fonts/glyphicons-halflings-regular.woff2 |
| 80 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 24632.000 | 24632.000 | 1970560.000 | 24632.000 | GET | /js/tether.min.js |
| 80 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 23424.000 | 23424.000 | 1873920.000 | 23424.000 | GET | /fonts/glyphicons-halflings-regular.woff |
| 80 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 318.000 | 318.000 | 25440.000 | 318.000 | GET | /favicon.ico |
| 1 | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 | 0.001 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | GET | /profile/ogura_nagatoshi |
| 2 | 0.001 | 0.002 | 0.003 | 0.002 | 0.001 | 0.001 | 0.001 | 0.001 | 900.000 | 900.000 | 1800.000 | 900.000 | GET | /login |
| 1 | 0.003 | 0.003 | 0.003 | 0.003 | 0.003 | 0.003 | 0.003 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | GET | /profile/fukaya_youko |
| 2 | 0.002 | 0.003 | 0.005 | 0.003 | 0.002 | 0.002 | 0.002 | 0.001 | 883.000 | 883.000 | 1766.000 | 883.000 | GET | / |
| 1 | 0.007 | 0.007 | 0.007 | 0.007 | 0.007 | 0.007 | 0.007 | 0.000 | 23.000 | 23.000 | 23.000 | 23.000 | GET | /profile/FMoWdiTskZoQJMqrTICTojIYxyeSxZyf |
| 16 | 0.001 | 0.008 | 0.051 | 0.003 | 0.001 | 0.002 | 0.007 | 0.002 | 0.000 | 0.000 | 0.000 | 0.000 | GET | /logout |
| 3 | 0.004 | 0.008 | 0.012 | 0.004 | 0.000 | 0.000 | 0.004 | 0.003 | 0.000 | 3042.000 | 3042.000 | 1014.000 | GET | /add_channel |
| 2 | 0.001 | 0.009 | 0.010 | 0.005 | 0.001 | 0.001 | 0.001 | 0.004 | 900.000 | 900.000 | 1800.000 | 900.000 | GET | /register |
| 4 | 0.006 | 0.010 | 0.033 | 0.008 | 0.006 | 0.008 | 0.009 | 0.001 | 2954.000 | 3163.000 | 12228.000 | 3057.000 | GET | /profile/udagawa_hanako |
| 1 | 0.010 | 0.010 | 0.010 | 0.010 | 0.010 | 0.010 | 0.010 | 0.000 | 3073.000 | 3073.000 | 3073.000 | 3073.000 | GET | /channel/439 |
| 1 | 0.017 | 0.017 | 0.017 | 0.017 | 0.017 | 0.017 | 0.017 | 0.000 | 3069.000 | 3069.000 | 3069.000 | 3069.000 | GET | /channel/4 |
| 1 | 0.020 | 0.020 | 0.020 | 0.020 | 0.020 | 0.020 | 0.020 | 0.000 | 3077.000 | 3077.000 | 3077.000 | 3077.000 | GET | /channel/444 |
| 1 | 0.020 | 0.020 | 0.020 | 0.020 | 0.020 | 0.020 | 0.020 | 0.000 | 3074.000 | 3074.000 | 3074.000 | 3074.000 | GET | /channel/392 |
| 2 | 0.016 | 0.021 | 0.037 | 0.019 | 0.016 | 0.016 | 0.016 | 0.003 | 3074.000 | 3078.000 | 6152.000 | 3076.000 | GET | /channel/5 |
| 1 | 0.022 | 0.022 | 0.022 | 0.022 | 0.022 | 0.022 | 0.022 | 0.000 | 3075.000 | 3075.000 | 3075.000 | 3075.000 | GET | /channel/7 |
| 1 | 0.032 | 0.032 | 0.032 | 0.032 | 0.032 | 0.032 | 0.032 | 0.000 | 2923.000 | 2923.000 | 2923.000 | 2923.000 | GET | /history/461 |
| 1 | 0.035 | 0.035 | 0.035 | 0.035 | 0.035 | 0.035 | 0.035 | 0.000 | 8785.000 | 8785.000 | 8785.000 | 8785.000 | GET | /history/5 |
| 94 | 0.002 | 0.037 | 0.851 | 0.009 | 0.002 | 0.009 | 0.014 | 0.003 | 0.000 | 25.000 | 50.000 | 0.532 | POST | /add_channel |
| 1 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.000 | 3074.000 | 3074.000 | 3074.000 | 3074.000 | GET | /channel/384 |
| 1 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.000 | 3159.000 | 3159.000 | 3159.000 | 3159.000 | GET | /profile/iwasawa_hiro |
| 1 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.038 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | GET | /initialize |
| 1 | 0.040 | 0.040 | 0.040 | 0.040 | 0.040 | 0.040 | 0.040 | 0.000 | 3156.000 | 3156.000 | 3156.000 | 3156.000 | GET | /profile/suwa_natsumi |
| 1 | 0.040 | 0.040 | 0.040 | 0.040 | 0.040 | 0.040 | 0.040 | 0.000 | 3083.000 | 3083.000 | 3083.000 | 3083.000 | GET | /channel/434 |
| 1 | 0.044 | 0.044 | 0.044 | 0.044 | 0.044 | 0.044 | 0.044 | 0.000 | 3162.000 | 3162.000 | 3162.000 | 3162.000 | GET | /profile/sekine_mayuko |
| 8 | 0.001 | 0.047 | 0.241 | 0.030 | 0.001 | 0.036 | 0.045 | 0.017 | 0.000 | 8930.000 | 48364.000 | 6045.500 | GET | /history/1 |
| 1 | 0.050 | 0.050 | 0.050 | 0.050 | 0.050 | 0.050 | 0.050 | 0.000 | 3160.000 | 3160.000 | 3160.000 | 3160.000 | GET | /profile/sakashita_keiji |
| 1 | 0.051 | 0.051 | 0.051 | 0.051 | 0.051 | 0.051 | 0.051 | 0.000 | 3074.000 | 3074.000 | 3074.000 | 3074.000 | GET | /channel/394 |
| 1 | 0.060 | 0.060 | 0.060 | 0.060 | 0.060 | 0.060 | 0.060 | 0.000 | 3153.000 | 3153.000 | 3153.000 | 3153.000 | GET | /profile/serizawa_aoi |
| 1 | 0.077 | 0.077 | 0.077 | 0.077 | 0.077 | 0.077 | 0.077 | 0.000 | 3155.000 | 3155.000 | 3155.000 | 3155.000 | GET | /profile/shimamoto_haruka |
| 1 | 0.087 | 0.087 | 0.087 | 0.087 | 0.087 | 0.087 | 0.087 | 0.000 | 3152.000 | 3152.000 | 3152.000 | 3152.000 | GET | /profile/moriya_saki |
| 1 | 0.101 | 0.101 | 0.101 | 0.101 | 0.101 | 0.101 | 0.101 | 0.000 | 3149.000 | 3149.000 | 3149.000 | 3149.000 | GET | /profile/sudou_rokurou |
| 1 | 0.147 | 0.147 | 0.147 | 0.147 | 0.147 | 0.147 | 0.147 | 0.000 | 3159.000 | 3159.000 | 3159.000 | 3159.000 | GET | /profile/murano_yuuichi |
| 5 | 0.022 | 0.156 | 0.353 | 0.071 | 0.022 | 0.024 | 0.124 | 0.058 | 3067.000 | 3081.000 | 15365.000 | 3073.000 | GET | /channel/403 |
| 1 | 0.170 | 0.170 | 0.170 | 0.170 | 0.170 | 0.170 | 0.170 | 0.000 | 3158.000 | 3158.000 | 3158.000 | 3158.000 | GET | /profile/matsui_risa |
| 1 | 0.198 | 0.198 | 0.198 | 0.198 | 0.198 | 0.198 | 0.198 | 0.000 | 3075.000 | 3075.000 | 3075.000 | 3075.000 | GET | /channel/390 |
| 1 | 0.248 | 0.248 | 0.248 | 0.248 | 0.248 | 0.248 | 0.248 | 0.000 | 3163.000 | 3163.000 | 3163.000 | 3163.000 | GET | /profile/matsui_hitori |
| 2 | 0.250 | 0.257 | 0.507 | 0.254 | 0.250 | 0.250 | 0.250 | 0.004 | 56559.000 | 56559.000 | 113118.000 | 56559.000 | GET | /icons/b7a3dd99aa1fee2a5b7d6a70229c7ddfcf250d31.png |
| 20 | 0.037 | 0.271 | 2.705 | 0.135 | 0.037 | 0.130 | 0.240 | 0.064 | 3066.000 | 3084.000 | 61470.000 | 3073.500 | GET | /channel/2 |
| 1 | 0.272 | 0.272 | 0.272 | 0.272 | 0.272 | 0.272 | 0.272 | 0.000 | 3160.000 | 3160.000 | 3160.000 | 3160.000 | GET | /profile/tagawa_shingo |
| 2 | 0.227 | 0.278 | 0.505 | 0.253 | 0.227 | 0.227 | 0.227 | 0.026 | 2920.000 | 2920.000 | 5840.000 | 2920.000 | GET | /history/420 |
| 2 | 0.201 | 0.280 | 0.481 | 0.241 | 0.201 | 0.201 | 0.201 | 0.040 | 2932.000 | 2932.000 | 5864.000 | 2932.000 | GET | /history/412 |
| 2 | 0.197 | 0.296 | 0.493 | 0.246 | 0.197 | 0.197 | 0.197 | 0.049 | 2927.000 | 2927.000 | 5854.000 | 2927.000 | GET | /history/439 |
| 2 | 0.274 | 0.308 | 0.582 | 0.291 | 0.274 | 0.274 | 0.274 | 0.017 | 2926.000 | 2926.000 | 5852.000 | 2926.000 | GET | /history/397 |
| 1 | 0.311 | 0.311 | 0.311 | 0.311 | 0.311 | 0.311 | 0.311 | 0.000 | 3068.000 | 3068.000 | 3068.000 | 3068.000 | GET | /channel/419 |
| 2 | 0.267 | 0.318 | 0.585 | 0.292 | 0.267 | 0.267 | 0.267 | 0.025 | 2930.000 | 2930.000 | 5860.000 | 2930.000 | GET | /history/381 |
| 2 | 0.276 | 0.322 | 0.598 | 0.299 | 0.276 | 0.276 | 0.276 | 0.023 | 223703.000 | 223711.000 | 447414.000 | 223707.000 | GET | /icons/450886d6faaee54f7387d890bd1a8e01e80c147c.png |
| 4 | 0.271 | 0.329 | 1.164 | 0.291 | 0.271 | 0.281 | 0.283 | 0.022 | 2932.000 | 2933.000 | 11730.000 | 2932.500 | GET | /history/390 |
| 10 | 0.032 | 0.332 | 1.067 | 0.107 | 0.032 | 0.059 | 0.165 | 0.088 | 3061.000 | 3078.000 | 30707.000 | 3070.700 | GET | /channel/382 |
| 2 | 0.249 | 0.404 | 0.653 | 0.327 | 0.249 | 0.249 | 0.249 | 0.078 | 2928.000 | 2928.000 | 5856.000 | 2928.000 | GET | /history/414 |
| 1 | 0.405 | 0.405 | 0.405 | 0.405 | 0.405 | 0.405 | 0.405 | 0.000 | 3160.000 | 3160.000 | 3160.000 | 3160.000 | GET | /profile/kosuge_hiroaki |
| 4 | 0.154 | 0.443 | 1.169 | 0.292 | 0.154 | 0.215 | 0.357 | 0.114 | 2927.000 | 2929.000 | 11712.000 | 2928.000 | GET | /history/403 |
| 13 | 0.010 | 0.491 | 1.432 | 0.110 | 0.010 | 0.055 | 0.188 | 0.123 | 3062.000 | 3072.000 | 39870.000 | 3066.923 | GET | /channel/374 |
| 22 | 0.053 | 2.863 | 5.836 | 0.265 | 0.053 | 0.133 | 0.277 | 0.569 | 3070.000 | 3091.000 | 67789.000 | 3081.318 | GET | /channel/10 |
| 2 | 0.239 | 2.920 | 3.159 | 1.579 | 0.239 | 0.239 | 0.239 | 1.341 | 86603.000 | 86635.000 | 173238.000 | 86619.000 | GET | /icons/6ccf2a335413b8773f03ed4345e66d0019e44bd8.png |
| 231 | 0.002 | 3.000 | 20.119 | 0.087 | 0.002 | 0.010 | 2.519 | 0.402 | 0.000 | 23.000 | 92.000 | 0.398 | POST | /login |
| 17 | 0.007 | 3.000 | 3.693 | 0.217 | 0.007 | 0.026 | 0.195 | 0.697 | 0.000 | 0.000 | 0.000 | 0.000 | POST | /register |
| 16 | 0.002 | 3.001 | 7.807 | 0.488 | 0.002 | 0.081 | 3.000 | 0.958 | 0.000 | 25.000 | 50.000 | 3.125 | POST | /profile |
| 24 | 0.009 | 3.001 | 31.489 | 1.312 | 0.009 | 0.148 | 3.000 | 1.428 | 0.000 | 0.000 | 0.000 | 0.000 | POST | /message |
| 80 | 0.000 | 3.064 | 51.094 | 0.639 | 0.000 | 0.217 | 3.064 | 0.858 | 45404.000 | 45404.000 | 3632320.000 | 45404.000 | GET | /fonts/glyphicons-halflings-regular.ttf |
| 80 | 0.000 | 3.075 | 32.702 | 0.409 | 0.000 | 0.015 | 2.653 | 0.696 | 46653.000 | 46653.000 | 3732240.000 | 46653.000 | GET | /js/bootstrap.min.js |
| 80 | 0.001 | 3.285 | 100.859 | 1.261 | 0.001 | 0.897 | 3.283 | 1.030 | 108738.000 | 108738.000 | 8699040.000 | 108738.000 | GET | /fonts/glyphicons-halflings-regular.svg |
| 3 | 0.223 | 3.445 | 3.907 | 1.302 | 0.223 | 0.223 | 0.239 | 1.515 | 52334.000 | 52334.000 | 157002.000 | 52334.000 | GET | /icons/default.png |
| 80 | 0.003 | 3.703 | 73.179 | 0.915 | 0.000 | 0.453 | 3.271 | 0.993 | 86659.000 | 86659.000 | 6932720.000 | 86659.000 | GET | /js/jquery.min.js |
| 80 | 0.001 | 4.115 | 131.835 | 1.648 | 0.001 | 1.844 | 3.286 | 1.064 | 150996.000 | 150996.000 | 12079680.000 | 150996.000 | GET | /css/bootstrap.min.css |
| 9 | 2.291 | 4.947 | 32.612 | 3.624 | 2.291 | 2.721 | 4.946 | 1.028 | 430420.000 | 430739.000 | 3874664.000 | 430518.222 | GET | /icons/d9efb5732e0ee53618bd10d2ddc5a6b33edc4751.png |
| 6 | 2.006 | 5.126 | 25.501 | 4.250 | 2.006 | 4.739 | 5.006 | 1.111 | 0.000 | 665501.000 | 3325450.000 | 554241.667 | GET | /icons/8649e36ef8740cdb137911097e1438d825e9434b.png |
| 5 | 0.249 | 6.091 | 16.240 | 3.248 | 0.249 | 1.606 | 4.964 | 2.132 | 388697.000 | 389047.000 | 1944250.000 | 388850.000 | GET | /icons/5dc48c74e0f923aa2a4acbe786d3cbe2512c6767.png |
| 5 | 2.735 | 6.320 | 19.745 | 3.949 | 2.735 | 3.121 | 4.206 | 1.280 | 111819.000 | 111882.000 | 559275.000 | 111855.000 | GET | /icons/8aa90058ae2ca9c39b63de8bceef53e2d3a6d80c.png |
| 1 | 6.551 | 6.551 | 6.551 | 6.551 | 6.551 | 6.551 | 6.551 | 0.000 | 3163.000 | 3163.000 | 3163.000 | 3163.000 | GET | /profile/katsurayama_haruomi |
| 10 | 1.592 | 6.888 | 42.008 | 4.201 | 1.592 | 3.869 | 6.206 | 1.601 | 0.000 | 217520.000 | 1956810.000 | 195681.000 | GET | /icons/e01bb3e44b4b80c34168091f7aa3ce083b31add1.png |
| 10 | 0.118 | 7.800 | 38.450 | 3.845 | 0.118 | 3.527 | 6.752 | 2.512 | 0.000 | 236469.000 | 1890731.000 | 189073.100 | GET | /icons/6e7908eacdf1817989ed98b8ed979a4f49ad60c2.png |
| 11 | 0.239 | 8.493 | 35.716 | 3.247 | 0.239 | 1.858 | 8.328 | 2.686 | 0.000 | 202586.000 | 1822586.000 | 165689.636 | GET | /icons/9ffcd7cee7e5947b204db47c5738150e09e685e1.png |
| 12 | 0.268 | 9.053 | 65.503 | 5.459 | 0.268 | 5.512 | 8.721 | 2.460 | 0.000 | 207903.000 | 2286284.000 | 190523.667 | GET | /icons/8cbe874a2eac5b9e665add295160d36c56be5df5.png |
| 4 | 0.001 | 9.140 | 9.151 | 2.288 | 0.001 | 0.001 | 0.009 | 3.956 | 3065.000 | 3065.000 | 6129.000 | 1532.250 | GET | /channel/1 |
| 6 | 1.714 | 9.443 | 23.719 | 3.953 | 1.714 | 2.738 | 4.111 | 2.579 | 403692.000 | 404082.000 | 2423221.000 | 403870.167 | GET | /icons/9152bd50720b3e825a7e193ff062e6fe13e72ef9.png |
| 8 | 3.080 | 9.771 | 45.644 | 5.706 | 3.080 | 4.916 | 8.539 | 2.286 | 0.000 | 197728.000 | 1383882.000 | 172985.250 | GET | /icons/afed4119e9395c58e691e8f1c2687ce222e95183.png |
| 6 | 1.962 | 9.998 | 33.921 | 5.654 | 1.962 | 2.706 | 9.195 | 3.482 | 0.000 | 56559.000 | 226222.000 | 37703.667 | GET | /icons/f03c4f9c623562d824399f660f619f22dc88763e.png |
| 5 | 3.383 | 9.999 | 34.523 | 6.905 | 3.383 | 3.727 | 9.198 | 2.795 | 612216.000 | 612607.000 | 2449254.000 | 489850.800 | GET | /icons/60c8a6a07eafc18c9d37dc0e00f26e8fadd6c125.jpg |
| 10 | 0.263 | 10.000 | 32.972 | 3.297 | 0.263 | 2.639 | 5.289 | 2.637 | 0.000 | 428703.000 | 3427653.000 | 342765.300 | GET | /icons/b4f9effc4d9e86b58b271f5652b51dd997036d43.png |
| 5 | 0.473 | 10.000 | 12.401 | 2.480 | 0.473 | 0.555 | 0.723 | 3.761 | 0.000 | 9048.000 | 35080.000 | 7016.000 | GET | /history/10 |
| 13 | 0.267 | 10.000 | 67.414 | 5.186 | 0.267 | 3.601 | 9.418 | 2.919 | 0.000 | 367280.000 | 4037627.000 | 310586.692 | GET | /icons/e7ae0e65a2deb1f89a1f82dfc713c787cf2a5233.png |
| 4 | 0.210 | 10.000 | 27.029 | 6.757 | 0.210 | 6.819 | 10.000 | 3.997 | 0.000 | 197112.000 | 394082.000 | 98520.500 | GET | /icons/f906be69b742085556fd0d80ac1241e2693d9872.png |
| 9 | 0.286 | 10.000 | 41.567 | 4.619 | 0.286 | 3.821 | 10.000 | 3.226 | 0.000 | 299549.000 | 1796344.000 | 199593.778 | GET | /icons/65ea5a70b1fcf8f5f816b01b87f2aca2251315b0.png |
| 2 | 0.230 | 10.000 | 10.230 | 5.115 | 0.230 | 0.230 | 0.230 | 4.885 | 0.000 | 2923.000 | 2923.000 | 1461.500 | GET | /history/374 |
| 5 | 2.632 | 10.000 | 30.976 | 6.195 | 2.632 | 3.857 | 10.000 | 3.163 | 127967.000 | 127968.000 | 383902.000 | 76780.400 | GET | /icons/37cb504a993a882fb7bae384f0a518cae7ff97b5.png |
| 10 | 0.715 | 10.000 | 47.739 | 4.774 | 0.715 | 2.848 | 10.000 | 3.215 | 0.000 | 252394.000 | 1513922.000 | 151392.200 | GET | /icons/3f6591acbf1577185cd7c674f0ec36efcc9c4970.png |
| 11 | 2.031 | 10.000 | 61.072 | 5.552 | 2.031 | 3.778 | 10.000 | 3.033 | 0.000 | 198250.000 | 1189199.000 | 108109.000 | GET | /icons/1d7020c12548e0fa1401ade0dcd50591fbc709e3.png |
| 9 | 1.573 | 10.000 | 60.477 | 6.720 | 1.573 | 5.943 | 10.000 | 3.322 | 434150.000 | 434150.000 | 2169501.000 | 241055.667 | GET | /icons/c2d161d74b4e6b6541974a473bf0a9dfb01579dd.png |
| 10 | 0.131 | 10.000 | 49.607 | 4.961 | 0.131 | 4.175 | 9.483 | 2.966 | 0.000 | 330073.000 | 2309951.000 | 230995.100 | GET | /icons/4222f36590fbd90f9b7179efaa582ae51c777c52.jpg |
| 5 | 3.234 | 10.000 | 28.584 | 5.717 | 3.234 | 3.474 | 6.543 | 2.465 | 91667.000 | 91667.000 | 366594.000 | 73318.800 | GET | /icons/1d76784a308ce4cabc26ee143e6be5ac64eaa494.png |
| 6 | 2.999 | 10.000 | 39.357 | 6.559 | 2.999 | 4.900 | 10.000 | 2.672 | 100764.000 | 100764.000 | 402970.000 | 67161.667 | GET | /icons/bf37d9ee523c443a410f532a828ed9197da95329.png |
| 9 | 2.623 | 10.000 | 48.995 | 5.444 | 2.623 | 3.840 | 8.946 | 2.548 | 0.000 | 252934.000 | 2022761.000 | 224751.222 | GET | /icons/1ce0c4ff504f19f267e877a9e244d60ac0bf1a41.png |
| 11 | 1.741 | 10.000 | 68.701 | 6.246 | 1.741 | 4.789 | 10.000 | 3.102 | 0.000 | 423241.000 | 2961795.000 | 269254.091 | GET | /icons/2917ace8d8d4e5e1df4e4ce8f6bf03c1fb9ab162.png |
| 7 | 0.712 | 10.000 | 33.939 | 4.848 | 0.712 | 3.445 | 7.719 | 2.865 | 0.000 | 328173.000 | 984382.000 | 140626.000 | GET | /icons/b1c8c5bc9b026507ae62e6bf62cf55f70f4ac3d8.png |
| 11 | 0.264 | 10.000 | 42.936 | 3.903 | 0.264 | 2.712 | 7.080 | 2.716 | 0.000 | 103217.000 | 722440.000 | 65676.364 | GET | /icons/c434098fec37fd0d2c1e646d104220f6ffabbea7.png |
| 5 | 0.270 | 10.000 | 24.509 | 4.902 | 0.270 | 0.719 | 8.043 | 3.877 | 0.000 | 399696.000 | 1198738.000 | 239747.600 | GET | /icons/f8a9d2d65300689fdbf9688a05045f56c122bc16.png |
| 7 | 0.376 | 10.000 | 40.519 | 5.788 | 0.376 | 3.702 | 9.987 | 3.464 | 295084.000 | 295320.000 | 1771108.000 | 253015.429 | GET | /icons/bde120814720fb3bee14f415b4001305868df456.png |
| 9 | 2.136 | 10.000 | 48.552 | 5.395 | 2.136 | 4.223 | 6.914 | 2.199 | 493189.000 | 493189.000 | 3944379.000 | 438264.333 | GET | /icons/aa8c2a9a793eb1414c45fd2f46f08096d5f7cb69.png |
| 7 | 0.240 | 10.000 | 32.129 | 4.590 | 0.240 | 1.953 | 9.343 | 4.002 | 0.000 | 235894.000 | 1179232.000 | 168461.714 | GET | /icons/8628ef0f034d734729e3a735362e6008b30bb72b.png |
| 11 | 0.249 | 10.000 | 54.017 | 4.911 | 0.249 | 3.205 | 10.000 | 3.044 | 0.000 | 446408.000 | 3569659.000 | 324514.455 | GET | /icons/b0eecd54d66dd89864a6a0997d69e7bcd00036ee.png |
| 9 | 1.733 | 10.000 | 43.942 | 4.882 | 1.733 | 3.735 | 10.000 | 2.896 | 0.000 | 478635.000 | 2870080.000 | 318897.778 | GET | /icons/8e4c19ddf58b761c97bbfcf7e6279f0c793c4156.png |
| 5 | 0.307 | 10.000 | 24.591 | 4.918 | 0.307 | 3.284 | 7.353 | 3.385 | 0.000 | 687845.000 | 1375404.000 | 275080.800 | GET | /icons/c192f5cb12a1e37d0e5ada0c2fa5335d016b912c.png |
| 5 | 0.112 | 10.000 | 31.503 | 6.301 | 0.112 | 2.506 | 10.000 | 4.165 | 0.000 | 223649.000 | 223649.000 | 44729.800 | GET | /icons/c3e70129aeb6397568d97c8261b134547c31f4dc.png |
| 9 | 2.989 | 10.000 | 44.844 | 4.983 | 2.989 | 4.337 | 6.006 | 1.972 | 559177.000 | 559481.000 | 4474319.000 | 497146.556 | GET | /icons/0614f0cea1b70fb71b4c3b88545a42327157a41e.jpg |
| 9 | 1.592 | 10.000 | 43.240 | 4.804 | 1.592 | 3.150 | 9.269 | 2.858 | 0.000 | 427333.000 | 2562896.000 | 284766.222 | GET | /icons/2716e8a567c6eb3bab842e5b82940e795583ce59.png |
| 10 | 0.117 | 10.000 | 37.546 | 3.755 | 0.117 | 2.902 | 5.026 | 2.484 | 0.000 | 228099.000 | 1596130.000 | 159613.000 | GET | /icons/ae8893170459dc68063b942c49cc0b2be78f6b47.png |
| 10 | 2.827 | 10.000 | 65.640 | 6.564 | 2.827 | 5.737 | 10.000 | 2.673 | 0.000 | 142660.000 | 855708.000 | 85570.800 | GET | /icons/512b284bbcc00e73735b15619527e34087e4276d.png |
| 10 | 0.107 | 10.000 | 46.808 | 4.681 | 0.107 | 3.583 | 10.000 | 3.447 | 0.000 | 378534.000 | 2270524.000 | 227052.400 | GET | /icons/cc70e74a366a09da57f028a4317043d40e48afcc.png |
| 10 | 0.718 | 10.000 | 59.342 | 5.934 | 0.718 | 4.238 | 10.000 | 3.488 | 0.000 | 233945.000 | 701741.000 | 70174.100 | GET | /icons/3d46b7f1f3b3b4486d56a224db9fea9b12c718f5.png |
| 2 | 0.054 | 10.000 | 10.054 | 5.027 | 0.054 | 0.054 | 0.054 | 4.973 | 0.000 | 3111.000 | 3111.000 | 1555.500 | GET | /profile/hatanaka_ann |
| 8 | 2.446 | 10.000 | 43.144 | 5.393 | 2.446 | 4.145 | 8.090 | 2.543 | 0.000 | 294780.000 | 1178821.000 | 147352.625 | GET | /icons/ba2d2384f825a83862f3b61302468b2e07f0a0f7.png |
| 10 | 1.621 | 10.000 | 53.552 | 5.355 | 1.621 | 4.043 | 10.000 | 3.046 | 0.000 | 490146.000 | 3429170.000 | 342917.000 | GET | /icons/541bd3a853096f172a2d87898ed47a97ba1da1ee.png |
| 7 | 2.320 | 10.000 | 38.602 | 5.515 | 2.320 | 3.104 | 7.008 | 2.633 | 0.000 | 543570.000 | 2717221.000 | 388174.429 | GET | /icons/ba05f8d186ab9c5270276176187eb0361b06baef.png |
| 9 | 0.722 | 10.000 | 65.149 | 7.239 | 0.722 | 7.136 | 10.000 | 2.916 | 0.000 | 381196.000 | 1905182.000 | 211686.889 | GET | /icons/61463cd868570a29cc1b74232000e84d3276e315.png |
| 10 | 3.825 | 10.000 | 64.679 | 6.468 | 3.825 | 5.619 | 10.000 | 2.466 | 371356.000 | 371617.000 | 2600324.000 | 260032.400 | GET | /icons/d6ad2e7df048b8691a8223482adf654ae03376af.png |
| 4 | 3.883 | 10.000 | 29.299 | 7.325 | 3.883 | 6.547 | 8.869 | 2.345 | 0.000 | 288400.000 | 576800.000 | 144200.000 | GET | /icons/b1af7d150304a3dde8c139a544db8cdb4571d690.png |
| 6 | 2.228 | 10.001 | 32.405 | 5.401 | 2.228 | 2.861 | 7.354 | 2.941 | 0.000 | 437349.000 | 1311563.000 | 218593.833 | GET | /icons/7598595abd317f5ae637300a27f95e3c700376a7.png |
| 11 | 1.116 | 10.001 | 77.333 | 7.030 | 1.116 | 7.840 | 10.000 | 3.338 | 0.000 | 105297.000 | 526436.000 | 47857.818 | GET | /icons/e58ed7194ed4a99d9d6ada9e3383983edcbd1edc.png |
| 9 | 3.363 | 10.001 | 64.986 | 7.221 | 3.363 | 4.808 | 10.001 | 2.846 | 0.000 | 329210.000 | 987305.000 | 109700.556 | GET | /icons/ec48374ca1b2693ca643041659fb8372c72d1ddd.png |
| 9 | 0.113 | 10.001 | 60.638 | 6.738 | 0.113 | 6.188 | 10.000 | 3.379 | 0.000 | 203934.000 | 1223147.000 | 135905.222 | GET | /icons/f66cf18995c7be8ca7f490210a15b80c35197347.png |
| 9 | 3.332 | 10.001 | 65.220 | 7.247 | 3.332 | 5.337 | 10.000 | 2.522 | 0.000 | 312837.000 | 1563679.000 | 173742.111 | GET | /icons/d596eb3cfed2cf248053397eb623fc560917d0c9.png |
| 9 | 2.590 | 10.001 | 55.648 | 6.183 | 2.590 | 4.875 | 10.001 | 2.888 | 344588.000 | 344692.000 | 2067528.000 | 229725.333 | GET | /icons/164a720f716d0b01e6c66cb53a8d1367aaf4fc42.png |
| 9 | 3.116 | 10.001 | 58.236 | 6.471 | 3.116 | 4.164 | 10.000 | 2.819 | 0.000 | 149115.000 | 447165.000 | 49685.000 | GET | /icons/846f4f0bde2a2103c71936091e82bc1354f11b3a.png |
| 8 | 1.122 | 10.001 | 37.946 | 4.743 | 1.122 | 2.587 | 10.000 | 3.353 | 0.000 | 149722.000 | 748453.000 | 93556.625 | GET | /icons/6b88bb2c190da9e6cd9e704c45bf1d52ad107348.png |
| 11 | 2.093 | 10.001 | 68.880 | 6.262 | 2.093 | 4.222 | 10.000 | 3.048 | 672951.000 | 673253.000 | 4711658.000 | 428332.545 | GET | /icons/f0a6a8334e2b9b3f49c39ce35a19a2d20e648aab.png |
| 5 | 2.660 | 10.001 | 37.219 | 7.444 | 2.660 | 4.558 | 10.000 | 3.188 | 339340.000 | 339364.000 | 678704.000 | 135740.800 | GET | /icons/851e9e15e1d1fff39c2d182881926d107154c44a.png |
| 10 | 0.303 | 10.001 | 52.361 | 5.236 | 0.303 | 4.966 | 10.000 | 3.282 | 681809.000 | 682103.000 | 5455749.000 | 545574.900 | GET | /icons/78a9228a393eb2621f346fc6a5e099d5bc373f76.png |
| 10 | 0.288 | 10.001 | 53.842 | 5.384 | 0.288 | 4.933 | 10.000 | 3.423 | 0.000 | 769170.000 | 6150088.000 | 615008.800 | GET | /icons/5e981ef46ec0f47bdc2f188673325b85078f5235.png |
| 8 | 1.916 | 10.001 | 49.571 | 6.196 | 1.916 | 2.893 | 10.001 | 3.813 | 0.000 | 115194.000 | 460696.000 | 57587.000 | GET | /icons/158fa9df919970ac8bc3bc2724ed5b02fe30968d.png |
| 39 | 0.001 | 10.003 | 307.450 | 7.883 | 0.001 | 10.000 | 10.001 | 3.872 | 0.000 | 3020.000 | 21126.000 | 541.692 | GET | /fetch |
| 87 | 0.001 | 10.005 | 387.977 | 4.460 | 0.001 | 1.687 | 10.001 | 4.665 | 0.000 | 52700.000 | 734101.000 | 8437.943 | GET | /message |
+-------+-------+--------+---------+-------+-------+--------+--------+--------+------------+------------+--------------+------------+--------+-----------------------------------------------------+
from isucon-2017.
15:27 静的ファイル配信 #8
14194
from isucon-2017.
15:29
create index haveread_channel_id ON haveread (channel_id);
create index message_channel_id ON message (channel_id)
from isucon-2017.
15:29 dbのidle/maxを8に固定
from isucon-2017.
create index image_name ON image (name);
from isucon-2017.
13:54: #10
Warmup image cache
from isucon-2017.
16:24 #12
Select needed column from user table
from isucon-2017.
Related Issues (3)
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from isucon-2017.