About Mysql RDS Replica

0

Hi guys.

Today I receive this message below , all day and , curiously start today 2023-08-21T19:05:04.252101Z 11068699 [Note] Multi-threaded slave statistics for channel '': seconds elapsed = 120; events assigned = 899725313; worker queues filled over overrun level = 3382; waited due a Worker queue full = 2; waited due the total size = 138895; waited at clock conflicts = 110730338976600 waited (count) when Workers occupied = 916555 waited when Workers occupied = 2831282500

Should I be concerned or do I need to make any adjustments to the replica?

質問済み 9ヶ月前321ビュー
3回答
0

Hi,

Thank you for asking your question.

This message in Replica is informational level log. When you enable Multi-threaded replication, coordinator thread periodically prints this statistics into error log.

Detailed information, and meaning of each fields can be found in MySQL document.

I hope this might help.

AWS
回答済み 9ヶ月前
profile pictureAWS
エキスパート
レビュー済み 8ヶ月前
0

From the provided information, it seems like the replica is experiencing some performance-related metrics such as worker queue overruns and wait times. While these metrics don't necessarily indicate an immediate problem, they do suggest that the replica might be under stress or facing some performance challenges.

Depending on your replica's load and configuration, you might want to consider the following: Performance Tuning, Database Optimization, Review Network Latency

回答済み 9ヶ月前
0

thanks guys , if is possible , can close this post ;)

回答済み 9ヶ月前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ