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
720
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
17
LlamaIndex の Property Graph Index を PostgreSQL 上に構築してデータ構造を見てみる
hmatsu47
PRO
0
14
PostgreSQL+pgvector で LlamaIndex の Property Graph Index を試す(序章)
hmatsu47
PRO
0
11
HeatWave on AWS という選択肢を検討してみる
hmatsu47
PRO
0
7
HeatWave on AWS のインバウンドレプリケーションで HeatWave エンジン有効時のレプリケーションラグを確認してみた!
hmatsu47
PRO
0
17
CloudWatch Database Insights 関連アップデート
hmatsu47
PRO
0
32
さいきんの MySQL との付き合い方 〜 MySQL 8.0 より後の世界へようこそ 〜
hmatsu47
PRO
0
31
ベクトルストア入門
hmatsu47
PRO
0
25
Other Decks in Technology
See All in Technology
OSSのSNSツール「Misskey」をさわってみよう(右下ワイプで私のOSCの20年を振り返ります) / 20250705-osc2025-do
akkiesoft
0
170
United Airlines Customer Service– Call 1-833-341-3142 Now!
airhelp
0
170
Lakebaseを使ったAIエージェントを実装してみる
kameitomohiro
0
140
ビジネス職が分析も担う事業部制組織でのデータ活用の仕組みづくり / Enabling Data Analytics in Business-Led Divisional Organizations
zaimy
0
140
United airlines®️ USA Contact Numbers: Complete 2025 Support Guide
unitedflyhelp
0
330
B2C&B2B&社内向けサービスを抱える開発組織におけるサービス価値を最大化するイニシアチブ管理
belongadmin
2
7.3k
Contributing to Rails? Start with the Gems You Already Use
yahonda
2
100
React開発にStorybookとCopilotを導入して、爆速でUIを編集・確認する方法
yu_kod
1
290
[ JAWS-UG千葉支部 x 彩の国埼玉支部 ]ムダ遣い卒業!FinOpsで始めるAWSコスト最適化の第一歩
sh_fk2
2
110
american aa airlines®️ USA Contact Numbers: Complete 2025 Support Guide
aaguide
0
320
クラウド開発の舞台裏とSRE文化の醸成 / SRE NEXT 2025 Lunch Session
kazeburo
1
240
自律的なスケーリング手法FASTにおけるVPoEとしてのアカウンタビリティ / dev-productivity-con-2025
yoshikiiida
2
17k
Featured
See All Featured
Music & Morning Musume
bryan
46
6.6k
[RailsConf 2023 Opening Keynote] The Magic of Rails
eileencodes
29
9.6k
Learning to Love Humans: Emotional Interface Design
aarron
273
40k
Into the Great Unknown - MozCon
thekraken
40
1.9k
The Web Performance Landscape in 2024 [PerfNow 2024]
tammyeverts
8
690
The Myth of the Modular Monolith - Day 2 Keynote - Rails World 2024
eileencodes
26
2.9k
The Illustrated Children's Guide to Kubernetes
chrisshort
48
50k
I Don’t Have Time: Getting Over the Fear to Launch Your Podcast
jcasabona
32
2.4k
Sharpening the Axe: The Primacy of Toolmaking
bcantrill
44
2.4k
Chrome DevTools: State of the Union 2024 - Debugging React & Beyond
addyosmani
7
740
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
mongodb
46
9.6k
4 Signs Your Business is Dying
shpigford
184
22k
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