MySQL5 Repliction seconds slower

Hi there,

I have two high end servers configured with MySQL5 and server A replicates to server B. Both servers are used for read-queries.

Now we discovered that most of the time the replication is around 2 á 4 secs behind the master. So when a query is insert on server A, it takes almost 4 secs to replicate to server B.

Is there any way to speed up the replication?!


Are both servers configured identically? Same number of spindles, same amount of RAM, same CPUs, same, indeces, same (roughly) mysql config, etc, and no non-mysql workload on the mirror?

Is the mirror handling more reads than the master?

Dear MWallace,

Both servers are completely identical. There is no non-mysql workload on the mirror and the configs are the same.

As attachement I added the ‘show status’ from both hosts.


Hm. Could you please also send the results of:
show slave status\G
show variables;
iostat 5 (for maybe 5 iterations)
ps -ef

for each server?

Dear mwallace,

Sorry for the late reaction, but I attached the two stats of both servers. I kinda isolated the problem. It seems to be cause by the reads on the second server. I think it has something to do with locking. Because when we redirect all queries to db01, replication is better.

Thanks for your time again.