On Thu, Jul 01, 2004 at 11:34:29AM +0800, MaFai wrote: > Dear, [EMAIL PROTECTED], > > We have set up 1 master and 4 slave as replication. > Sometime,the slave need 4~10 minutes to synchronize the data with master > database. > Do any way to tune the performance? > Or any other way to reduce the time to replicate?
You need to identify the bottleneck. Is the slave's IO thread taking too long to pull binary log entries from the master? Or is the SQL thread hopelessly behind because of a slow hard disk, CPU, or memory shortage? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
