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?

3 réponses
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
répondu il y a 9 mois
profile pictureAWS
EXPERT
vérifié il y a 8 mois
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

répondu il y a 9 mois
0

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

répondu il y a 9 mois

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions