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.
0 commenti:
Post a Comment