ISUCON向けのツールを作った話 / isutools

ISUCON向けのツールを作った話
ISUCON9大反省会LT
https://github.com/yudppp/isutools

Transcript

1. ISUCON޲͚ͷπʔϧΛ࡞ͬͨ࿩
   ISUCON9େ൓লձ
   

   View Slide

2. pprofͷ݁ՌΛ؆୯ʹՄࢹԽ
   • pprofͷίϚϯυ๨Ε͕ͪ
   • Port։͚ͨΓFileΛscpͨ͠Γେม
   • ϕϯνϚʔΫճͨ͠͝ͱʹऔΓ͍ͨ
   

   View Slide

3. DataDogͷSQLͷAPMΛऔΓ͍ͨ
   • DatadogͷAPM͸࠷ߴɻ͓͔͔ͨͩۚ͠Δɻ
   • SlowLog͚ͩͩͱΈΕͳ͍܏޲ΛΈ͍ͨɻ
   

   View Slide

4. alpͷ݁ՌΛ؆୯ʹग़͍ͨ͠
   • ϕϯνϚʔΫճͨ͠͝ͱʹऔΓ͍ͨ
   

   View Slide

5. N+1 QueryΛ؆୯ʹൃݟ͍ͨ͠
   • ໨ࢹͰN+1 QueryΛݟ͚ͭͯ௚ͨ͠Γ͢Δ͕
   ࿙Ε͕͋ͬͨΓ͢ΔͷͰ؆୯ʹൃݟ͍ͨ͠
   

   View Slide

6. ΍Γ͍ͨ͜ͱ·ͱΊ
   • pprofͷ݁ՌΛ؆୯ʹՄࢹԽ͍ͨ͠
   • alpΈ͍ͨͳ݁ՌΛ؆୯ʹग़ྗ͍ͨ͠
   • DataDogͷSQLͷAPMͷ݁ՌΈ͍ͨͳͷग़ྗ
   ͍ͨ͠
   • N+1QueryΛ؆୯ʹൃݟ͍ͨ͠
   

   View Slide

7. ͜ΕΒΛղܾ͢Δ࡞Γ·ͨ͠ɻ
   

   View Slide

8. ͦͷ໊΋
   

   View Slide

9. github.com/yudppp/isutools
   Iikanji ni speed up suru tools
   

   View Slide

10. github.com/yudppp/isutools/profile
    • Initialize͢Δؔ਺ͷதʹ1ߦ௥Ճ͢Δ
    • Initializeͷؔ਺Λݺͼग़͔ͯ͠Βࢦఆͨ͠ඵ਺
    ͷpprofͷ݁ՌΛSlackʹૹ৴͢Δ
    

    View Slide

11. github.com/yudppp/isutools/profile
    • ϕϯνϚʔΫͷ࣮ߦ͝ͱʹຖճܭଌ݁ՌΛ
    Slackʹ౤͛ͯ͘ΕΔ
    • ϩάͱͯ͠࢒͞ΕΔͷͰ࣌ܥྻͰऴ͑ͯศར
    

    View Slide

12. View Slide

13. github.com/yudppp/isutools/tracereporter
    • DataDogͷAPMͷlibrary(dd-trace-go)Λ࢖ͬ
    ͯ৭ʑͳ಺༰ΛSlackʹϨϙʔτ͢Δ
    • LibraryʹରԠ͍ͯ͠ΔϑϨʔϜϫʔΫશͯʹ
    ରԠ͞Ε͍ͯΔ
    

    View Slide

14. sqlxͷྫ
    

    View Slide

15. View Slide

16. gojiͷྫ
    

    View Slide

17. View Slide

18. github.com/yudppp/isutools/tracereporter
    • ্هͷΈ͍ͨͳ΍ͭΛ্ख͘࢖͍߹ΘͤΔͱ
    

    View Slide

19. View Slide

20. github.com/yudppp/isutools/utils/throttle
    • ࢦఆͨ͠ඵ਺ؒʹ࠷ॳͷ1ճ໨͔࣮͠ߦ͞Εͳ
    ͍΍ͭ(sync.Onceͱಉ͡ײ͡Ͱ࢖͑Δ)
    

    View Slide

21. ·ͱΊ
    • དྷ೥ͦ͜͸݁Ռग़͍ͨ͠ɻ
    

    View Slide