3 messages in com.mysql.lists.mysqlRe: slow replication again in 4.0.12 ?
FromSent OnAttachments
Andreas Vierengel06 May 2003 07:37 
Jeremy Zawodny06 May 2003 10:06 
Andreas Vierengel07 May 2003 01:10 
Subject:Re: slow replication again in 4.0.12 ?
From:Jeremy Zawodny (Jer@Zawodny.com)
Date:05/06/2003 10:06:08 AM
List:com.mysql.lists.mysql

On Tue, May 06, 2003 at 04:37:52PM +0200, Andreas Vierengel wrote:

I've setting up 1 master and 1 slave, each v 4.0.12 (libc6 binary from mysq1.com) under debian woody with linux 2.4.20. replication is working without problem. both machines are completely unloaded. if I insert 1 row in the master, it takes about 5-30seconds before the row appears in the slave.

I've tcpdumped and found out, that the master is sendig the insert instantly across the (switched 100MBit/s full-duplex) Ethernet. So it must be on the slave machine. Sounds like a buffering problem (fsync ?)

How can I accelerate the whole thing. Even 5 seconds are unacceptable if the machines have nothing to do...

Are non-replicated queries also slow on the slave?

MySQL 4.0.8: up 92 days, processed 2,918,241,094 queries (366/sec. avg)