MySQL Replication Issue


I experienced a problem on a MySQL Server configured with Master/Slave replication, the Slave wasn't updating properly and the command show slave status \G; returned a delay of 10000 seconds (see field Seconds_Behind_Master) even if Slave_IO_State was "Waiting for master to send event".

I tried tuning some parameters (e.g. buffer pool size, slave_exec_mode..) but it didn't become aligned.

After I reset the Long Query Log the replication speed increased a lot and in a few minutes Seconds_Behind_Master became 0.
Share on Google Plus

About Vittorio Pavesi

    Blogger Comment
    Facebook Comment

0 comments: