Request to add graph for InnoDB History List Length to CloudWatch Metrics for RDS MySQL Databases

1

The InnoDB History List Length is an important metric to monitor to ensure that Disk I/O is sufficient for an instance. See Baron Schwartz excellent article about what it is.

When the InnoDB purge process is not able to keep up, it can lead to very unexpected behavior, such as otherwise unexplainable high disk I/O, and slow performance. example

It would be useful for the community to have this metric monitored automatically with CloudWatch for all MySQL instances. You can obtain the value easily with the command

SELECT count
FROM information_schema.innodb_metrics
WHERE name = 'trx_rseg_history_len'

Since InnoDB is the default storage engine on MySQL and Aurora/MySQL instances, this would help customer understand if their write capacity is insufficient, and provide a starting point for investigating more complex issues.

已提問 3 個月前檢視次數 113 次
1 個回答
2
已接受的答案

You can get the specific metric using Performance Insights, if you enabled Performance insights for the RDS MySQL instances there are multiple Non-native counters for Amazon RDS for MariaDB and MySQL which are supported.

Checking the link attached it also supports trx_rseg_history_len.

On an added Note: Performance Insights offers a rolling seven days of performance data history at no charge. This is enough time to troubleshoot a wide variety of issues. The Performance Insights free tier includes:

  • 7 days of performance data history
  • 1 million API requests per month

Hope it helps and if it does, I would appreciate if answer can be accepted so that community can benefit for clarity when searching for similar enquirers in Repost, thank you ;)

AWS
已回答 3 個月前
profile picture
專家
已審閱 2 個月前
  • Thank you Utsav, I have used Performance Insights since it came out, but never noticed the "Metrics" tab where it has all of these additional metrics!

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南