Upgrade to Pro — share decks privately, control downloads, hide ads and more …

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

D68ec2463959a924ada156a278743228?s=47 yudppp
November 06, 2019
Technology
1
130

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

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

D68ec2463959a924ada156a278743228?s=128

yudppp

November 06, 2019
Tweet

More Decks by yudppp

See All by yudppp
2019年 HRBrainの技術的挑戦 / hrbain technology challenge 2019
D68ec2463959a924ada156a278743228?s=48 yudppp
3
840
Web開発を支えるマイグレーションツールについて / sqldef introduction for psql users
D68ec2463959a924ada156a278743228?s=48 yudppp
2
1.7k
Row Level Securityはマルチテナントの銀の弾丸になりうるのか / Row Level Security is silver bullet for multitenancy?
D68ec2463959a924ada156a278743228?s=48 yudppp
18
9.8k
Webサービス開発に必要な統計学入門 / study of statistics for web developers
D68ec2463959a924ada156a278743228?s=48 yudppp
1
140
メジャーな Live Reloaderの違いをちゃんと調べて見た / Compare major live reloader of Go
D68ec2463959a924ada156a278743228?s=48 yudppp
1
1.6k
今年お世話になったnpm module
D68ec2463959a924ada156a278743228?s=48 yudppp
1
580
Goで社内向け管理画面を楽に作る方法
D68ec2463959a924ada156a278743228?s=48 yudppp
5
8.8k
カバレッジ95%以上を実現した テストコードの書き方
D68ec2463959a924ada156a278743228?s=48 yudppp
0
2.2k

Other Decks in Technology

See All in Technology
Power Query 日時の変換でちょっと焦ったケース +1 / Power Query Some cases
966e29b84ae7dbde170f66b0bc75b7a6?s=48 ishiayaya
0
140
読者のことを考えて書いてみよう / Write with your reader in mind
A3966f193f4bef226a0d3e3c1f728d7f?s=48 line_developers
PRO
3
220
Microsoft Power Automate で 始めるRPAと自動化
D9f67a8d80eda642b6075bd59537c629?s=48 taikiyoshida
0
1.7k
ISUCON で使えるツールを作った
Cb17938137021ead2656d0fe58b7c7b1?s=48 shotakitazawa
0
340
Okta Identity Engineってどうよ？
66310d2dc1c18188f722d71dfb444bad?s=48 tatsumin39
0
270
tfcon-2022-cpp
Dcc589548f0372645aaeb95bda8e22c2?s=48 cpp
5
4.1k
一人から始めるプロダクトSRE / How to start SRE in a product team, all by yourself
12a5cec7a54018170b1a009731acf477?s=48 vtryo
3
1.8k
We’re all on the path of growth 🌱
D16bc1f94b17ddc794c2dfb48ef59456?s=48 mosky
1
350
Nutanix_Meetup_20220511
0fca98ba59a23fc0a4a2a53701a2bae1?s=48 keigotomomatsu
0
130
AWS Control TowerとAWS Organizationsを活用した組織におけるセキュリティ設定
F2ccc400e285972d80feab0e4e57b5f7?s=48 fu3ak1
2
580
インフラエンジニアBooks 30分でわかる「Dockerコンテナ開発・環境構築の基本」
7bcf6f29a0b9a348fe422a31a4f44752?s=48 cyberblack28
9
5.8k
次期LTSに備えよ！AOS 6.1 HCI Core 編
A4d5b3aae2e67f31b513c88c726514c2?s=48 smzksts
0
160

Featured

See All Featured
WebSockets: Embracing the real-time Web
E76911cbe088e5b850d966de3fc7435b?s=48 robhawkes
57
4.9k
Visualization
170b760e0147792d0140e59ec78e9893?s=48 eitanlees
124
11k
Designing with Data
F57e2136eb9895eb95ff5dc8a1c02677?s=48 zakiwarfel
91
3.8k
The World Runs on Bad Software
20bfe76b3d6105641f879fe45cfc9272?s=48 bkeepers
PRO
56
5.2k
The Pragmatic Product Professional
1177e050db6bafe62885362edf6e3537?s=48 lauravandoore
19
2.8k
Building Flexible Design Systems
91cefdf141106fa10674aae74ce05890?s=48 yeseniaperezcruz
310
33k
Typedesign – Prime Four
A0517b08532aec8ab2aae3f65d40ad86?s=48 hannesfritz
33
1.3k
A designer walks into a library…
15f2b8221f247985a27a627d2ece72f0?s=48 pauljervisheath
196
16k
For a Future-Friendly Web
F68cb25ae3e5c2106997454b13b7737d?s=48 brad_frost
164
7.4k
Rebuilding a faster, lazier Slack
C0b42577cfc2b321be3474618107e933?s=48 samanthasiow
62
7.2k
Six Lessons from altMBA
766b9746b59e6f09e280cd33cf4ed419?s=48 skipperchong
14
1.3k
Dealing with People You Can't Stand - Big Design 2015
44b54d2ffcb7857004071cc6795dde11?s=48 cassininazir
350
21k

Transcript

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

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

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

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

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

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

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

  8. ͦͷ໊΋

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

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

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

  12. None

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

  14. sqlxͷྫ

  15. None

  16. gojiͷྫ

  17. None

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

  19. None

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

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