Slave Node Cannot Keep Up With Master With sync_master_info = 1 (Doc ID 2199622.1)

Last updated on APRIL 20, 2017

Applies to:

MySQL Server - Version 5.5 and later
Information in this document applies to any platform.

Symptoms

The I/O thread of the replication slave cannot keep up with the master. The SQL thread is keeping up with the I/O thread. For example the output of SHOW SLAVE STATUS may show:

 

Changes

The value of sync_master_info have been changed to a low value other than zero.

Cause

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