Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
ISUCON向けのツールを作った話 / isutools
Search
yudppp
November 06, 2019
Technology
1
280
ISUCON向けのツールを作った話 / isutools
ISUCON向けのツールを作った話
ISUCON9大反省会LT
https://github.com/yudppp/isutools
yudppp
November 06, 2019
Tweet
Share
More Decks by yudppp
See All by yudppp
型安全なDrag and Dropの設計を考える
yudppp
5
840
未知のプログラミング言語にChatGPTと共に挑む
yudppp
0
450
SaaSフロントエンド開発の現場で求められる技術 / Technologies for SaaS Frontend Development in the Field
yudppp
2
210
2019年 HRBrainの技術的挑戦 / hrbain technology challenge 2019
yudppp
3
1.4k
Web開発を支えるマイグレーションツールについて / sqldef introduction for psql users
yudppp
2
3.4k
Row Level Securityはマルチテナントの銀の弾丸になりうるのか / Row Level Security is silver bullet for multitenancy?
yudppp
23
31k
Webサービス開発に必要な統計学入門 / study of statistics for web developers
yudppp
1
300
メジャーな Live Reloaderの違いをちゃんと調べて見た / Compare major live reloader of Go
yudppp
1
1.9k
今年お世話になったnpm module
yudppp
1
930
Other Decks in Technology
See All in Technology
自作LLM Native GORM Pluginで実現する AI Agentバックテスト基盤構築
po3rin
2
230
From Prompt to Product @ How to Web 2025, Bucharest, Romania
janwerner
0
110
Oracle Base Database Service 技術詳細
oracle4engineer
PRO
11
77k
10年の共創が示す、これからの開発者と企業の関係 ~ Crossroad
soracom
PRO
1
130
o11yで育てる、強い内製開発組織
_awache
3
100
PythonとLLMで挑む、 4コマ漫画の構造化データ化
esuji5
1
120
Trust as Infrastructure
bcantrill
0
280
BirdCLEF+2025 Noir 5位解法紹介
myso
0
180
多野優介
tanoyusuke
1
170
What is BigQuery?
aizack_harks
0
120
PLaMo2シリーズのvLLM実装 / PFN LLM セミナー
pfn
PRO
2
910
空間を設計する力を考える / 20251004 Naoki Takahashi
shift_evolve
PRO
3
250
Featured
See All Featured
Statistics for Hackers
jakevdp
799
220k
Documentation Writing (for coders)
carmenintech
75
5k
XXLCSS - How to scale CSS and keep your sanity
sugarenia
248
1.3M
Connecting the Dots Between Site Speed, User Experience & Your Business [WebExpo 2025]
tammyeverts
9
570
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
mongodb
48
9.7k
Measuring & Analyzing Core Web Vitals
bluesmoon
9
610
The Power of CSS Pseudo Elements
geoffreycrofte
79
6k
Embracing the Ebb and Flow
colly
88
4.8k
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
panda_program
114
20k
VelocityConf: Rendering Performance Case Studies
addyosmani
332
24k
How STYLIGHT went responsive
nonsquared
100
5.8k
The MySQL Ecosystem @ GitHub 2015
samlambert
251
13k
Transcript
ISUCON͚ͷπʔϧΛ࡞ͬͨ ISUCON9େলձ
pprofͷ݁ՌΛ؆୯ʹՄࢹԽ • pprofͷίϚϯυΕ͕ͪ • Port։͚ͨΓFileΛscpͨ͠Γେม • ϕϯνϚʔΫճͨ͠͝ͱʹऔΓ͍ͨ
DataDogͷSQLͷAPMΛऔΓ͍ͨ • DatadogͷAPM࠷ߴɻ͓͔͔ͨͩۚ͠Δɻ • SlowLog͚ͩͩͱΈΕͳ͍ΛΈ͍ͨɻ
alpͷ݁ՌΛ؆୯ʹग़͍ͨ͠ • ϕϯνϚʔΫճͨ͠͝ͱʹऔΓ͍ͨ
N+1 QueryΛ؆୯ʹൃݟ͍ͨ͠ • ࢹͰN+1 QueryΛݟ͚ͭͯͨ͠Γ͢Δ͕ ࿙Ε͕͋ͬͨΓ͢ΔͷͰ؆୯ʹൃݟ͍ͨ͠
Γ͍ͨ͜ͱ·ͱΊ • pprofͷ݁ՌΛ؆୯ʹՄࢹԽ͍ͨ͠ • alpΈ͍ͨͳ݁ՌΛ؆୯ʹग़ྗ͍ͨ͠ • DataDogͷSQLͷAPMͷ݁ՌΈ͍ͨͳͷग़ྗ ͍ͨ͠ • N+1QueryΛ؆୯ʹൃݟ͍ͨ͠
͜ΕΒΛղܾ͢Δ࡞Γ·ͨ͠ɻ
ͦͷ໊
github.com/yudppp/isutools Iikanji ni speed up suru tools
github.com/yudppp/isutools/profile • Initialize͢Δؔͷதʹ1ߦՃ͢Δ • InitializeͷؔΛݺͼग़͔ͯ͠Βࢦఆͨ͠ඵ ͷpprofͷ݁ՌΛSlackʹૹ৴͢Δ
github.com/yudppp/isutools/profile • ϕϯνϚʔΫͷ࣮ߦ͝ͱʹຖճܭଌ݁ՌΛ Slackʹ͛ͯ͘ΕΔ • ϩάͱͯ͠͞ΕΔͷͰ࣌ܥྻͰऴ͑ͯศར
None
github.com/yudppp/isutools/tracereporter • DataDogͷAPMͷlibrary(dd-trace-go)Λͬ ͯ৭ʑͳ༰ΛSlackʹϨϙʔτ͢Δ • LibraryʹରԠ͍ͯ͠ΔϑϨʔϜϫʔΫશͯʹ ରԠ͞Ε͍ͯΔ
sqlxͷྫ
None
gojiͷྫ
None
github.com/yudppp/isutools/tracereporter • ্هͷΈ͍ͨͳͭΛ্ख͍͘߹ΘͤΔͱ
None
github.com/yudppp/isutools/utils/throttle • ࢦఆͨ͠ඵؒʹ࠷ॳͷ1ճ͔࣮͠ߦ͞Εͳ ͍ͭ(sync.Onceͱಉ͡ײ͡Ͱ͑Δ)
·ͱΊ • དྷͦ݁͜Ռग़͍ͨ͠ɻ