Too Many Messages From Slave Worker Coordinator in Error Logs
Last updated on JULY 26, 2017
Applies to:
MySQL Server - Version 5.6 and laterInformation in this document applies to any platform.
Goal
Error log has too many unnecessary details that originate from the multi-threaded slave (MTS) coordinator, such as:
2016-02-18 21:34:37 7196 [Note] Coordinator synchronized with Workers, waited entries: 0, cant_sync: 0
2016-02-18 21:34:37 7196 [Note] Coordinator and workers enter synchronization procedure when scheduling event relay-log: relay-bin.001960 pos: 83212499
2016-02-18 21:34:37 7196 [Note] Coordinator and workers enter synchronization procedure when scheduling event relay-log: relay-bin.001960 pos: 83212660
2016-02-18 21:34:37 7196 [Note] Coordinator synchronized with Workers, waited entries: 0, cant_sync: 0
2016-02-18 21:34:37 7196 [Note] Coordinator and workers enter synchronization procedure when scheduling event relay-log: relay-bin.001960 pos: 83212499
2016-02-18 21:34:37 7196 [Note] Coordinator and workers enter synchronization procedure when scheduling event relay-log: relay-bin.001960 pos: 83212660
2016-02-18 21:34:37 7196 [Note] Coordinator synchronized with Workers, waited entries: 0, cant_sync: 0
How to disable these messages?
Solution
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms