Too Many Messages From Slave Worker Coordinator in Error Logs (Doc ID 2111030.1)

Last updated on JULY 26, 2017

Applies to:

MySQL Server - Version 5.6 and later
Information 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

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