Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Sign up for free
Menu
Search
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Pricing
Search
Sign in
Sign up for free
AWS Auroraのスロークエリを Datadogで扱うまで / How to handle...
Search
mnuma
February 03, 2021
Technology
1.1k
0
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
AWS Auroraのスロークエリを Datadogで扱うまで / How to handle slow_queries_logs in AWS Aurora with Datadog
mnuma
February 03, 2021
Transcript
24 slides
"84"VSPSBͷεϩʔΫΤϦΛ %BUBEPHͰѻ͏·Ͱ .BLVBLF-51BSUZ
!NOVNB@ 5FBN43& %JTOFZ ʹೖΓ·ͨ͠ "OLFS/FCVMB$PTNPT."9ങͬͯΑ͔ͬͨ
ੈͷதʹͭͷϩά͕͋Γ·͢
ඇߏԽϩά 6OTUSVDUVSFE-PHT ߏԽϩά 4USVDUVSFE-PHT
ඇߏԽϩά 6OTUSVDUVSFE-PHT DPNCJOFEMPHGPSNBU <%FD >(&5)551.P[JMMB 9-JOVYY@ "QQMF8FC,JU ,)5.- MJLF(FDLP
$ISPNF4BGBSJ
ҰൠతʹKTPO ࣄલఆٛ͞ΕͨϝοηʔδϑΥʔϚοτ ςΩετͰͳ͘σʔληοτ ϩάͷॲཧ͕؆୯ʹͳΓϩάͷੳ͕ḿΔ ѻ͍͍͢ ߏԽϩά 4USVDUVSFE-PHT KTPO1BZMPBE\ lpSTU@OBNF+PIO
lMBTU@OBNFl4NJUIz BHF NFTTBHFl)J ^
ɾ&SSPSMPH ɾ(FOFSBMRVFSZMPH ɾ4MPXRVFSZMPH ɾ"VEJUMPH "NB[PO"VSPSBͷϩά $MPVE8BUDIʹΤΫεϙʔτՄೳ
IUUQTEPDTEBUBEPHIRDPNKBTFSWFSMFTTGPSXBSEFS $MPVE8BUDI-PHT͔Β%BUBEPHͷసૹ %BUBEPHͷϑΥϫʔμʔ͕ఏڙ͞Εͯ·͢ɻ
εϩʔΫΤϦϩά 4MPXRVFSZMPH
None
ϩάग़ྗ࣌ Ϣʔβʔɺଓαʔό 2VFSZ@UJNFΫΤϦ࣮ߦ࣌ؒ -PDL@UJNFϩοΫ࣌ؒ 3PXT@TFOUग़ྗߦ 3PXT@FYBNJOFEॲཧରߦ
42-จ
εϩʔΫΤϦϩά ඇߏԽϩά Λ%BUBEPHͰѻ͍͍ͨ
ɾඇߏԽϩά ɾෳߦ ɾσϦϛλ͕ڰؾཚ֯εϖʔε!
l*HSPLJOGVMMOFTTz3PCFSU")FJOMFJO 4USBOHFSJOB4USBOHF-BOE (SPL
(SPL ਖ਼نදݱηοτ ओʹϩάσʔλ͚ͷநग़ϑΟϧλɻ ඇߏσʔλΛਖ਼نදݱʹΑͬͯߏσʔλʹมग़དྷΔɻ
https://github.com/logstash-plugins/logstash-patterns-core/blob/master/patterns/grok-patterns
(SPL Datadog LogsͰϩάऩू࣌ʹGrokΛϑΟϧλ͢Δ͜ͱ͕ग़དྷ·͢ɻ
ߏจ SVMF@OBNF\NBUDIFSpFMEpMUFS লུՄ ^ʜ ྫ VTFSPSEFSTUBUVTDPNQMFUF (SPLύʔαʔ IPHF@QBSTFS\EBUF ZZZZ..EE))NNTT444 UJNFTUBNQ^VTFS\OVNCFSVTFSJE^PSEFS
\EBUBPSEFSLFZWBMVF^
ߏจ SVMF@OBNF\NBUDIFSpFMEpMUFS লུՄ ^ʜ ྫ VTFSPSEFSTUBUVTDPNQMFUF (SPLύʔαʔ IPHF@QBSTFS\EBUF ZZZZ..EE))NNTT444 UJNFTUBNQ^VTFS\OVNCFSVTFSJE^PSEFS
\EBUBPSEFSLFZWBMVF^
None
ύλʔϯ 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 ѥछ
ύλʔϯ 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 ѥछ
ύλʔϯ 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 ѥछ
ɾ"VSPSBͷϩάΛ%BUBEPHͰѻͬͯΔՕॴͷղઆ ɾॏΊͷ42-Λҙࣝग़དྷΔΈͱ͔͋Δͱྑ͍͔
More Decks by mnuma
See All by mnuma
セキュリティチェックシートの話 / Security Check Sheet
mnuma
0
56
Datadogで始めるユーザー行動分析 / Getting Started with User Behavior Analysis Using Datadog
mnuma
0
120
自動テストについて / Automated Testing
mnuma
0
270
Kubernetesの自動アップグレードについて / Upgrading GKE cluster
mnuma
0
240
Googleに学ぶDesign Docs / Learn from Google on Design Docs
mnuma
0
200
Observabilityを実践する / Pragmatic observability
mnuma
2
250
Kubernetes Case Studies #1@Makuake KubeCon NA 2019 Recap
mnuma
0
190
カオスエンジニアリングについてヤホーで調べてきました / Enter the chaos engineering
mnuma
0
140
Chaos Engineering 現状把握 / History Of Chaos Engineering
mnuma
0
420
Other Decks in Technology
See All in Technology
E2E Test というハーネス — AI時代の自動テスト民主化
daishukojima
10
6k
市販IoT機器や自作IoT機器とHomeAssistantを駆使して家の電気代をできる限り見える化する方法の考案
harutiro
0
410
実測データからサービスの成長余力を測る。負荷シナリオ・テストデータ・限界値の設計
kazatohiei
0
160
落とし穴にハマってわかった 開発生産性を測るときに気をつけたいこと
munakata
3
490
人の努力に頼らないセキュリティをエンジニアリングする在り方 / An approach to engineering security that does not rely on human effort
carta_engineering
0
240
エンタープライズ事業未経験のデータ屋、 AI時代にN回撃沈する.pdf
ryoskdara_
0
190
Platform Engineering をベースとした Agentic Software Factory の実践
110y
3
890
AWS Well-Arhitected Frameworkセキュリティの柱 について
miu_crescent
PRO
2
210
Oracle Base Database Service 技術詳細
oracle4engineer
PRO
17
120k
20261113_AWS Organizations運用を下支えするCFn StackSetsの柔軟性
dkduppf
0
110
NutanixへのSSHアクセスの今後について
shadowhat
0
160
自動計装なしでECSサービスをApplication Signalsに載せるまで
ota1022
2
470
Featured
See All Featured
Organizational Design Perspectives: An Ontology of Organizational Design Elements
kimpetersen
PRO
1
880
Statistics for Hackers
jakevdp
799
230k
How to Talk to Developers About Accessibility
jct
2
630
CSS Pre-Processors: Stylus, Less & Sass
bermonpainter
360
31k
How to Build an AI Search Optimization Roadmap - Criteria and Steps to Take #SEOIRL
aleyda
1
2.3k
SERP Conf. Vienna - Web Accessibility: Optimizing for Inclusivity and SEO
sarafernandez
2
1.7k
Become a Pro
speakerdeck
PRO
31
6.4k
BBQ
matthewcrist
90
10k
From π to Pie charts
rasagy
1
460
Designing Dashboards & Data Visualisations in Web Apps
destraynor
232
55k
What's in a price? How to price your products and services
michaelherold
247
13k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
35
3.9k