Database Administration (MOSC)

MOSC Banner

Delayed replication in mysql slave

edited May 20, 2021 3:59PM in Database Administration (MOSC) 1 commentAnswered

When executing a series of batch processes inserting approximately 200K to 300K of records per batch in the master, the Seconds_Behind_Master parameter shows a huge delay in seconds and accumulates the delay when the next batch runs. And it took 13 hours for the slave to catch up from the master.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center