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
現地速報! Microsoft Ignite アップデートレポート
kasada
0
360
文書画像からの情報抽出を行うエージェントを、軌跡の正解データ無しで作れるか
sansantech
PRO
2
220
メール到達性を支える、リンク先URLのドメイン評価の扱い方
wind111
0
180
パスワードのない鍵で、 データを手元に置く
ginjihayashi
0
380
そのイメージ、どのCIが作った? Artifact Attestationsで来歴を固定する / Which CI system created that image? Pinning provenance with Artifact Attestations
chmikata
0
140
Platform Engineering をベースとした Agentic Software Factory の実践
110y
1
490
SORACOM × AWS IoT Core でSREする
butadora
0
120
_マネジメントする人される人ナイト_2026__良いチームを作っていきたい_お気持ち_.pdf
xkxaxkx
0
830
落とし穴にハマってわかった 開発生産性を測るときに気をつけたいこと
munakata
3
460
Gov-JAWS#9 統合監視機能のマネージドサービス化+AIによる障害時自動調査
fj_yoshimura_kosuke
0
220
OWASP AI Agentic Top10に準拠するクラウドネイティブなガードレールの実践(CNDW 2026)
keitah
1
370
お風呂場をサーバルームにしよう
yusuke427
0
380
Featured
See All Featured
A Modern Web Designer's Workflow
chriscoyier
699
190k
Marketing to machines
jonoalderson
1
6k
Navigating Weather and Climate Data
rabernat
0
600
Building a Modern Day E-commerce SEO Strategy
aleyda
45
9.3k
Everyday Curiosity
cassininazir
0
410
Ethics towards AI in product and experience design
skipperchong
2
470
Designing for Timeless Needs
cassininazir
1
570
Future Trends and Review - Lecture 12 - Web Technologies (1019888BNR)
signer
PRO
0
3.8k
Building an army of robots
kneath
307
47k
KATA
mclloyd
PRO
35
16k
The State of eCommerce SEO: How to Win in Today's Products SERPs - #SEOweek
aleyda
2
12k
Why You Should Never Use an ORM
jnunemaker
PRO
61
10k