Lock in $30 Savings on PRO—Offer Ends Soon! ⏳

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

hmatsu47
January 28, 2021

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

JAWS-UG 名古屋 いろんなパフォーマンスを学ぶ 2021/01/28

hmatsu47

January 28, 2021
Tweet

More Decks by hmatsu47

Other Decks in Technology

Transcript

  1. 5

  2. 6

  3. 8

  4. • ◦ 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
  5. • ◦ pgbench -i -s 1000 -U postgres -h 【エンドポイント】

    -d pgbench ◦ pgbench -N -r -c 10 -j 10 -T 300 -U postgres -h 【エンドポイント】 pgbench ◦ 13
  6. • [ { "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
  7. { "Identifier": "db-S7UPJNXAX6J7ZJWZXFUBTODYRI", "AlignedStartTime": 1611468600.0, "MetricList": [ { "Key": {

    "Metric": "db.load.avg" }, "DataPoints": [ { "Timestamp": 1611468660.0, "Value": 58.6 } ] }, 16
  8. 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 } ] },
  9. 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 } ] },
  10. { "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
  11. { "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