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

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
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
38
Datadogで始めるユーザー行動分析 / Getting Started with User Behavior Analysis Using Datadog
Avatar for mnuma mnuma
0
95
自動テストについて / Automated Testing
Avatar for mnuma mnuma
0
250
Kubernetesの自動アップグレードについて / Upgrading GKE cluster
Avatar for mnuma mnuma
0
230
Googleに学ぶDesign Docs / Learn from Google on Design Docs
Avatar for mnuma mnuma
0
180
Observabilityを実践する / Pragmatic observability
Avatar for mnuma mnuma
2
240
Kubernetes Case Studies #1@Makuake KubeCon NA 2019 Recap
Avatar for mnuma mnuma
0
180
カオスエンジニアリングについてヤホーで調べてきました / Enter the chaos engineering
Avatar for mnuma mnuma
0
130
Chaos Engineering 現状把握 / History Of Chaos Engineering
Avatar for mnuma mnuma
0
380

Other Decks in Technology

See All in Technology
Oracle AI Database@AWS：サービス概要のご紹介
Avatar for oracle4engineer oracle4engineer
PRO
4
2.8k
【５分でわかる】セーフィー エンジニア向け会社紹介
Avatar for Safie safie_recruit
0
50k
noUncheckedIndexedAccess、3時間、1万円。 / noUncheckedIndexedAccess, 3 Hours, 10,000 JPY.
Avatar for 株式会社カオナビ kaonavi
1
310
Building applications in the Gemini API family.
Avatar for LINE Developers Taiwan line_developers_tw
PRO
0
1.9k
Claude Codeを組織で使いこなす— サーバサイドAIエージェント運用の実践知
Avatar for PERSOL CAREER Dev | techtekt techtekt
PRO
0
210
新規ゲーム開発におけるAI駆動開発のリアル
Avatar for ENSAPIA Engineering株式会社 202409e2
0
2.7k
protovalidate-es を導入してみた
Avatar for 弁護士ドットコム bengo4com
0
140
個人の発見を、組織の知恵に 〜生成AI活用を"探索"から"組織の仕組み"へ〜
Avatar for KintoTech_Dev kintotechdev
2
1k
生成 AI × MCP で切り拓く次世代 SRE！自律型運用への挑戦と開発者体験の進化
Avatar for _awache _awache
0
160
Unlocking the Apps
Avatar for Tim Perry pimterry
0
250
AIプラットフォームを運用し続けるための可観測性
Avatar for tanimuyk tanimuyk
4
1.1k
実装は速くなった、レビューはどうする？ ― 自身のレビューをAIで再現させるサーヴァントエンジニアリングのすゝめ / Implementation got faster. So what about reviews? — An invitation to Servant Engineering: Recreating your own code reviews with AI
Avatar for nrs nrslib
7
4.1k

Featured

See All Featured
DBのスキルで生き残る技術 - AI時代におけるテーブル設計の勘所
Avatar for soudai sone soudai
PRO
65
55k
Digital Projects Gone Horribly Wrong (And the UX Pros Who Still Save the Day) - Dean Schuster
Avatar for UX Y'all uxyall
0
1.6k
SEO for Brand Visibility & Recognition
Avatar for Aleyda Solis aleyda
0
4.6k
Jess Joyce - The Pitfalls of Following Frameworks
Avatar for Tech SEO Connect techseoconnect
PRO
1
160
From Legacy to Launchpad: Building Startup-Ready Communities
Avatar for Dug Song dugsong
0
220
The Mindset for Success: Future Career Progression
Avatar for Greg Gifford greggifford
PRO
0
350
Intergalactic Javascript Robots from Outer Space
Avatar for Vicent Martí tanoku
273
27k
Paper Plane (Part 1)
Avatar for Katie Cordina Lindsey katiecoart
PRO
0
8.5k
Leo the Paperboy
Avatar for Maya Tellez mayatellez
7
1.8k
A Soul's Torment
Avatar for Nat Ma seathinner
6
2.9k
Build The Right Thing And Hit Your Dates
Avatar for Maggie C. maggiecrowley
39
3.2k
BBQ
Avatar for Matthew Crist matthewcrist
89
10k

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