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

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

Avatar for mnuma mnuma
February 03, 2021
Technology
1.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
49
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
200
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
コンテナ運用におけるネットワーク・コンテナコストの削減方法／How to Reduce Network and Container Costs in Container Operations
Avatar for モブエンジニア masakiokuda
2
390
Refining Active Record
Avatar for Shugo Maeda shugo
0
190
freeeにおけるSoftware Factory
Avatar for freee freee
PRO
0
320
シンプルな設定ファイルで実現する AWS IAM Identity Center の ユーザー管理Terraformフレームワークを公開しました / Simplifying AWS IAM Identity Center User Management: An Open-Source Terraform Framework
Avatar for Takashi Yamaguchi yamaguchitk333
0
220
Active Record Connection Adaptersにおける長年の課題に再び取り組む
Avatar for Yasuo Honda yahonda
0
420
PHPカンファレンス関西の招待状 / Invitation to PHP Conference Kansai
Avatar for Y-KANOH ykanoh
0
230
JAWSUG TOHOKU 青森支部 「LoGoチャット」のAWS移行で 乗り越えたこと
Avatar for たけだ taketakekaho
0
380
【データ横丁主催】AI エージェント時代のTranslytical Data Platform
Avatar for KoheiOgawa shisyu_gaku
0
250
日本語に強いオープンな大規模言語モデル「LLM-jp」
Avatar for Yusuke Oda odashi
5
1.2k
Microsoft のサポート ライフサイクルを理解する
Avatar for Murachi Akira murachiakira
PRO
0
120
AI導入は済んだ。次は統制を作り替える番だ_AI×開発組織 Summit 2026
Avatar for PERSOL CAREER Dev | techtekt techtekt
PRO
0
520
初海外で注意すべきこと12選！！！安全快適なre:invent生活にするために
Avatar for Yuuuuuuu yuuuuuuu168
1
200

Featured

See All Featured
No one is an island. Learnings from fostering a developers community.
Avatar for Antonio thoeni
21
3.9k
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
Avatar for mongodb mongodb
50
10k
Build your cross-platform service in a week with App Engine
Avatar for Jose L jlugia
234
19k
Money Talks: Using Revenue to Get Sh*t Done
Avatar for Nikki Halliwell nikkihalliwell
0
530
The Invisible Side of Design
Avatar for Vitaly Friedman smashingmag
301
52k
Building Adaptive Systems
Avatar for Chris Keathley keathley
44
3.3k
Skip the Path - Find Your Career Trail
Avatar for Mark Kilby mkilby
1
260
Typedesign – Prime Four
Avatar for Hannes Fritz hannesfritz
42
3.2k
Un-Boring Meetings
Avatar for Sebastian Deterding codingconduct
0
460
The B2B funnel & how to create a winning content strategy
Avatar for Katarina Dahlin katarinadahlin
PRO
1
580
Lightning Talk: Beautiful Slides for Beginners
Avatar for Ines Montani inesmontani
PRO
2
740
エンジニアに許された特別な時間の終わり
Avatar for watany watany
109
250k

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-Λҙࣝग़དྷΔ࢓૊Έͱ͔͋Δͱྑ͍͔΋