IO Thread will always be ahead,becuase this will keep interacting with
master and any changes at master will be pulled by this IO thread and insert
into RELAY LOG.
Its the SQL THREAD that will execute all the statements in RELAY LOG.
By the way how did u check IO thread is ahead of SQL Thread.
O
do a show full processlist on the 4th slave and see what process is
running. This will the sql's running which will be the cause of the
slowness.
>> This does not help because there is not a specific query, which is
running slow. Other 3 slaves are running same query and I"ve compared
the expla
do a show full processlist on the 4th slave and see what process is running.
This will the sql's running which will be the cause of the slowness.
Also u need to check on the INTERNET bandwidth from the current data center
to the other data center.
On 6/18/08, Sagar, Sanjeev <[EMAIL PROTECTED]> w