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 個月前

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

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

回答問題指南