Open polamjag opened 4 years ago
完全初期状態 (server-1) https://portal.isucon.net/contestant/benchmark_jobs/101
Score: 4343
完全初期状態 (server-2) https://portal.isucon.net/contestant/benchmark_jobs/119
Score: 4391
完全初期状態 (server-3) https://portal.isucon.net/contestant/benchmark_jobs/125
Score: 4216
Go に変えた (server-1) https://portal.isucon.net/contestant/benchmark_jobs/202 Score: 6490
↑ dstat https://gist.github.com/tatsuru/64c72063839e4383a14d999651ea94c7 02:02:27 からがベンチ走行
Go server-3 4core https://portal.isucon.net/contestant/benchmark_jobs/214 Score: 7617 dstat https://gist.github.com/tatsuru/64c72063839e4383a14d999651ea94c7#file-dstat-4core
server-3 https://portal.isucon.net/contestant/benchmark_jobs/321
htop で CPU の様子眺めた、mysqld : app : envoy = 6 : 3 : 1 くらいの雰囲気
初期状態 pt-query-digest https://gist.github.com/tatsuru/aab63808c8df4d4bdb1607c2b229921e
server-3 https://portal.isucon.net/contestant/benchmark_jobs/1365
server-3 https://portal.isucon.net/contestant/benchmark_jobs/1406
667 mysql 20 0 2842444 513472 9068 S 220.7 50.6 9:24.04 mysqld
988 isucon 20 0 1382752 31020 11864 S 107.7 3.1 0:42.81 xsuportal
869 isucon 20 0 135616 30868 8200 S 18.3 3.0 0:09.56 envoy
server-2 https://portal.isucon.net/contestant/benchmark_jobs/1532
Score: 8837
Score Breakdown: base=8937, deduction=100
https://portal.isucon.net/contestant/benchmark_jobs/1568
https://portal.isucon.net/contestant/benchmark_jobs/1690
Score: 9559
初期実装 server-2 https://portal.isucon.net/contestant/benchmark_jobs/1586
https://portal.isucon.net/contestant/benchmark_jobs/1821
c6c3a220343edb8a60ee2c06bfcf886217ca73fa
Score: 10630
Score: 6430
61f5312e8f4023af7da8e3fec8ff22533dd6ceb6 https://portal.isucon.net/contestant/benchmark_jobs/1917
Score: 12118
server3 https://portal.isucon.net/contestant/benchmark_jobs/2183
CPUちょっと遊んでる気がするんだよなぁ
time |usr sys idl wai stl| read writ| recv send| in out | int csw | used free buff cach| recv send
03-10 07:34:10| 50 12 38 0 1| 0 0 |6830k 48M| 0 0 | 34k 40k| 533M 52.4M 10.3M 354M|6830k 48M
03-10 07:34:11| 51 15 34 0 1| 0 0 |7939k 61M| 0 0 | 37k 44k| 534M 50.3M 10.3M 356M|7938k 61M
03-10 07:34:12| 53 12 35 0 1| 12k 48k|7008k 61M| 0 0 | 32k 35k| 534M 48.6M 10.3M 357M|7009k 61M
03-10 07:34:13| 49 10 40 0 1| 0 0 |6753k 52M| 0 0 | 30k 33k| 535M 46.2M 10.3M 359M|6755k 52M
03-10 07:34:14| 54 16 29 0 1| 0 0 |7393k 59M| 0 0 | 35k 40k| 535M 43.5M 10.3M 361M|7391k 59M
03-10 07:34:15| 57 13 30 0 1| 0 0 |8217k 61M| 0 0 | 37k 42k| 535M 41.1M 10.3M 363M|8218k 61M
03-10 07:34:16| 54 12 26 8 0| 0 20M|8010k 65M| 0 0 | 33k 36k| 536M 38.2M 10.3M 365M|8011k 65M
time |usr sys idl wai stl| read writ| recv send| in out | int csw | used free buff cach| recv send
03-10 07:34:07| 73 11 14 2 1| 0 3196k|1017k 6939k| 0 0 | 15k 14k| 568M 172M 79.8M 1107M|1017k 6943k
03-10 07:34:08| 66 10 22 2 1| 0 2956k|1175k 6628k| 0 0 | 18k 15k| 568M 172M 79.8M 1107M|1174k 6624k
03-10 07:34:09| 59 12 23 3 2| 0 3812k|1102k 5476k| 0 0 | 19k 16k| 568M 172M 79.8M 1108M|1102k 5476k
03-10 07:34:10| 74 13 11 1 1| 0 4068k|1171k 6985k| 0 0 | 19k 17k| 568M 171M 79.8M 1108M|1171k 6985k
03-10 07:34:11| 69 14 14 1 1| 0 3764k|1214k 7388k| 0 0 | 19k 16k| 569M 171M 79.9M 1108M|1214k 7388k
03-10 07:34:12| 51 9 37 2 2| 0 2172k| 994k 5148k| 0 0 | 17k 14k| 569M 171M 79.9M 1108M| 994k 5150k
03-10 07:34:13| 59 13 25 3 1| 0 4180k|1212k 6644k| 0 0 | 20k 17k| 569M 170M 79.9M 1109M|1212k 6643k
03-10 07:34:14| 60 15 18 3 3| 0 4628k|1171k 6908k| 0 0 | 18k 17k| 570M 169M 79.9M 1109M|1170k 6907k
Score: 13803 (参考)
Score: 20855
https://portal.isucon.net/contestant/benchmark_jobs/2360
+-------+-----+-------+------+-----+-----+--------+-----------------------------------------------------------------------+---------+-----------+-------------+---------+---------+---------+----------+----------+------------+------------+----------------+------------+
| COUNT | 1XX | 2XX | 3XX | 4XX | 5XX | METHOD | URI | MIN | MAX | SUM | AVG | P1 | P50 | P99 | STDDEV | MIN(BODY) | MAX(BODY) | SUM(BODY) | AVG(BODY) |
+-------+-----+-------+------+-----+-----+--------+-----------------------------------------------------------------------+---------+-----------+-------------+---------+---------+---------+----------+----------+------------+------------+----------------+------------+
| 15945 | 0 | 15943 | 0 | 2 | 0 | GET | /api/contestant/notifications | 2.000 | 4417.000 | 2154862.000 | 135.143 | 27.000 | 134.000 | 95.000 | 215.414 | 2.000 | 97.000 | 78115.000 | 4.899 |
| 2862 | 0 | 2834 | 0 | 0 | 0 | POST | /xsuportal.proto.services.bench.BenchmarkQueue/ReceiveBenchmarkJob | 5.000 | 7454.000 | 1693253.000 | 591.633 | 469.000 | 155.000 | 536.000 | 514.933 | 0.000 | 80.000 | 81977.000 | 28.643 |
| 2899 | 0 | 2892 | 0 | 2 | 0 | GET | /api/contestant/dashboard | 2.000 | 2013.000 | 713240.000 | 246.030 | 312.000 | 103.000 | 42.000 | 240.426 | 61094.000 | 68820.000 | 123182164.000 | 42491.260 |
| 910 | 0 | 910 | 0 | 0 | 0 | POST | /xsuportal.proto.services.bench.BenchmarkReport/ReportBenchmarkResult | 38.000 | 4617.000 | 665191.000 | 730.979 | 481.000 | 799.000 | 2063.000 | 655.855 | 9.000 | 18.000 | 16185.000 | 17.786 |
| 25932 | 0 | 25928 | 0 | 0 | 0 | GET | /api/audience/dashboard | 1.000 | 2000.000 | 530255.000 | 20.448 | 0.000 | 2.000 | 12.000 | 97.777 | 61094.000 | 68820.000 | 1318348560.000 | 50838.677 |
| 803 | 0 | 801 | 0 | 2 | 0 | GET | /api/contestant/clarifications | 2.000 | 5182.000 | 495916.000 | 617.579 | 46.000 | 428.000 | 1013.000 | 754.472 | 415.000 | 8100.000 | 3016983.000 | 3757.139 |
| 2859 | 0 | 2857 | 0 | 2 | 0 | GET | /api/contestant/benchmark_jobs | 1.000 | 2956.000 | 414841.000 | 145.100 | 194.000 | 80.000 | 99.000 | 214.436 | 249.000 | 13179.000 | 10760826.000 | 3763.843 |
| 2047 | 0 | 2047 | 0 | 0 | 0 | GET | /api/session | 1.000 | 2749.000 | 348057.000 | 170.033 | 4.000 | 307.000 | 969.000 | 240.399 | 123.000 | 568.000 | 989178.000 | 483.233 |
| 901 | 0 | 899 | 0 | 2 | 0 | GET | /api/contestant/benchmark_jobs/[0-9]+ | 1.000 | 2868.000 | 152689.000 | 169.466 | 33.000 | 59.000 | 72.000 | 248.915 | 61.000 | 311.000 | 249120.000 | 276.493 |
| 205 | 0 | 202 | 0 | 2 | 0 | PUT | /api/admin/clarifications/[0-9]+ | 1.000 | 10001.000 | 107591.000 | 524.834 | 1.000 | 277.000 | 401.000 | 1233.348 | 328.000 | 499.000 | 88069.000 | 429.605 |
| 916 | 0 | 911 | 0 | 5 | 0 | POST | /api/contestant/benchmark_jobs | 2.000 | 1197.000 | 69855.000 | 76.261 | 30.000 | 48.000 | 414.000 | 115.161 | 54.000 | 127.000 | 52545.000 | 57.364 |
| 234 | 0 | 232 | 0 | 2 | 0 | POST | /api/contestant/clarifications | 1.000 | 2724.000 | 53590.000 | 229.017 | 2.000 | 245.000 | 2724.000 | 311.063 | 61.000 | 436.000 | 89036.000 | 380.496 |
| 2945 | 0 | 1505 | 1440 | 0 | 0 | GET | /packs/vendor.js | 0.000 | 1048.000 | 33996.000 | 11.544 | 95.000 | 5.000 | 2.000 | 50.129 | 492294.000 | 492294.000 | 740902470.000 | 251579.786 |
| 2945 | 0 | 1527 | 1418 | 0 | 0 | GET | /packs/vendor.css | 0.000 | 1063.000 | 29055.000 | 9.866 | 130.000 | 4.000 | 2.000 | 39.143 | 213600.000 | 213600.000 | 326167200.000 | 110752.869 |
| 2945 | 0 | 1533 | 1412 | 0 | 0 | GET | /favicon.ico | 0.000 | 1063.000 | 17871.000 | 6.068 | 1.000 | 7.000 | 2.000 | 37.118 | 1150.000 | 1150.000 | 1762950.000 | 598.625 |
| 1754 | 0 | 540 | 1214 | 0 | 0 | GET | /packs/contestant.js | 0.000 | 658.000 | 16067.000 | 9.160 | 75.000 | 15.000 | 3.000 | 31.652 | 0.000 | 23940.000 | 12927600.000 | 7370.353 |
| 205 | 0 | 203 | 0 | 2 | 0 | GET | /api/admin/clarifications/[0-9]+ | 1.000 | 333.000 | 12827.000 | 62.571 | 1.000 | 16.000 | 76.000 | 64.326 | 61.000 | 436.000 | 77897.000 | 379.985 |
| 801 | 0 | 227 | 574 | 0 | 0 | GET | /contestant/clarifications | 0.000 | 717.000 | 11381.000 | 14.208 | 2.000 | 1.000 | 5.000 | 71.466 | 0.000 | 391.000 | 88757.000 | 110.808 |
| 1132 | 0 | 1076 | 56 | 0 | 0 | GET | /packs/audience.js | 1.000 | 261.000 | 10663.000 | 9.420 | 6.000 | 0.000 | 3.000 | 27.169 | 28738.000 | 28738.000 | 30922088.000 | 27316.332 |
| 120 | 0 | 120 | 0 | 0 | 0 | POST | /api/contestant/push_subscriptions | 9.000 | 276.000 | 9290.000 | 77.417 | 48.000 | 267.000 | 83.000 | 68.920 | 0.000 | 0.000 | 0.000 | 0.000 |
| 62 | 0 | 60 | 0 | 2 | 0 | GET | /api/admin/clarifications | 1.000 | 2413.000 | 8633.000 | 139.242 | 2.000 | 1.000 | 2413.000 | 383.305 | 2278.000 | 99516.000 | 458479.000 | 7394.823 |
| 65 | 0 | 41 | 0 | 24 | 0 | POST | /api/registration/team | 2.000 | 281.000 | 6481.000 | 99.708 | 2.000 | 127.000 | 160.000 | 53.117 | 2.000 | 91.000 | 1714.000 | 26.369 |
| 953 | 0 | 291 | 662 | 0 | 0 | GET | /contestant | 0.000 | 823.000 | 6405.000 | 6.721 | 7.000 | 5.000 | 2.000 | 46.315 | 0.000 | 391.000 | 113781.000 | 119.392 |
| 84 | 0 | 82 | 0 | 2 | 0 | POST | /api/registration/contestant | 2.000 | 270.000 | 5696.000 | 67.810 | 8.000 | 97.000 | 60.000 | 60.410 | 0.000 | 97.000 | 152.000 | 1.810 |
| 41 | 0 | 41 | 0 | 0 | 0 | GET | /api/registration/session | 5.000 | 300.000 | 5660.000 | 138.049 | 5.000 | 53.000 | 193.000 | 77.293 | 433.000 | 511.000 | 19895.000 | 485.244 |
| 150 | 0 | 149 | 0 | 1 | 0 | POST | /api/signup | 4.000 | 281.000 | 5525.000 | 36.833 | 5.000 | 25.000 | 36.000 | 41.300 | 0.000 | 77.000 | 77.000 | 0.513 |
| 899 | 0 | 899 | 0 | 0 | 0 | GET | / | 0.000 | 909.000 | 5411.000 | 6.019 | 1.000 | 0.000 | 4.000 | 47.432 | 389.000 | 389.000 | 349711.000 | 389.000 |
| 149 | 0 | 148 | 1 | 0 | 0 | GET | /signup | 2.000 | 183.000 | 1422.000 | 9.544 | 4.000 | 17.000 | 8.000 | 22.268 | 389.000 | 389.000 | 57572.000 | 386.389 |
| 84 | 0 | 84 | 0 | 0 | 0 | GET | /registration | 1.000 | 68.000 | 1095.000 | 13.036 | 8.000 | 16.000 | 2.000 | 14.657 | 389.000 | 389.000 | 32676.000 | 389.000 |
| 2 | 0 | 2 | 0 | 0 | 0 | POST | /initialize | 208.000 | 369.000 | 577.000 | 288.500 | 208.000 | 208.000 | 208.000 | 80.500 | 28.000 | 28.000 | 56.000 | 28.000 |
| 59 | 0 | 14 | 45 | 0 | 0 | GET | /admin/clarifications | 0.000 | 63.000 | 126.000 | 2.136 | 0.000 | 1.000 | 0.000 | 9.291 | 386.000 | 386.000 | 5404.000 | 91.593 |
| 59 | 0 | 15 | 44 | 0 | 0 | GET | /packs/admin.js | 0.000 | 32.000 | 125.000 | 2.119 | 0.000 | 0.000 | 0.000 | 6.700 | 0.000 | 7907.000 | 118605.000 | 2010.254 |
| 6 | 0 | 4 | 0 | 2 | 0 | POST | /api/login | 1.000 | 9.000 | 15.000 | 2.500 | 1.000 | 1.000 | 9.000 | 2.930 | 0.000 | 137.000 | 274.000 | 45.667 |
+-------+-----+-------+------+-----+-----+--------+-----------------------------------------------------------------------+---------+-----------+-------------+---------+---------+---------+----------+----------+------------+------------+----------------+------------+
pt-query-digest https://gist.github.com/tatsuru/9cff7bd2265e10357f4f1e5767022184
Score: 25288 https://portal.isucon.net/contestant/benchmark_jobs/2521
Score: 25974
https://portal.isucon.net/contestant/benchmark_jobs/5721
https://portal.isucon.net/contestant/benchmark_jobs/5727
https://portal.isucon.net/contestant/benchmark_jobs/5730
https://portal.isucon.net/contestant/benchmark_jobs/5855
https://portal.isucon.net/contestant/benchmark_jobs/5869