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

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

Sponsored · SiteGround - Reliable hosting with speed, security, and support you can count on. →
Avatar for yudppp yudppp
November 06, 2019
Technology
1
320

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

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

Avatar for yudppp

yudppp

November 06, 2019
Tweet

More Decks by yudppp

See All by yudppp
型安全なDrag and Dropの設計を考える
Avatar for yudppp yudppp
5
950
未知のプログラミング言語にChatGPTと共に挑む
Avatar for yudppp yudppp
0
490
SaaSフロントエンド開発の現場で求められる技術 / Technologies for SaaS Frontend Development in the Field
Avatar for yudppp yudppp
2
250
2019年 HRBrainの技術的挑戦 / hrbain technology challenge 2019
Avatar for yudppp yudppp
3
1.4k
Web開発を支えるマイグレーションツールについて / sqldef introduction for psql users
Avatar for yudppp yudppp
2
3.6k
Row Level Securityはマルチテナントの銀の弾丸になりうるのか / Row Level Security is silver bullet for multitenancy?
Avatar for yudppp yudppp
23
33k
Webサービス開発に必要な統計学入門 / study of statistics for web developers
Avatar for yudppp yudppp
1
340
メジャーな Live Reloaderの違いをちゃんと調べて見た / Compare major live reloader of Go
Avatar for yudppp yudppp
1
1.9k
今年お世話になったnpm module
Avatar for yudppp yudppp
1
950

Other Decks in Technology

See All in Technology
8万デプロイ
Avatar for iwamot iwamot
PRO
2
200
GitLab Duo Agent Platform + Local LLMサービングで幸せになりたい
Avatar for jyoshise jyoshise
0
200
類似画像検索モデルの開発ノウハウ
Avatar for LINEヤフーTech (LY Corporation Tech) lycorptech_jp
PRO
4
1k
わたしがセキュアにAWSを使えるわけないじゃん、ムリムリ！(※ムリじゃなかった!?)
Avatar for cm-usuda-keisuke cmusudakeisuke
1
450
[JAWSDAYS2026]Who is responsible for IAM
Avatar for Mizuki TSUJI mizukibbb
0
190
IBM Bobを使って、PostgreSQLのToDoアプリをDb2へ変換してみよう/202603_Dojo_Bob
Avatar for Mayumi Hirano mayumihirano
1
280
クラウド × シリコンの Mashup - AWS チップ開発で広がる AI 基盤の選択肢
Avatar for Hiroshi Tokoyo htokoyo
2
120
AIファーストを前提とした開発スタイルの変化
Avatar for SoftBank Tech Night sbtechnight
0
220
「Blue Team Labs Online」入門 - みんなで挑むログ解析バトル
Avatar for Noriaki Hayashi v_avenger
0
130
Datadog の RBAC のすべて
Avatar for 株式会社ヌーラボ nulabinc
PRO
3
360
ナレッジワークのご紹介（第88回情報処理学会 ）
Avatar for KNOWLEDGE WORK / 株式会社ナレッジワーク kworkdev
PRO
0
140
バクラクのSREにおけるAgentic AIへの挑戦/Our Journey with Agentic AI
Avatar for SadayoshiTada taddy_919
2
1.1k

Featured

See All Featured
Building Flexible Design Systems
Avatar for Yesenia Perez-Cruz yeseniaperezcruz
330
40k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
Avatar for Eileen M. Uchitelle eileencodes
38
2.8k
Practical Tips for Bootstrapping Information Extraction Pipelines
Avatar for Matthew Honnibal honnibal
25
1.8k
svc-hook: hooking system calls on ARM64 by binary rewriting
Avatar for Akira Moroo retrage
2
150
AI Search:
Where Are We & What Can We Do About It?
Avatar for Aleyda Solis aleyda
0
7.1k
Building a A Zero-Code AI SEO Workflow
Avatar for Ian Lurie portentint
PRO
0
370
How to Get Subject Matter Experts Bought In and Actively Contributing to SEO & PR Initiatives.
Avatar for Liv Day livdayseo
0
81
Dominate Local Search Results - an insider guide to GBP, reviews, and Local SEO
Avatar for Greg Gifford greggifford
PRO
0
96
ラッコキーワード サービス紹介資料
Avatar for ラッコ株式会社 rakko
1
2.6M
Taking LLMs out of the black box: A practical guide to human-in-the-loop distillation
Avatar for Ines Montani inesmontani
PRO
3
2.1k
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
Avatar for Michelle Schulp Hunt marktimemedia
31
2.7k
The Pragmatic Product Professional
Avatar for Laura Van Doore lauravandoore
37
7.2k

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. ·ͱΊ • དྷ೥ͦ͜͸݁Ռग़͍ͨ͠ɻ