Atle Veka wrote:
On Mon, 20 Jun 2005, Kevin Burton wrote:
We're noticing a problem where if we were to write to the master with
multiple threads that our slave DB will fall behind.
Note that we're trying to perform as many inserts as humanly possible
and the load on the master is 1.
Out of curiosity, how many queries are we talking and what sort of
complexity level? I've had replication setups do 600 (simple) updates/s
and slaving was current most of the time and never more than 1 second
behind.
Mostly INSERTS.. We're running about 300qps at full speed and doing
selects on slaves will cause it to fall behind.
Reducing the connection count allows it to NOT fall behind but then I
loose throughput. I'm not happy with either situation.
Kevin
--
Use Rojo (RSS/Atom aggregator)! - visit http://rojo.com.
See irc.freenode.net #rojo if you want to chat.
Rojo is Hiring! - http://www.rojonetworks.com/JobsAtRojo.html
Kevin A. Burton, Location - San Francisco, CA
AIM/YIM - sfburtonator, Web - http://peerfear.org/
GPG fingerprint: 5FB2 F3E2 760E 70A8 6174 D393 E84D 8D04 99F1 4412
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
