search

bellwood4486 / isucon11-qualify

ISUCON11 予選 (ISUCONDITION)
MIT License
1 stars 0 forks source link

Score #7

Open bellwood4486 opened 3 years ago

bellwood4486 commented 3 years ago

最初

06:18:01.201517 score: 2196(2220 - 24) : pass
bellwood4486 commented 3 years ago

スロークエリ有効化

06:42:50.500923 score: 3603(3618 - 15) : pass
bellwood4486 commented 3 years ago

アクセルログをltsvに

07:00:10.746908 score: 3998(4012 - 14) : pass
bellwood4486 commented 3 years ago

pprofを入れた

13:35:41.028719 score: 1542(1572 - 30) : pass
bellwood4486 commented 3 years ago

warn logをコメントアウト (#10 ) + pprof

14:08:47.966127 score: 3669(3684 - 15) : pass
bellwood4486 commented 3 years ago

IsuConditionをbulk insertで書き込む(#11 ) + pprof

13:06:57.051891 score: 4472(4484 - 12) : pass

pprofなし

13:16:06.393188 score: 4455(4472 - 17) : pass
bellwood4486 commented 3 years ago

IsuConditionに複合インデックスを追加する(#12 ) + pprof

13:32:12.668694 score: 19492(19494 - 2) : pass

pprofなし

13:29:37.885553 score: 17190(17192 - 2) : pass
bellwood4486 commented 3 years ago

journaldがhtopでCPU上位に来ていたいのでログ出力を減らす。(#13 )

pprofなし

13:50:59.222059 score: 18123(18126 - 3) : pass
bellwood4486 commented 3 years ago

存在確認のために全数countしていたのをLIMIT 1にした。(#14 ) + pprof

14:04:32.551777 score: 20272(20274 - 2) : pass
bellwood4486 commented 3 years ago

最新1つしかいらないところ、全数とってたいのでLIMIT 1を付けた。(#15 ) + pprof

14:25:37.762518 score: 25888(25890 - 2) : pass