Hello, I posted about this probably a year ago or so... We run a replication slave on each of our frontend web servers (4.0.17 RPM). When a large number of updates happen on the master, it kills the performance of the web servers while getting caught up. With our application, it doesn't matter if the slave is a few (or even more) minutes behind, so I'm willing to sacrafice replication speed for performance.
Any way to throttle updates so that, say, the SQL thread will only do a certain number of inserts/updates per second? or maybe any other ideas? -Matt- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
