isucon5 予選をどう惨敗したか / isucon5 qualifier

2015/10/06(火) 19:00
ISUCON5予選報告会 in GCPUG Tokyo
http://eventdots.jp/event/569858

Transcript

1. isucon5 ༧બΛͲ͏ࢂഊ͔ͨ͠ takady https://flic.kr/p/5mHpwt
2. ࣗݾ঺հ • ߴా༞Ұ • Sansan גࣜձࣾ (2015/05~) • αʔόαΠυΤϯδχΞ (ruby) • twitter: takady7 • github: takady https://flic.kr/p/5mHpwt
3. isucon 5 ༧બʂ https://flic.kr/p/5mHpwt
4. νʔϜϝϯόʔ https://flic.kr/p/5mHpwt • @tatsuyaoiw • @muratayusuke
5. ౰೔ͷே https://flic.kr/p/x1Zg9g
6. https://flic.kr/p/x1Zg9g
7. ϙʔλϧαΠτʹϩάΠϯ https://flic.kr/p/x1Zg9g
8. https://flic.kr/p/x1Zg9g
9. ʮNode.js ͷ࣮૷͸ͳ͘ͳΓ·ͨ͠ɻʯ https://flic.kr/p/x1Zg9g
10. https://flic.kr/p/x1Zg9g
11. (΢ν͸ ruby ͳͷͰηʔϑ) https://flic.kr/p/x1Zg9g
12. ։͕࢝1࣌ؒ஗Εͨ͜ͱͰ • ू·͔ͬͯΒ1࣌ؒͷ༨༟Λ࣋ͯͨ • ࠷ॳͷ࡞ۀɺ୭͕Կ΍Δ͔Λ֬ೝͨ͠ • git init • dstat • kataribe • slow-query • stackprof https://flic.kr/p/x1Zg9g
13. 11:00 ༧બ։࢝ https://flic.kr/p/kwpHnK
14. https://flic.kr/p/kwpHnK
15. /etc/my.cnf ͕ಡΈࠐΊͳ͍ • slow-query log ͕ઃఆͰ͖ͳ͍ • /etc/mysql/conf.d/my.cnf Λ࡞੒ͯ͠ઃఆͨ͠ https://flic.kr/p/kwpHnK
16. /etc/my.cnf ͕ಡΈࠐΊͳ͍ • ݪҼ͸ AppArmor Ͱͨ͠ https://flic.kr/p/kwpHnK
17. ࠷ॳͷϕϯνϚʔΫΛճͯ͠ • ॳظείΞ: ໿200఺ • slow query ݟͯ index Λషͬͨ • nginx - unicorn ͷ unix ιέοτ઀ଓ • nginx Ͱͷ੩తίϯςϯπͷ഑৴ • unicorn ͷ worker਺ 1 -> 8 ʹ૿΍ͨ͠ https://flic.kr/p/kwpHnK
18. 200 -> 2000 (4Ґ) https://flic.kr/p/kwpHnK
19. redis Խ https://flic.kr/p/edctkJ
20. mysql ͔Β redis ΁ • footprints (଍͋ͱ) ςʔϒϧͷσʔλ • key = “#{ΧϨϯτϢʔβ}:#{๚໰Ϣʔβ}” • value = ๚໰࣌ؒ https://flic.kr/p/edctkJ
21. 2000 -> 7000 (3Ґ) https://flic.kr/p/edctkJ
22. ܾউߦ͚Δʁʂ https://flic.kr/p/edctkJ
23. ࡉ͔͍मਖ਼Ͱ఺ΛՔ͙ https://flic.kr/p/7Guxgu
24. ࡉ͔͍मਖ਼Ͱ఺ΛՔ͙ • entries_of_friends ͷΫΤϦΛ मਖ਼ • ͦͷଞ΋Ζ΋Ζ https://flic.kr/p/7Guxgu
25. 7000 -> 10000 (10Ґ͘Β͍) https://flic.kr/p/7Guxgu
26. ࠶ىಈςετ https://flic.kr/p/7Guxgu
27. Πϯελϯεͷ࠶ىಈ • ࠶ىಈͯ͠΋ਖ਼͘͠ΞϓϦέʔγϣϯ͕ىಈͯ͠ɺ ϕϯνϚʔΫΛࡹ͚Δ͜ͱΛ֬ೝ͢ΔͨΊ • web app ͸ systemd Ͱىಈ https://flic.kr/p/7Guxgu
28. 10000 -> 8700 (ݍ֎) https://flic.kr/p/7Guxgu
29. ͳͥείΞ͕Լ͕ͬͨͷ͔ • ͓ͦΒ͘Ωϟογϡ͕ΫϦΞ͞Εͨ͜ͱͰɺ ৐ͬͯͨσʔλ͕Ϧηοτ͞Εͨ • ΩϟογϡΛԹΊΔͨΊͷεΫϦϓτΛ૊Ί ͹Α͔͔ͬͨ΋͠Εͳ͍ https://flic.kr/p/7Guxgu
30. ࡉ͔͍मਖ਼Ͱ఺ΛՔ͙ ʢएׯർΕ͖ͯͯͨʣ https://flic.kr/p/7Guxgu
31. ࡉ͔͍मਖ਼Ͱ఺ΛՔ͙ • app - mysql ͷ unix ιέοτ઀ଓ • session store Λ Redis ʹม͑Δ https://flic.kr/p/7Guxgu
32. 8700 -> 9700 (ݍ֎) https://flic.kr/p/7Guxgu
33. ٯసΛૂ͏ https://flic.kr/p/bhXKeg
34. ࢒Γ1࣌ؒ • 10ҐҎ಺ʹೖͬͯͳ͔ͬͨ • εΩʔϚมߋʹ͸खΛग़ͯ͠ͳ͔ͬͨ • join Λͳͨ͘͢Ίͷඇਖ਼نԽ • comments ςʔϒϧʹ entry_user_id Λ௥Ճ • ࢒Γ30෼ҐͰ࣮૷׬ྃͯ͠ϕϯνϚʔΫΛ·Θͨ͠ https://flic.kr/p/bhXKeg
35. 9700 -> 250 https://flic.kr/p/bhXKeg
36. খֶੜΈ͍ͨͳείΞʹ https://flic.kr/p/bhXKeg
37. ͳͥείΞ͕Լ͕ͬͨͷ͔ • ϕϯνϚʔΧʔ͸ fail ͯ͠ͳ͔ͬͨ • ௥Ճͨ͠ΧϥϜʹॳظσʔλΛೖΕͯ͋͛Δ ඞཁ͕͋ͬͨ • ࢒Γ࣌ؒ͋ͱ10෼͘Β͍ͩͬͨͷͰ revert https://flic.kr/p/bhXKeg
38. ·ͱΊ • ָ͔ͬͨ͠ʂ • ΧʔωϧɺωοτϫʔΫɺDB౳ ษڧʹͳͬͨ • GCE ॳΊ͚ͯͩͬͨͲɺ࢖͍΍͔ͬͨ͢ • ෳ਺ਓ͕ಉ͡αʔόͰίʔυमਖ਼͢Δͷμϝ • དྷ೥͋Ε͹ ·ͨνϟϨϯδ͍ͨ͠ https://flic.kr/p/5mHpwt