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?

posta 9 mesi fa322 visualizzazioni
3 Risposte
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
con risposta 9 mesi fa
profile pictureAWS
ESPERTO
verificato 8 mesi fa
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

con risposta 9 mesi fa
0

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

con risposta 9 mesi fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande