RDS/Auroraパフォーマンスインサイトを使ってみる

by hmatsu47

Slide 1

Slide 1 text

No content

Slide 2

Slide 2 text

https://qiita.com/hmatsu47 ○ https://qiita.com/hmatsu47/items/ceb75caf46e3c761095d ○ ○ https://booth.pm/ja/items/2524481 2

Slide 3

Slide 3 text

● ● ○ ■ ○ ■ 3

Slide 4

Slide 4 text

● ○ https://docs.aws.amazon.com/ja_jp/AmazonRDS/latest/AuroraUserGuide/USER_ PerfInsights.Overview.html ● ○ ● ○ 4

Slide 5

Slide 5 text

Slide 6

Slide 6 text

Slide 7

Slide 7 text

● ● ○ ○ ■ ■ 7

Slide 8

Slide 8 text

Slide 9

Slide 9 text

● ○ 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

Slide 10

Slide 10 text

● ○ ■ 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

Slide 11

Slide 11 text

● ○ ■ 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

Slide 12

Slide 12 text

● ○ 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

Slide 13

Slide 13 text

● ○ pgbench -i -s 1000 -U postgres -h 【エンドポイント】 -d pgbench ○ pgbench -N -r -c 10 -j 10 -T 300 -U postgres -h 【エンドポイント】 pgbench ○ 13

Slide 14

Slide 14 text

● ○ ■ ● ○ https://docs.aws.amazon.com/ja_jp/AmazonRDS/latest/AuroraUserGuide/USER_ PerfInsights.API.html 14

Slide 15

Slide 15 text

● [ { "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

Slide 16

Slide 16 text

{ "Identifier": "db-S7UPJNXAX6J7ZJWZXFUBTODYRI", "AlignedStartTime": 1611468600.0, "MetricList": [ { "Key": { "Metric": "db.load.avg" }, "DataPoints": [ { "Timestamp": 1611468660.0, "Value": 58.6 } ] }, 16

Slide 17

Slide 17 text

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 } ] },

Slide 18

Slide 18 text

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 } ] },

Slide 19

Slide 19 text

{ "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