Delayed replication in mysql slave
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.