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 Respostas
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
respondido há 9 meses
profile pictureAWS
ESPECIALISTA
avaliado há 8 meses
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

respondido há 9 meses
0

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

respondido há 9 meses

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas