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

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

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest. →
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
120
自動テストについて / 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
AIに任せられるFlutterコードベースを作る 〜仕様をコードで表し、ハーネスで守る〜
Avatar for Yohei Maeda myohei
1
410
「社外イベント＝意識高い」の​壁を​壊せ！​元々​無関心だった​僕らが​部内で​社外イベントを​民主化して​15人を​連れ出すまで​
Avatar for せーの say_no_w
0
160
DevelopersIO 2026 Tokyo 現時点の衛星通信サービスの現状を整理してみる
Avatar for maroon1st maroon1st
0
340
Claude for Google Workspaces ポン出し/claude-for-google-workspace-slide-conversion
Avatar for emi emiki
0
13k
200人の配信コメント、 全部Jevが仕分けます 〜 マサカリガードを作ってみた 〜
Avatar for Katato katayamatg
1
440
Content Mapper APIの応用例～CSS Modules、言語ファイル～
Avatar for uhyo uhyo
2
190
Snowflake でできることが増えたら、 ABAC が必要になった
Avatar for Tatsuya Hanyu kaeton
0
120
[FECONF-2026] 신대륙을 향한 카카오페이증권 프론트엔드 항해기 (이주승)
Avatar for l1ghthouse l1ghthouse
0
280
渡米前の準備を制す！re:Invent 2026徹底準備術 / The Ultimate Preparation Guide for re:Invent 2026
Avatar for Yuji Oshima yuj1osm
1
400
ガチで放置できるClaude Code実行環境の作り方.pdf
Avatar for Lamaglama39 lamaglama39
5
10k
E2Eってつらくないですか？E2Eの管理コストを下げる手段とその実践
Avatar for Kosei Akaboshi (akaboshinit) akaboshinit
5
2.7k
Lint の層を組み直した話
Avatar for 弁護士ドットコム bengo4com
1
180

Featured

See All Featured
Navigating Weather and Climate Data
Avatar for Ryan Abernathey rabernat
0
570
Google's AI Overviews - The New Search
Avatar for Barry Adams badams
0
1.6k
Measuring Dark Social's Impact On Conversion and Attribution
Avatar for Stephen Akadiri stephenakadiri
2
310
HTML-Aware ERB: The Path to Reactive Rendering @ RubyCon 2026, Rimini, Italy
Avatar for Marco Roth marcoroth
5
860
DBのスキルで生き残る技術 - AI時代におけるテーブル設計の勘所
Avatar for soudai sone soudai
PRO
68
59k
SEO for Brand Visibility & Recognition
Avatar for Aleyda Solis aleyda
0
4.8k
VelocityConf: Rendering Performance Case Studies
Avatar for Addy Osmani addyosmani
331
25k
How to Think Like a Performance Engineer
Avatar for Harry Roberts csswizardry
28
2.9k
Building the Perfect Custom Keyboard
Avatar for Naoto Takai takai
2
930
Designing for Timeless Needs
Avatar for Cassini Nazir cassininazir
1
530
How Software Deployment tools have changed in the past 20 years
Avatar for Geshan Manandhar geshan
2
35k
The B2B funnel & how to create a winning content strategy
Avatar for Katarina Dahlin katarinadahlin
PRO
1
590

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