Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

AWS Auroraのスロークエリを Datadogで扱うまで / How to handle...

Sponsored · SiteGround - Reliable hosting with speed, security, and support you can count on. →
Avatar for mnuma mnuma
February 03, 2021
Technology
1k
0

AWS Auroraのスロークエリを Datadogで扱うまで / How to handle slow_queries_logs in AWS Aurora with Datadog

Avatar for mnuma

mnuma

February 03, 2021

More Decks by mnuma

See All by mnuma
セキュリティチェックシートの話 / Security Check Sheet
Avatar for mnuma mnuma
0
45
Datadogで始めるユーザー行動分析 / Getting Started with User Behavior Analysis Using Datadog
Avatar for mnuma mnuma
0
110
自動テストについて / Automated Testing
Avatar for mnuma mnuma
0
260
Kubernetesの自動アップグレードについて / Upgrading GKE cluster
Avatar for mnuma mnuma
0
230
Googleに学ぶDesign Docs / Learn from Google on Design Docs
Avatar for mnuma mnuma
0
190
Observabilityを実践する / Pragmatic observability
Avatar for mnuma mnuma
2
250
Kubernetes Case Studies #1@Makuake KubeCon NA 2019 Recap
Avatar for mnuma mnuma
0
180
カオスエンジニアリングについてヤホーで調べてきました / Enter the chaos engineering
Avatar for mnuma mnuma
0
140
Chaos Engineering 現状把握 / History Of Chaos Engineering
Avatar for mnuma mnuma
0
400

Other Decks in Technology

See All in Technology
AIネイティブプロダクトで顧客価値を最大化するプロダクトエンジニアとFDEの協働
Avatar for RightTouch righttouch
PRO
0
230
深夜のクラウド懺悔室 1:29:300 or 1:0:0
Avatar for kazzpapa3 kazzpapa3
1
230
ASTを使って影響範囲を特定する
Avatar for Nealle nealle
0
140
[2026-09-11]SREは誰のもの？運用エンジニアが始める 「SRE領域への越境」とチームの進化の軌跡 〜Road to NEXT CRE
Avatar for tosite tosite
0
120
GoにおけるFFIのこれまでとこれから
Avatar for Masaaki Goshima goccy
5
2.3k
Podは生きているのにGoだけが落ちる：GOGCとGOMEMLIMITで追うInvisible OOM Killの謎
Avatar for Watanabe Takeshi(Buzz) tkc66buzz
1
500
KPIだけでは評価できないプロダクトが考えるべき Evalsという第二の評価系 / Beyond KPIs: Evals as a Second Evaluation Framework for Products #PdEConf
Avatar for Aki / @LoveIdahoBurger aki_iinuma
4
3.9k
ペアプロの価値はコードを書くことだけじゃない
Avatar for コドモン開発チーム codmoninc
PRO
0
160
Sigmaで作る業務アプリ
Avatar for kazushiro_honma kazushiro_honma
0
110
Multica × 長期記憶：40個のミニプロジェクト管理
Avatar for eiei114 eiei114
1
240
WAF 運用改善の承認サイクル/SRE_BizReach_MIXI_1
Avatar for Visional Engineering ＆ Design visional_engineering_and_design
2
420
スクラムで身についていた動き方を、XPで捉え直してみた
Avatar for コドモン開発チーム codmoninc
PRO
1
350

Featured

See All Featured
Color Theory Basics | Prateek | Gurzu
Avatar for Gurzu gurzu
0
460
Learning to Love Humans: Emotional Interface Design
Avatar for Aarron Walter aarron
275
41k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
Avatar for Eileen M. Uchitelle eileencodes
38
3k
Documentation Writing (for coders)
Avatar for Carmen Chung carmenintech
77
5.5k
Between Models and Reality
Avatar for mayunak mayunak
4
450
Making Projects Easy
Avatar for Brett Harned brettharned
120
6.7k
The Language of Interfaces
Avatar for Des Traynor destraynor
162
27k
<Decoding/> the Language of Devs - We Love SEO 2024
Avatar for Nikki Halliwell nikkihalliwell
1
320
How to Build an AI Search Optimization Roadmap - Criteria and Steps to Take #SEOIRL
Avatar for Aleyda Solis aleyda
1
2.2k
Crafting Experiences
Avatar for Bethany Jepchumba bethany
1
310
The Art of Delivering Value - GDevCon NA Keynote
Avatar for David Neal reverentgeek
16
2.2k
Ecommerce SEO: The Keys for Success Now & Beyond - #SERPConf2024
Avatar for Aleyda Solis aleyda
1
2.1k

Transcript

  1. "84"VSPSBͷεϩʔΫΤϦΛ %BUBEPHͰѻ͏·Ͱ .BLVBLF-51BSUZ

  2. !NOVNB@ 5FBN43& %JTOFZ ʹೖΓ·ͨ͠ "OLFS/FCVMB$PTNPT."9ങͬͯΑ͔ͬͨ

  3. ੈͷதʹ͸ͭͷϩά͕͋Γ·͢

  4. ඇߏ଄Խϩά 6OTUSVDUVSFE-PHT ߏ଄Խϩά 4USVDUVSFE-PHT

  5. ඇߏ଄Խϩά 6OTUSVDUVSFE-PHT DPNCJOFEMPHGPSNBU <%FD >(&5)551.P[JMMB 9-JOVYY@  "QQMF8FC,JU ,)5.- MJLF(FDLP

    $ISPNF4BGBSJ

  6. Ұൠతʹ͸KTPO ࣄલఆٛ͞ΕͨϝοηʔδϑΥʔϚοτ ςΩετͰ͸ͳ͘σʔληοτ ϩάͷॲཧ͕؆୯ʹͳΓϩάͷ෼ੳ͕ḿΔ ѻ͍΍͍͢ ߏ଄Խϩά 4USVDUVSFE-PHT KTPO1BZMPBE\ lpSTU@OBNF+PIO 

    lMBTU@OBNFl4NJUIz  BHF  NFTTBHFl)J ^

  7. ɾ&SSPSMPH ɾ(FOFSBMRVFSZMPH ɾ4MPXRVFSZMPH ɾ"VEJUMPH "NB[PO"VSPSBͷϩά͸ $MPVE8BUDIʹΤΫεϙʔτՄೳ

  8. IUUQTEPDTEBUBEPHIRDPNKBTFSWFSMFTTGPSXBSEFS $MPVE8BUDI-PHT͔Β%BUBEPH΁ͷసૹ %BUBEPH੡ͷϑΥϫʔμʔ͕ఏڙ͞Εͯ·͢ɻ

  9. εϩʔΫΤϦϩά 4MPXRVFSZMPH 

  10. None

  11.  ϩάग़ྗ೔࣌  Ϣʔβʔɺ઀ଓαʔό  2VFSZ@UJNFΫΤϦ࣮ߦ࣌ؒ -PDL@UJNFϩοΫ࣌ؒ 3PXT@TFOUग़ྗߦ਺ 3PXT@FYBNJOFEॲཧର৅ߦ਺ 

    42-จ

  12. εϩʔΫΤϦϩά ඇߏ଄Խϩά  Λ%BUBEPHͰѻ͍͍ͨ

  13. ɾඇߏ଄Խϩά ɾෳ਺ߦ ɾσϦϛλ͕ڰؾཚ෣൒֯εϖʔε!

  14. l*HSPLJOGVMMOFTTz3PCFSU")FJOMFJO 4USBOHFSJOB4USBOHF-BOE (SPL

  15. (SPL ਖ਼نදݱηοτ ओʹϩάσʔλ޲͚ͷநग़ϑΟϧλɻ ඇߏ଄σʔλΛਖ਼نදݱʹΑͬͯߏ଄σʔλʹม׵ग़དྷΔɻ

  16. https://github.com/logstash-plugins/logstash-patterns-core/blob/master/patterns/grok-patterns

  17. (SPL Datadog LogsͰ͸ϩάऩू࣌ʹGrokΛϑΟϧλ͢Δ͜ͱ͕ग़དྷ·͢ɻ

  18. ߏจ SVMF@OBNF\NBUDIFSpFMEpMUFS লུՄ ^ʜ ྫ VTFSPSEFSTUBUVTDPNQMFUF (SPLύʔαʔ IPHF@QBSTFS\EBUF ZZZZ..EE))NNTT444 UJNFTUBNQ^VTFS\OVNCFSVTFSJE^PSEFS

    \EBUBPSEFSLFZWBMVF^

  19. ߏจ SVMF@OBNF\NBUDIFSpFMEpMUFS লུՄ ^ʜ ྫ VTFSPSEFSTUBUVTDPNQMFUF (SPLύʔαʔ IPHF@QBSTFS\EBUF ZZZZ..EE))NNTT444 UJNFTUBNQ^VTFS\OVNCFSVTFSJE^PSEFS

    \EBUBPSEFSLFZWBMVF^
  20. None

  21. ύλʔϯ 5JNF 6TFS!)PTUVTFS<VTFS>!<>*E 2VFSZ@UJNF-PDL@UJNF3PXT@TFOU3PXT@FYBNJOFE 4&5UJNFTUBNQ  6TFSOBNF4DIFEVMFE 5BTL*%YYY 2VFSZ*% 2VFVFTDIFEVMFE@RVFSJFT

     2VFSZ)BTIYYY 4&-&$5 '30.VTFST ύλʔϯ 6TFS!)PTUVTFS<VTFS>!<>*E 2VFSZ@UJNF-PDL@UJNF3PXT@TFOU3PXT@FYBNJOFE 4&5UJNFTUBNQ 4&-&$5 '30.VTFST ύλʔϯ 5JNF 6TFS!)PTUVTFS<VTFS>!<>*E 2VFSZ@UJNF-PDL@UJNF3PXT@TFOU3PXT@FYBNJOFE VTFUBCMF 4&5UJNFTUBNQ  6TFSOBNF4DIFEVMFE 5BTL*%YYY 2VFSZ*%  2VFVFTDIFEVMFE@RVFSJFT 2VFSZ)BTIYYY 4&-&$5 '30.VTFST ύλʔϯ 5JNF 6TFS!)PTUVTFS<VTFS>!<>*E 2VFSZ@UJNF-PDL@UJNF3PXT@TFOU3PXT@FYBNJOFE 4&5UJNFTUBNQ  6TFSOBNF4DIFEVMFE 5BTL*%YYY 2VFSZ*%  2VFVFTDIFEVMFE@RVFSJFT 2VFSZ)BTIYYY 4&-&$5 '30.VTFST ѥछ

  22. ύλʔϯ 5JNF 6TFS!)PTUVTFS<VTFS>!<>*E 2VFSZ@UJNF-PDL@UJNF3PXT@TFOU3PXT@FYBNJOFE 4&5UJNFTUBNQ  6TFSOBNF4DIFEVMFE 5BTL*%YYY 2VFSZ*% 2VFVFTDIFEVMFE@RVFSJFT

     2VFSZ)BTIYYY 4&-&$5 '30.VTFST ύλʔϯ 5JNF͕ͳ͍ 6TFS!)PTUVTFS<VTFS>!<>*E 2VFSZ@UJNF-PDL@UJNF3PXT@TFOU3PXT@FYBNJOFE 4&5UJNFTUBNQ 4&-&$5 '30.VTFST ύλʔϯ 5JNF 6TFS!)PTUVTFS<VTFS>!<>*E 2VFSZ@UJNF-PDL@UJNF3PXT@TFOU3PXT@FYBNJOFE VTFUBCMFVTF͕͋Δ 4&5UJNFTUBNQ  6TFSOBNF4DIFEVMFE 5BTL*%YYY 2VFSZ*%  2VFVFTDIFEVMFE@RVFSJFT 2VFSZ)BTIYYY 4&-&$5 '30.VTFST ύλʔϯ 5JNF೔෇ϑΥʔϚοτ͕ҧͬͨ 6TFS!)PTUVTFS<VTFS>!<>*E 2VFSZ@UJNF-PDL@UJNF3PXT@TFOU3PXT@FYBNJOFE 4&5UJNFTUBNQ  6TFSOBNF4DIFEVMFE 5BTL*%YYY 2VFSZ*%  2VFVFTDIFEVMFE@RVFSJFT 2VFSZ)BTIYYY 4&-&$5 '30.VTFST ѥछ

  23. ύλʔϯ 5JNF 6TFS!)PTUVTFS<VTFS>!<>*E 2VFSZ@UJNF-PDL@UJNF3PXT@TFOU3PXT@FYBNJOFE 4&5UJNFTUBNQ  6TFSOBNF4DIFEVMFE 5BTL*%YYY 2VFSZ*% 2VFVFTDIFEVMFE@RVFSJFT

     2VFSZ)BTIYYY 4&-&$5 '30.VTFST ύλʔϯ 5JNF͕ͳ͍ 6TFS!)PTUVTFS<VTFS>!<>*E 2VFSZ@UJNF-PDL@UJNF3PXT@TFOU3PXT@FYBNJOFE 4&5UJNFTUBNQ 4&-&$5 '30.VTFST ύλʔϯ 5JNF 6TFS!)PTUVTFS<VTFS>!<>*E 2VFSZ@UJNF-PDL@UJNF3PXT@TFOU3PXT@FYBNJOFE VTFUBCMFVTF͕͋Δ 4&5UJNFTUBNQ  6TFSOBNF4DIFEVMFE 5BTL*%YYY 2VFSZ*%  2VFVFTDIFEVMFE@RVFSJFT 2VFSZ)BTIYYY 4&-&$5 '30.VTFST ύλʔϯ 5JNF೔෇ϑΥʔϚοτ͕ҧͬͨ 6TFS!)PTUVTFS<VTFS>!<>*E 2VFSZ@UJNF-PDL@UJNF3PXT@TFOU3PXT@FYBNJOFE 4&5UJNFTUBNQ  6TFSOBNF4DIFEVMFE 5BTL*%YYY 2VFSZ*%  2VFVFTDIFEVMFE@RVFSJFT 2VFSZ)BTIYYY 4&-&$5 '30.VTFST ѥछ

  24. ɾ"VSPSBͷϩάΛ%BUBEPHͰѻͬͯΔՕॴͷղઆ ɾॏΊͷ42-Λҙࣝग़དྷΔ࢓૊Έͱ͔͋Δͱྑ͍͔΋