TODOリスト #1

ken39arg · 2020-09-09T01:04:57Z

やらないこと

ミドルウェアの追加や変更
- ソロプレイなのでその時間はないので知らないのが来たら諦める。
- あり物で限界まで頑張る縛りで楽しむ
fasthttp

事前に~/.ssh/known_hostsからisuNを消しておく

当日まずやることリスト

1.5h

戦略を決める

0.5h

スローログの解決はどのくらいかけるか？
静的ファイル系の問題はあるか？
ミドルウェアのチューニング余地はどのくらいあるか？
いつpprofするか
アプリケーションの改善で自明かつすぐできるところはあるか？

改善に着手

5.0h

アプリ改善
ミドルウェアパラメータ調整
複数Server化などの構成変更

最終チェック

1.0h

ただし、この時点でスコアが出ていなかったら引き続き改善を頑張る

各種ログをoffにする
再起動試験
ベンチガチャ

The text was updated successfully, but these errors were encountered:

ken39arg · 2020-09-10T07:23:32Z

https://gist.github.com/koudaiii/dae08d3cb9c861a1d4b3

ken39arg · 2020-09-12T03:25:38Z

ベンチマークからのリクエストは、 API に対してのみ行われます。画像や HTML などの静的ファイルに対するリクエストは行われませんが、追試にてブラウザ上でアプリケーションが動作するかを確認します。詳細は制約事項を参照してください。

ken39arg · 2020-09-12T03:27:06Z

スコア = (イスの購入件数 + 物件の資料請求件数) - 減点

bot からのアクセスはコンバージョンに繋がらないため、弾くことが仕様として決定しましたが、まだ実装されていません。 bot は User-Agent が以下の正規表現にマッチする形式であり、このリクエストに対して 503 Service Unavailable を返すことが許可されています。これに対するベンチマーカーからの減点は発生しません。

/ISUCONbot(-Mobile)?/
/ISUCONbot-Image//
/Mediapartners-ISUCON/
/ISUCONCoffee/
/ISUCONFeedSeeker(Beta)?/
/crawler (https://isucon.invalid/(support/faq/|help/jp/)/
/isubot/
/Isupider/
/Isupider(-image)?+/
/(bot|crawler|spider)(?:[-_ ./;@()]|$)/i

ken39arg · 2020-09-12T03:58:07Z

ssh -L localhost:8080:isu1:80 isu1

ken39arg · 2020-09-12T04:11:16Z

isucon@team306-001:~$ cat /etc/systemd/system/isuumo.go.service
[Unit]
Description=isuumo.go

[Service]
WorkingDirectory=/home/isucon/isuumo/webapp/go
EnvironmentFile=/home/isucon/env.sh
PIDFile=/home/isucon/isuumo/webapp/go/server.pid

User=isucon
Group=isucon
ExecStart=/home/isucon/isuumo/webapp/go/isuumo
ExecStop=/bin/kill -s QUIT $MAINPID

Restart   = always
Type      = simple

[Install]
WantedBy=multi-user.target

ken39arg · 2020-09-12T04:14:34Z

isucon@team306-001:~$ cat /etc/systemd/system/multi-user.target.wants/nginx.service
# Stop dance for nginx
# =======================
#
# ExecStop sends SIGSTOP (graceful stop) to the nginx process.
# If, after 5s (--retry QUIT/5) nginx is still running, systemd takes control
# and sends SIGTERM (fast shutdown) to the main process.
# After another 5s (TimeoutStopSec=5), and if nginx is alive, systemd sends
# SIGKILL to all the remaining processes in the process group (KillMode=mixed).
#
# nginx signals reference doc:
# http://nginx.org/en/docs/control.html
#
[Unit]
Description=A high performance web server and a reverse proxy server
Documentation=man:nginx(8)
After=network.target

[Service]
Type=forking
PIDFile=/run/nginx.pid
ExecStartPre=/usr/sbin/nginx -t -q -g 'daemon on; master_process on;'
ExecStart=/usr/sbin/nginx -g 'daemon on; master_process on;'
ExecReload=/usr/sbin/nginx -g 'daemon on; master_process on;' -s reload
ExecStop=-/sbin/start-stop-daemon --quiet --stop --retry QUIT/5 --pidfile /run/nginx.pid
TimeoutStopSec=5
KillMode=mixed

[Install]
WantedBy=multi-user.target

ken39arg · 2020-09-12T04:22:16Z

isucon@team306-001:~$ free
              total        used        free      shared  buff/cache   available
Mem:        2040900      339540     1010712         652      690648     1548396
Swap:             0           0           0
isucon@team306-001:~$ free -m
              total        used        free      shared  buff/cache   available
Mem:           1993         331         987           0         674        1512
Swap:             0           0           0
isucon@team306-001:~$ cat /proc/cpuinfo | less
isucon@team306-001:~$ cat /proc/cpuinfo
processor       : 0
vendor_id       : AuthenticAMD
cpu family      : 23
model           : 1
model name      : AMD EPYC Processor (with IBPB)
stepping        : 2
microcode       : 0x1000065
cpu MHz         : 2295.686
cache size      : 512 KB
physical id     : 0
siblings        : 1
core id         : 0
cpu cores       : 1
apicid          : 0
initial apicid  : 0
fpu             : yes
fpu_exception   : yes
cpuid level     : 13
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm rep_good nopl cpuid extd_apicid tsc_known_freq pni pclmulqdq ssse3 fma cx16 sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm cmp_legacy svm cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw ssbd ibrs ibpb vmmcall fsgsbase tsc_adjust bmi1 avx2 smep bmi2 rdseed adx smap clflushopt clwb sha_ni xsaveopt xsavec xgetbv1 arat
bugs            : fxsave_leak sysret_ss_attrs spectre_v1 spectre_v2 spec_store_bypass
bogomips        : 4591.37
TLB size        : 1024 4K pages
clflush size    : 64
cache_alignment : 64
address sizes   : 40 bits physical, 48 bits virtual
power management:

ken39arg · 2020-09-12T04:46:06Z

isucon@team306-001:~$ sudo cat ~/log/20200912044018/access.log | alp ltsv -c alp.yml
+-------+-----+-----+-----+--------+----------------------------------+-------+-------+-------+-------+
| COUNT | 2XX | 4XX | 5XX | METHOD |               URI                |  MIN  |  P50  |  P99  |  MAX  |
+-------+-----+-----+-----+--------+----------------------------------+-------+-------+-------+-------+
|   988 | 986 |   2 |   0 | GET    | /api/estate/search               | 0.056 | 0.188 | 0.200 | 0.784 |
|   779 | 777 |   2 |   0 | GET    | /api/chair/search                | 0.060 | 0.128 | 0.200 | 0.720 |
|   641 | 640 |   1 |   0 | GET    | ^/api/estate/[0-9]+$             | 0.004 | 0.008 | 0.000 | 0.044 |
|   388 | 387 |   1 |   0 | GET    | /api/chair/low_priced            | 0.025 | 0.096 | 0.084 | 0.556 |
|   388 | 387 |   1 |   0 | GET    | /api/estate/low_priced           | 0.014 | 0.084 | 0.128 | 0.220 |
|   345 | 345 |   0 |   0 | POST   | ^/api/estate/req_doc/[0-9]+$     | 0.000 | 0.000 | 0.000 | 0.036 |
|   264 | 262 |   2 |   0 | GET    | ^/api/chair/[0-9]+$              | 0.004 | 0.004 | 0.024 | 0.236 |
|   260 | 259 |   1 |   0 | GET    | ^/api/recommended_estate/[0-9]+$ | 0.064 | 0.128 | 0.124 | 0.796 |
|   165 | 165 |   0 |   0 | GET    | /api/estate/search/condition     | 0.000 | 0.004 | 0.000 | 0.008 |
|   131 | 131 |   0 |   0 | GET    | /api/chair/search/condition      | 0.000 | 0.000 | 0.000 | 0.008 |
|   128 | 128 |   0 |   0 | POST   | ^/api/chair/buy/[0-9]+$          | 0.004 | 0.004 | 0.012 | 0.444 |
|    96 |  93 |   3 |   0 | POST   | /api/estate/nazotte              | 0.060 | 0.580 | 0.238 | 2.000 |
|     1 |   1 |   0 |   0 | POST   | /api/chair                       | 0.216 | 0.216 | 0.216 | 0.216 |
|     1 |   1 |   0 |   0 | POST   | /api/estate                      | 0.200 | 0.200 | 0.200 | 0.200 |
|     1 |   1 |   0 |   0 | POST   | /initialize                      | 4.140 | 4.140 | 4.140 | 4.140 |
+-------+-----+-----+-----+--------+----------------------------------+-------+-------+-------+-------+

ken39arg · 2020-09-12T06:45:44Z

isucon@team306-001:~$ sudo cat ~/log/20200912064255/access.log | alp ltsv -c alp.yml
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+
| COUNT | 2XX  | 4XX | 5XX | METHOD |               URI                |  MIN  |  P50  |  P99  |  MAX  |
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+
|  1399 | 1300 |   2 |  97 | GET    | /api/estate/search               | 0.134 | 0.100 | 0.076 | 0.696 |
|   958 |  859 |   2 |  97 | GET    | /api/chair/search                | 0.016 | 0.116 | 0.000 | 0.744 |
|   942 |  922 |   2 |  18 | GET    | ^/api/estate/[0-9]+$             | 0.008 | 0.004 | 0.004 | 0.488 |
|   640 |  637 |   0 |   3 | GET    | /api/estate/low_priced           | 0.004 | 0.000 | 0.000 | 0.056 |
|   640 |  636 |   1 |   3 | GET    | /api/chair/low_priced            | 0.012 | 0.076 | 0.072 | 0.260 |
|   560 |  560 |   0 |   0 | POST   | ^/api/estate/req_doc/[0-9]+$     | 0.000 | 0.000 | 0.000 | 0.036 |
|   314 |  290 |   3 |  21 | GET    | ^/api/chair/[0-9]+$              | 0.000 | 0.000 | 0.004 | 0.492 |
|   302 |  287 |   0 |  15 | GET    | ^/api/recommended_estate/[0-9]+$ | 0.004 | 0.096 | 0.160 | 0.708 |
|   295 |  278 |   2 |  15 | POST   | /api/estate/nazotte              | 0.004 | 0.264 | 0.132 | 0.728 |
|   221 |  221 |   0 |   0 | GET    | /api/estate/search/condition     | 0.000 | 0.000 | 0.004 | 0.008 |
|   147 |  147 |   0 |   0 | GET    | /api/chair/search/condition      | 0.004 | 0.000 | 0.000 | 0.004 |
|   141 |  141 |   0 |   0 | POST   | ^/api/chair/buy/[0-9]+$          | 0.004 | 0.008 | 0.004 | 0.248 |
|     5 |    2 |   0 |   3 | POST   | /api/estate                      | 0.004 | 0.004 | 0.292 | 1.020 |
|     4 |    4 |   0 |   0 | POST   | /initialize                      | 4.884 | 5.004 | 4.884 | 5.145 |
|     2 |    2 |   0 |   0 | POST   | /api/chair                       | 0.292 | 0.292 | 0.292 | 0.912 |
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+

ken39arg · 2020-09-12T07:00:22Z

isucon@team306-001:~$ sudo cat log/20200912065711/access.log | alp ltsv -c alp.yml
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+
| COUNT | 2XX  | 4XX | 5XX | METHOD |               URI                |  MIN  |  P50  |  P99  |  MAX  |
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+
|  1202 | 1200 |   2 |   0 | GET    | /api/estate/search               | 0.008 | 0.132 | 0.104 | 0.712 |
|   793 |  792 |   1 |   0 | GET    | /api/chair/search                | 0.014 | 0.152 | 0.216 | 0.732 |
|   782 |  781 |   1 |   0 | GET    | ^/api/estate/[0-9]+$             | 0.000 | 0.008 | 0.000 | 0.064 |
|   504 |  500 |   4 |   0 | GET    | /api/chair/low_priced            | 0.080 | 0.252 | 0.228 | 0.704 |
|   504 |  504 |   0 |   0 | GET    | /api/estate/low_priced           | 0.004 | 0.000 | 0.000 | 0.076 |
|   447 |  447 |   0 |   0 | POST   | ^/api/estate/req_doc/[0-9]+$     | 0.004 | 0.004 | 0.000 | 0.040 |
|   271 |  269 |   2 |   0 | GET    | ^/api/chair/[0-9]+$              | 0.000 | 0.000 | 0.000 | 0.056 |
|   267 |  266 |   1 |   0 | GET    | ^/api/recommended_estate/[0-9]+$ | 0.054 | 0.068 | 0.152 | 0.680 |
|   201 |  201 |   0 |   0 | GET    | /api/estate/search/condition     | 0.004 | 0.000 | 0.000 | 0.004 |
|   172 |  172 |   0 |   0 | POST   | /api/estate/nazotte              | 0.048 | 0.268 | 0.260 | 0.728 |
|   133 |  133 |   0 |   0 | GET    | /api/chair/search/condition      | 0.000 | 0.000 | 0.004 | 0.004 |
|   131 |  131 |   0 |   0 | POST   | ^/api/chair/buy/[0-9]+$          | 0.004 | 0.004 | 0.012 | 0.048 |
|     1 |    1 |   0 |   0 | POST   | /api/estate                      | 0.316 | 0.316 | 0.316 | 0.316 |
|     1 |    1 |   0 |   0 | POST   | /api/chair                       | 0.320 | 0.320 | 0.320 | 0.320 |
|     1 |    1 |   0 |   0 | POST   | /initialize                      | 4.872 | 4.872 | 4.872 | 4.872 |
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+

ken39arg · 2020-09-12T07:33:20Z

isucon@team306-001:~$ sudo cat log/20200912073239/access.log | alp ltsv -c alp.yml
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+
| COUNT | 2XX  | 4XX | 5XX | METHOD |               URI                |  MIN  |  P50  |  P99  |  MAX  |
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+
|  2924 | 2637 |   3 | 284 | GET    | /api/estate/search               | 0.081 | 0.000 | 0.000 | 0.700 |
|  1350 | 1332 |   6 |  12 | GET    | ^/api/estate/[0-9]+$             | 0.000 | 0.000 | 0.004 | 0.396 |
|  1047 |  762 |   1 | 284 | GET    | /api/chair/search                | 0.266 | 0.140 | 0.000 | 0.704 |
|   842 |  836 |   0 |   6 | GET    | /api/estate/low_priced           | 0.004 | 0.004 | 0.008 | 0.072 |
|   842 |  831 |   5 |   6 | GET    | /api/chair/low_priced            | 0.048 | 0.224 | 0.312 | 1.016 |
|   762 |  762 |   0 |   0 | POST   | ^/api/estate/req_doc/[0-9]+$     | 0.000 | 0.000 | 0.004 | 0.056 |
|   445 |  445 |   0 |   0 | GET    | /api/estate/search/condition     | 0.000 | 0.000 | 0.004 | 0.008 |
|   284 |  266 |   6 |  12 | GET    | ^/api/chair/[0-9]+$              | 0.000 | 0.000 | 0.000 | 0.077 |
|   279 |  269 |   0 |  10 | POST   | /api/estate/nazotte              | 0.004 | 0.208 | 0.364 | 0.724 |
|   268 |  254 |   4 |  10 | GET    | ^/api/recommended_estate/[0-9]+$ | 0.026 | 0.168 | 0.140 | 0.556 |
|   132 |  131 |   0 |   1 | GET    | /api/chair/search/condition      | 0.000 | 0.000 | 0.000 | 0.008 |
|   124 |  124 |   0 |   0 | POST   | ^/api/chair/buy/[0-9]+$          | 0.004 | 0.004 | 0.008 | 0.044 |
|     6 |    4 |   0 |   2 | POST   | /api/estate                      | 0.272 | 0.304 | 0.832 | 1.096 |
|     4 |    4 |   0 |   0 | POST   | /api/chair                       | 0.276 | 0.276 | 1.020 | 1.684 |
|     4 |    4 |   0 |   0 | POST   | /initialize                      | 4.828 | 4.848 | 4.828 | 5.568 |
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+

ken39arg · 2020-09-12T07:54:25Z

isucon@team306-001:~$ sudo cat log/20200912075246/access.log | alp ltsv -c alp.yml
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+
| COUNT | 2XX  | 4XX | 5XX | METHOD |               URI                |  MIN  |  P50  |  P99  |  MAX  |
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+
|  5696 | 5133 |   6 | 557 | GET    | /api/estate/search               | 0.218 | 0.000 | 0.000 | 0.660 |
|  2692 | 2683 |   9 |   0 | GET    | ^/api/estate/[0-9]+$             | 0.032 | 0.028 | 0.000 | 0.088 |
|  1998 | 1433 |   8 | 557 | GET    | /api/chair/search                | 0.047 | 0.000 | 0.000 | 0.672 |
|  1768 | 1767 |   1 |   0 | GET    | /api/estate/low_priced           | 0.012 | 0.000 | 0.016 | 0.072 |
|  1768 | 1759 |   9 |   0 | GET    | /api/chair/low_priced            | 0.012 | 0.184 | 0.276 | 1.136 |
|  1581 | 1581 |   0 |   0 | POST   | ^/api/estate/req_doc/[0-9]+$     | 0.008 | 0.008 | 0.008 | 0.064 |
|   861 |  861 |   0 |   0 | GET    | /api/estate/search/condition     | 0.004 | 0.000 | 0.000 | 0.012 |
|   662 |  660 |   2 |   0 | POST   | /api/estate/nazotte              | 0.004 | 0.016 | 0.092 | 0.424 |
|   498 |  488 |  10 |   0 | GET    | ^/api/chair/[0-9]+$              | 0.000 | 0.004 | 0.004 | 0.064 |
|   480 |  480 |   0 |   0 | GET    | ^/api/recommended_estate/[0-9]+$ | 0.048 | 0.212 | 0.224 | 0.544 |
|   245 |  245 |   0 |   0 | GET    | /api/chair/search/condition      | 0.000 | 0.000 | 0.000 | 0.012 |
|   237 |  237 |   0 |   0 | POST   | ^/api/chair/buy/[0-9]+$          | 0.004 | 0.012 | 0.028 | 0.056 |
|     7 |    6 |   1 |   0 | POST   | /api/chair                       | 0.112 | 1.720 | 1.300 | 1.720 |
|     7 |    6 |   1 |   0 | POST   | /api/estate                      | 0.116 | 1.080 | 0.576 | 1.080 |
|     2 |    2 |   0 |   0 | POST   | /initialize                      | 5.088 | 6.036 | 6.036 | 6.036 |
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+

ken39arg · 2020-09-12T08:25:07Z

isucon@team306-001:~$ sudo cat log/20200912082436/access.log | alp ltsv -c alp.yml
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+
| COUNT | 2XX  | 4XX | 5XX | METHOD |               URI                |  MIN  |  P50  |  P99  |  MAX  |
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+
|  5433 | 5114 |   5 | 314 | GET    | /api/estate/search               | 0.036 | 0.120 | 0.328 | 0.704 |
|  2543 | 2537 |   6 |   0 | GET    | ^/api/estate/[0-9]+$             | 0.004 | 0.000 | 0.004 | 0.192 |
|  1955 | 1636 |   5 | 314 | GET    | /api/chair/search                | 0.023 | 0.072 | 0.000 | 0.712 |
|  1534 | 1522 |  12 |   0 | GET    | /api/chair/low_priced            | 0.018 | 0.132 | 0.284 | 1.476 |
|  1534 | 1534 |   0 |   0 | GET    | /api/estate/low_priced           | 0.004 | 0.008 | 0.032 | 0.076 |
|  1409 | 1409 |   0 |   0 | POST   | ^/api/estate/req_doc/[0-9]+$     | 0.000 | 0.000 | 0.000 | 0.168 |
|   857 |  857 |   0 |   0 | GET    | /api/estate/search/condition     | 0.000 | 0.000 | 0.000 | 0.012 |
|   556 |  547 |   9 |   0 | GET    | ^/api/chair/[0-9]+$              | 0.000 | 0.032 | 0.028 | 0.116 |
|   538 |  534 |   4 |   0 | GET    | ^/api/recommended_estate/[0-9]+$ | 0.020 | 0.056 | 0.224 | 0.536 |
|   399 |  399 |   0 |   0 | POST   | /api/estate/nazotte              | 0.004 | 0.148 | 0.216 | 0.644 |
|   280 |  280 |   0 |   0 | GET    | /api/chair/search/condition      | 0.000 | 0.000 | 0.000 | 0.016 |
|   262 |  262 |   0 |   0 | POST   | ^/api/chair/buy/[0-9]+$          | 0.004 | 0.004 | 0.004 | 0.360 |
|     6 |    6 |   0 |   0 | POST   | /api/chair                       | 0.096 | 0.128 | 1.168 | 1.784 |
|     6 |    6 |   0 |   0 | POST   | /api/estate                      | 0.104 | 0.128 | 0.676 | 0.708 |
|     6 |    3 |   0 |   3 | POST   | /initialize                      | 0.100 | 0.100 | 5.940 | 5.940 |
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+

ken39arg · 2020-09-12T09:05:34Z

isucon@team306-001:~$ sudo cat log/20200912090445/access.log | alp ltsv -c alp.yml
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+
| COUNT | 2XX  | 4XX | 5XX | METHOD |               URI                |  MIN  |  P50  |  P99  |  MAX  |
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+
|  2582 | 2280 |   3 | 299 | GET    | /api/estate/search               | 0.005 | 0.000 | 0.004 | 0.620 |
|  1303 | 1299 |   4 |   0 | GET    | ^/api/estate/[0-9]+$             | 0.004 | 0.000 | 0.004 | 0.060 |
|  1179 |  876 |   4 | 299 | GET    | /api/chair/search                | 0.072 | 0.176 | 0.000 | 0.800 |
|   867 |  860 |   7 |   0 | GET    | /api/chair/low_priced            | 0.088 | 0.236 | 0.548 | 1.252 |
|   867 |  867 |   0 |   0 | GET    | /api/estate/low_priced           | 0.004 | 0.004 | 0.000 | 0.068 |
|   770 |  770 |   0 |   0 | POST   | ^/api/estate/req_doc/[0-9]+$     | 0.004 | 0.000 | 0.000 | 0.032 |
|   382 |  382 |   0 |   0 | GET    | /api/estate/search/condition     | 0.004 | 0.004 | 0.000 | 0.016 |
|   333 |  333 |   0 |   0 | POST   | /api/estate/nazotte              | 0.004 | 0.004 | 0.004 | 0.300 |
|   300 |  295 |   5 |   0 | GET    | ^/api/chair/[0-9]+$              | 0.000 | 0.000 | 0.000 | 0.060 |
|   291 |  291 |   0 |   0 | GET    | ^/api/recommended_estate/[0-9]+$ | 0.056 | 0.152 | 0.172 | 0.520 |
|   148 |  148 |   0 |   0 | GET    | /api/chair/search/condition      | 0.000 | 0.000 | 0.000 | 0.016 |
|   144 |  144 |   0 |   0 | POST   | ^/api/chair/buy/[0-9]+$          | 0.004 | 0.012 | 0.180 | 0.180 |
|     4 |    3 |   1 |   0 | POST   | /api/estate                      | 0.132 | 0.468 | 0.580 | 0.924 |
|     4 |    3 |   1 |   0 | POST   | /api/chair                       | 0.136 | 1.020 | 1.500 | 1.500 |
|     1 |    1 |   0 |   0 | POST   | /initialize                      | 5.940 | 5.940 | 5.940 | 5.940 |
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+

ken39arg · 2020-09-12T09:24:48Z

isucon@team306-001:~$ sudo cat log/20200912092357/access.log | alp ltsv -c alp.yml
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+
| COUNT | 2XX  | 4XX | 5XX | METHOD |               URI                |  MIN  |  P50  |  P99  |  MAX  |
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+
|  2765 | 2444 |   2 | 319 | GET    | /api/estate/search               | 0.126 | 0.000 | 0.344 | 0.564 |
|  1369 | 1365 |   4 |   0 | GET    | ^/api/estate/[0-9]+$             | 0.004 | 0.000 | 0.004 | 0.076 |
|  1250 |  927 |   4 | 319 | GET    | /api/chair/search                | 0.068 | 0.060 | 0.296 | 0.588 |
|   906 |  906 |   0 |   0 | GET    | /api/estate/low_priced           | 0.004 | 0.000 | 0.000 | 0.040 |
|   906 |  899 |   7 |   0 | GET    | /api/chair/low_priced            | 0.025 | 0.240 | 0.464 | 1.344 |
|   799 |  799 |   0 |   0 | POST   | ^/api/estate/req_doc/[0-9]+$     | 0.000 | 0.004 | 0.000 | 0.008 |
|   409 |  409 |   0 |   0 | GET    | /api/estate/search/condition     | 0.000 | 0.000 | 0.000 | 0.016 |
|   333 |  333 |   0 |   0 | POST   | /api/estate/nazotte              | 0.048 | 0.084 | 0.000 | 0.292 |
|   319 |  314 |   5 |   0 | GET    | ^/api/chair/[0-9]+$              | 0.004 | 0.004 | 0.004 | 0.076 |
|   309 |  308 |   1 |   0 | GET    | ^/api/recommended_estate/[0-9]+$ | 0.030 | 0.056 | 0.180 | 0.600 |
|   157 |  157 |   0 |   0 | GET    | /api/chair/search/condition      | 0.000 | 0.000 | 0.004 | 0.016 |
|   152 |  152 |   0 |   0 | POST   | ^/api/chair/buy/[0-9]+$          | 0.004 | 0.008 | 0.004 | 0.064 |
|     4 |    4 |   0 |   0 | POST   | /api/estate                      | 0.120 | 0.584 | 0.588 | 0.668 |
|     4 |    4 |   0 |   0 | POST   | /api/chair                       | 0.132 | 0.928 | 1.765 | 2.284 |
|     1 |    1 |   0 |   0 | POST   | /initialize                      | 5.968 | 5.968 | 5.968 | 5.968 |
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+

ken39arg · 2020-09-12T09:33:35Z

isucon@team306-001:~$ sudo cat log/20200912093258/access.log | alp ltsv -c alp.yml
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+
| COUNT | 2XX  | 4XX | 5XX | METHOD |               URI                |  MIN  |  P50  |  P99  |  MAX  |
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+
|  3727 | 2788 |   8 | 931 | GET    | /api/estate/search               | 0.130 | 0.000 | 0.000 | 1.664 |
|  2696 | 2691 |   5 |   0 | GET    | /api/estate/low_priced           | 0.004 | 0.004 | 0.004 | 0.168 |
|  2695 | 2695 |   0 |   0 | GET    | /api/chair/low_priced            | 0.004 | 0.012 | 0.024 | 0.140 |
|  2636 | 2624 |  12 |   0 | GET    | ^/api/estate/[0-9]+$             | 0.000 | 0.004 | 0.004 | 0.152 |
|  2081 | 2081 |   0 |   0 | POST   | ^/api/estate/req_doc/[0-9]+$     | 0.000 | 0.000 | 0.008 | 0.100 |
|  2009 | 2006 |   3 |   0 | POST   | /api/estate/nazotte              | 0.004 | 0.044 | 0.220 | 0.976 |
|  1664 |  705 |  28 | 931 | GET    | /api/chair/search                | 0.055 | 0.000 | 0.000 | 2.002 |
|   520 |  520 |   0 |   0 | GET    | /api/estate/search/condition     | 0.000 | 0.000 | 0.000 | 0.012 |
|   222 |  210 |  12 |   0 | GET    | ^/api/chair/[0-9]+$              | 0.004 | 0.004 | 0.004 | 0.088 |
|   198 |  198 |   0 |   0 | GET    | ^/api/recommended_estate/[0-9]+$ | 0.004 | 0.084 | 1.444 | 1.868 |
|   168 |  168 |   0 |   0 | GET    | /api/chair/search/condition      | 0.004 | 0.000 | 0.000 | 0.008 |
|    89 |   89 |   0 |   0 | POST   | ^/api/chair/buy/[0-9]+$          | 0.040 | 0.008 | 0.040 | 0.608 |
|    11 |   11 |   0 |   0 | POST   | /api/estate                      | 0.128 | 1.048 | 1.908 | 2.132 |
|    11 |   11 |   0 |   0 | POST   | /api/chair                       | 0.132 | 1.444 | 2.672 | 2.912 |
|     1 |    1 |   0 |   0 | POST   | /initialize                      | 6.020 | 6.020 | 6.020 | 6.020 |
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+

ken39arg · 2020-09-12T09:40:19Z

isucon@team306-001:~$ sudo cat log/20200912093923/access.log | alp ltsv -c alp.yml
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+
| COUNT | 2XX  | 4XX | 5XX | METHOD |               URI                |  MIN  |  P50  |  P99  |  MAX  |
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+
|  3735 | 2795 |   6 | 934 | GET    | /api/estate/search               | 0.001 | 0.000 | 0.000 | 1.824 |
|  2841 | 2841 |   0 |   0 | GET    | /api/estate/low_priced           | 0.004 | 0.000 | 0.004 | 0.164 |
|  2841 | 2840 |   1 |   0 | GET    | /api/chair/low_priced            | 0.037 | 0.000 | 0.028 | 0.172 |
|  2734 | 2723 |  11 |   0 | GET    | ^/api/estate/[0-9]+$             | 0.004 | 0.000 | 0.000 | 0.116 |
|  2178 | 2177 |   1 |   0 | POST   | ^/api/estate/req_doc/[0-9]+$     | 0.009 | 0.004 | 0.012 | 0.076 |
|  2152 | 2144 |   8 |   0 | POST   | /api/estate/nazotte              | 0.002 | 0.004 | 0.040 | 0.860 |
|  1647 |  686 |  27 | 934 | GET    | /api/chair/search                | 0.121 | 0.000 | 0.000 | 2.001 |
|   526 |  526 |   0 |   0 | GET    | /api/estate/search/condition     | 0.004 | 0.000 | 0.004 | 0.008 |
|   224 |  212 |  12 |   0 | GET    | ^/api/chair/[0-9]+$              | 0.004 | 0.004 | 0.004 | 0.092 |
|   200 |  199 |   1 |   0 | GET    | ^/api/recommended_estate/[0-9]+$ | 1.076 | 0.116 | 0.880 | 2.000 |
|   168 |  168 |   0 |   0 | GET    | /api/chair/search/condition      | 0.000 | 0.000 | 0.004 | 0.004 |
|    89 |   89 |   0 |   0 | POST   | ^/api/chair/buy/[0-9]+$          | 0.004 | 0.008 | 0.048 | 0.084 |
|    11 |   11 |   0 |   0 | POST   | /api/estate                      | 0.144 | 1.060 | 1.900 | 2.224 |
|    11 |   11 |   0 |   0 | POST   | /api/chair                       | 0.148 | 1.268 | 2.960 | 2.960 |
|     1 |    1 |   0 |   0 | POST   | /initialize                      | 6.108 | 6.108 | 6.108 | 6.108 |
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+

ken39arg · 2020-09-12T09:52:09Z

isucon@team306-002:~$ sudo cat log/20200912095132/access.log | alp ltsv -c alp.yml
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+
| COUNT | 2XX  | 4XX | 5XX | METHOD |               URI                |  MIN  |  P50  |  P99  |  MAX  |
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+
|  3722 | 2758 |   8 | 956 | GET    | /api/estate/search               | 0.001 | 0.004 | 0.000 | 1.436 |
|  2872 | 2872 |   0 |   0 | GET    | /api/estate/low_priced           | 0.004 | 0.004 | 0.004 | 0.192 |
|  2872 | 2871 |   1 |   0 | GET    | /api/chair/low_priced            | 0.003 | 0.004 | 0.004 | 0.148 |
|  2756 | 2744 |  12 |   0 | GET    | ^/api/estate/[0-9]+$             | 0.004 | 0.004 | 0.004 | 0.360 |
|  2195 | 2188 |   7 |   0 | POST   | /api/estate/nazotte              | 0.004 | 0.124 | 0.016 | 1.164 |
|  2189 | 2189 |   0 |   0 | POST   | ^/api/estate/req_doc/[0-9]+$     | 0.008 | 0.016 | 0.000 | 0.148 |
|  1850 |  885 |   9 | 956 | GET    | /api/chair/search                | 0.157 | 0.000 | 0.000 | 2.001 |
|   506 |  506 |   0 |   0 | GET    | /api/estate/search/condition     | 0.000 | 0.000 | 0.000 | 0.012 |
|   284 |  272 |  12 |   0 | GET    | ^/api/chair/[0-9]+$              | 0.004 | 0.004 | 0.004 | 0.388 |
|   260 |  254 |   6 |   0 | GET    | ^/api/recommended_estate/[0-9]+$ | 0.004 | 0.068 | 1.512 | 2.003 |
|   176 |  176 |   0 |   0 | GET    | /api/chair/search/condition      | 0.000 | 0.000 | 0.000 | 0.012 |
|   112 |  112 |   0 |   0 | POST   | ^/api/chair/buy/[0-9]+$          | 0.004 | 0.008 | 0.056 | 0.080 |
|    11 |   11 |   0 |   0 | POST   | /api/estate                      | 0.136 | 0.952 | 1.864 | 2.072 |
|    11 |   11 |   0 |   0 | POST   | /api/chair                       | 0.136 | 1.332 | 2.332 | 2.456 |
|     1 |    1 |   0 |   0 | POST   | /initialize                      | 6.072 | 6.072 | 6.072 | 6.072 |
+-------+------+-----+-----+--------+----------------------------------+-------+-------+-------+-------+

構成を変えた

ken39arg · 2020-09-12T12:00:58Z

ID	Score	Status	Time	Duration
#26592	2635	FINISHED	2020-09-12 20:55:05.044	a minute
#26460	2598	FINISHED	2020-09-12 20:53:40.478	a minute
#26308	2596	FINISHED	2020-09-12 20:52:09.077	a minute
#26041	2601	FINISHED	2020-09-12 20:49:47.665	a minute
#25854	2775	FINISHED	2020-09-12 20:47:56.121	a minute
#25607	2867	FINISHED	2020-09-12 20:45:37.153	a minute
#25235	2747	FINISHED	2020-09-12 20:42:24.831	a minute
#24935	0	FINISHED	2020-09-12 20:39:19.968	a minute
#24737	0	FINISHED	2020-09-12 20:37:23.033	a minute
#24593	0	FINISHED	2020-09-12 20:35:53.359	a minute
#24244	0	FINISHED	2020-09-12 20:32:25.449	a few seconds
#23995	0	FINISHED	2020-09-12 20:29:51.942	a few seconds
#23682	0	FINISHED	2020-09-12 20:26:33.507	a few seconds
#21343	2430	FINISHED	2020-09-12 20:01:00.292	a minute
#21094	0	FINISHED	2020-09-12 19:58:00.056	a few seconds
#20876	0	FINISHED	2020-09-12 19:55:14.779	a few seconds
#20291	2574	FINISHED	2020-09-12 19:48:02.948	a minute
#19785	2777	FINISHED	2020-09-12 19:41:16.501	a minute
#19150	2572	FINISHED	2020-09-12 19:33:17.949	a minute
#18792	2518	FINISHED	2020-09-12 19:28:50.164	a minute
#18512	2653	FINISHED	2020-09-12 19:25:10.131	a minute
#18254	2579	FINISHED	2020-09-12 19:21:58.125	a minute
#17854	2317	CANCELLED	2020-09-12 19:16:52.827	2 hours
#17032	2294	FINISHED	2020-09-12 19:06:25.328	a minute
#16237	2368	FINISHED	2020-09-12 18:56:43.099	a minute
#15720	2301	FINISHED	2020-09-12 18:49:33.806	a minute
#14845	2266	FINISHED	2020-09-12 18:37:38.242	a minute
#14356	2170	FINISHED	2020-09-12 18:31:03.640	a minute
#13686	951	FINISHED	2020-09-12 18:22:21.517	a minute
#12289	914	FINISHED	2020-09-12 18:02:12.837	a minute
#12037	938	FINISHED	2020-09-12 17:58:40.446	a minute
#11809	0	FINISHED	2020-09-12 17:54:49.119	a few seconds
#11047	946	FINISHED	2020-09-12 17:42:46.957	a minute
#10348	966	FINISHED	2020-09-12 17:30:38.510	a minute
#9863	952	FINISHED	2020-09-12 17:22:55.091	a minute
#9700	352	CANCELLED	2020-09-12 17:20:05.719	4 hours
#9652	0	FINISHED	2020-09-12 17:18:56.718	a few seconds
#9575	0	FINISHED	2020-09-12 17:17:47.078	a few seconds
#9481	0	FINISHED	2020-09-12 17:16:05.514	a few seconds
#8924	0	FINISHED	2020-09-12 17:06:30.404	a few seconds
#8063	909	FINISHED	2020-09-12 16:50:33.505	a minute
#7573	909	FINISHED	2020-09-12 16:39:25.370	a minute
#7224	885	FINISHED	2020-09-12 16:30:45.698	a minute
#7109	0	FINISHED	2020-09-12 16:28:33.985	a few seconds
#7022	0	FINISHED	2020-09-12 16:26:29.761	a few seconds
#6900	0	FINISHED	2020-09-12 16:23:48.762	a few seconds
#5470	578	FINISHED	2020-09-12 15:55:13.689	a minute
#4813	701	FINISHED	2020-09-12 15:41:06.496	a minute
#3930	0	FINISHED	2020-09-12 15:23:25.989	a few seconds
#3863	0	FINISHED	2020-09-12 15:22:11.980	a few seconds
#3429	0	FINISHED	2020-09-12 15:13:01.649	a few seconds
#3320	0	FINISHED	2020-09-12 15:10:44.049	a few seconds
#2921	0	FINISHED	2020-09-12 15:01:35.253	a few seconds
#2852	0	FINISHED	2020-09-12 15:00:01.492	a few seconds
#2748	0	FINISHED	2020-09-12 14:58:07.788	a few seconds
#2344	0	FINISHED	2020-09-12 14:51:45.897	a few seconds
#1696	0	CANCELLED	2020-09-12 14:03:50.165	19 minutes
#834	473	FINISHED	2020-09-12 13:32:26.865	a minute
#144	489	FINISHED	2020-09-12 13:15:00.692	a minute

ken39arg added the MEMO label Sep 11, 2020

ken39arg closed this as completed Sep 14, 2020

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

TODOリスト #1

TODOリスト #1

ken39arg commented Sep 9, 2020 •

edited

ken39arg commented Sep 10, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

TODOリスト #1

TODOリスト #1

Comments

ken39arg commented Sep 9, 2020 • edited

やらないこと

当日まずやることリスト

戦略を決める

改善に着手

最終チェック

ken39arg commented Sep 10, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 12, 2020

ken39arg commented Sep 9, 2020 •

edited