Also,
run "SHOW PROCESSLIST", to see what sql's are running on slave.
This will give u any idea if any huge dml was run on master and its getting
sync'd with slave.
regards
anandkl
On Fri, Mar 26, 2010 at 8:25 PM, Jim Lyons wrote:
> A few things to keep in mind:
>
> 1: the master may have seve
A few things to keep in mind:
1: the master may have several threads feeding into the binlog at a time,
but a slave only executes in a single thread. Are you throwing more stuff
at the slave in multiple mysql threads?
2: is there something else going on with the slave box? some big backup or
gz
Good day :)
We've had our master/slave server running for a while now, and just
yesterday, we started getting behind.
Not entirely sure what happened, but it is getting further and furhter
behind.
(master server)
mysql> show master status\G
*** 1. row *