Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
RDS/Auroraパフォーマンスインサイトを使ってみる
Search
hmatsu47
PRO
January 28, 2021
Technology
0
710
RDS/Auroraパフォーマンスインサイトを使ってみる
JAWS-UG 名古屋 いろんなパフォーマンスを学ぶ 2021/01/28
hmatsu47
PRO
January 28, 2021
Tweet
Share
More Decks by hmatsu47
See All by hmatsu47
ゲームで体感!Aurora DSQL の OCC(楽観的同時実行制御)
hmatsu47
PRO
0
5
PostgreSQL+pgvector で GraphRAG に挑戦 & pgvectorscale 0.7.x アップデート
hmatsu47
PRO
0
12
LlamaIndex の Property Graph Index を PostgreSQL 上に構築してデータ構造を見てみる
hmatsu47
PRO
0
12
PostgreSQL+pgvector で LlamaIndex の Property Graph Index を試す(序章)
hmatsu47
PRO
0
11
HeatWave on AWS という選択肢を検討してみる
hmatsu47
PRO
0
7
HeatWave on AWS のインバウンドレプリケーションで HeatWave エンジン有効時のレプリケーションラグを確認してみた!
hmatsu47
PRO
0
16
CloudWatch Database Insights 関連アップデート
hmatsu47
PRO
0
32
さいきんの MySQL との付き合い方 〜 MySQL 8.0 より後の世界へようこそ 〜
hmatsu47
PRO
0
30
ベクトルストア入門
hmatsu47
PRO
0
25
Other Decks in Technology
See All in Technology
React開発にStorybookとCopilotを導入して、爆速でUIを編集・確認する方法
yu_kod
1
120
AIとともに進化するエンジニアリング / Engineering-Evolving-with-AI_final.pdf
lycorptech_jp
PRO
0
150
How Community Opened Global Doors
hiroramos4
PRO
1
140
mrubyと micro-ROSが繋ぐロボットの世界
kishima
3
390
「Chatwork」の認証基盤の移行とログ活用によるプロダクト改善
kubell_hr
1
240
開発生産性を組織全体の「生産性」へ! 部門間連携の壁を越える実践的ステップ
sudo5in5k
1
4.9k
Glacierだからってコストあきらめてない? / JAWS Meet Glacier Cost
taishin
1
130
より良いプロダクトの開発を目指して - 情報を中心としたプロダクト開発 #phpcon #phpcon2025
bengo4com
1
3.2k
マネジメントって難しい、けどおもしろい / Management is tough, but fun! #em_findy
ar_tama
3
440
整頓のジレンマとの戦い〜Tidy First?で振り返る事業とキャリアの歩み〜/Fighting the tidiness dilemma〜Business and Career Milestones Reflected on in Tidy First?〜
bitkey
1
11k
Tech-Verse 2025 Keynote
lycorptech_jp
PRO
0
1.6k
Operating Operator
shhnjk
0
190
Featured
See All Featured
Build The Right Thing And Hit Your Dates
maggiecrowley
36
2.8k
jQuery: Nuts, Bolts and Bling
dougneiner
63
7.8k
Music & Morning Musume
bryan
46
6.6k
The Language of Interfaces
destraynor
158
25k
Rebuilding a faster, lazier Slack
samanthasiow
82
9.1k
The World Runs on Bad Software
bkeepers
PRO
69
11k
The Illustrated Children's Guide to Kubernetes
chrisshort
48
50k
Practical Orchestrator
shlominoach
188
11k
For a Future-Friendly Web
brad_frost
179
9.8k
How STYLIGHT went responsive
nonsquared
100
5.6k
Sharpening the Axe: The Primacy of Toolmaking
bcantrill
44
2.4k
Thoughts on Productivity
jonyablonski
69
4.7k
Transcript
None
https://qiita.com/hmatsu47 ◦ https://qiita.com/hmatsu47/items/ceb75caf46e3c761095d ◦ ◦ https://booth.pm/ja/items/2524481 2
• • ◦ ▪ ◦ ▪ 3
• ◦ https://docs.aws.amazon.com/ja_jp/AmazonRDS/latest/AuroraUserGuide/USER_ PerfInsights.Overview.html • ◦ • ◦ 4
5
6
• • ◦ ◦ ▪ ▪ 7
8
• ◦ https://docs.aws.amazon.com/ja_jp/AmazonRDS/latest/AuroraUserGuide /AuroraMySQL.Reference.html#AuroraMySQL.Reference.Waitevents • ◦ https://docs.aws.amazon.com/ja_jp/AmazonRDS/latest/AuroraUserGuide /AuroraPostgreSQL.Reference.html#AuroraPostgreSQL.Reference.Waite vents 9
• ◦ ▪ https://dev.mysql.com/doc/refman/5.7/en/wait-summary-tables.html ▪ https://dev.mysql.com/doc/refman/5.7/en/performance-schema-wait-tables.html ◦ ▪ https://dev.mysql.com/doc/refman/5.6/ja/wait-summary-tables.html ▪
https://dev.mysql.com/doc/refman/5.6/ja/performance-schema-wait-tables.html 10
• ◦ ▪ https://www.postgresql.jp/document/12/html/monitoring-stats.html#MONITORING-STAT S-VIEWS-TABLE ◦ ▪ https://www.postgresql.jp/document/12/html/monitoring-stats.html#WAIT-EVENT-TABLE 11
• ◦ mysqlslap --auto-generate-sql --auto-generate-sql-guid-primary --engine=innodb --number-int-cols=20 --number-char-cols=20 --concurrency=100 --auto-generate-sql-write-number=2500
--auto-generate-sql-execute-number=5000 --auto-generate-sql-load-type=【タイプ】 -u admin -h 【エンドポイント】 -p ◦ ▪ ◦ 12
• ◦ pgbench -i -s 1000 -U postgres -h 【エンドポイント】
-d pgbench ◦ pgbench -N -r -c 10 -j 10 -T 300 -U postgres -h 【エンドポイント】 pgbench ◦ 13
• ◦ ▪ • ◦ https://docs.aws.amazon.com/ja_jp/AmazonRDS/latest/AuroraUserGuide/USER_ PerfInsights.API.html 14
• [ { "Metric": "db.load.avg", "GroupBy": { "Group": "db.wait_event", "Limit":
10 } } ] • aws pi get-resource-metrics \ > --service-type RDS \ > --identifier 【DBリソースID】 \ > --start-time 2021-01-24T06:10:00Z \ > --end-time 2021-01-24T06:11:00Z \ > --period-in-seconds 60 \ > --metric-queries file://query.json 15
{ "Identifier": "db-S7UPJNXAX6J7ZJWZXFUBTODYRI", "AlignedStartTime": 1611468600.0, "MetricList": [ { "Key": {
"Metric": "db.load.avg" }, "DataPoints": [ { "Timestamp": 1611468660.0, "Value": 58.6 } ] }, 16
17 { "Key": { "Metric": "db.load.avg", "Dimensions": { "db.wait_event.type": "synch",
"db.wait_event.name": "wait/synch/sxlock/innodb/fil_space_latch" } }, "DataPoints": [ { "Timestamp": 1611468660.0, "Value": 0.03333333333333333 } ] },
18 { "Key": { "Metric": "db.load.avg", "Dimensions": { "db.wait_event.type": "synch",
"db.wait_event.name": "wait/synch/sxlock/innodb/fil_space_latch" } }, "DataPoints": [ { "Timestamp": 1611468660.0, "Value": 0.03333333333333333 } ] },
{ "Key": { "Metric": "db.load.avg", "Dimensions": { "db.wait_event.type": "synch", "db.wait_event.name":
"wait/synch/mutex/innodb/trx_mutex" } }, "DataPoints": [ { "Timestamp": 1611468660.0, "Value": 0.016666666666666666 } ] } ], 19
{ "Key": { "Metric": "db.load.avg", "Dimensions": { "db.wait_event.type": "synch", "db.wait_event.name":
"wait/synch/mutex/innodb/trx_mutex" } }, "DataPoints": [ { "Timestamp": 1611468660.0, "Value": 0.016666666666666666 } ] } ], 20
• ◦ ◦ 21
• ◦ ◦ 22
• ◦ ◦ 23
• ◦ • ◦ ◦ ◦ 24