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