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)