MaFai wrote:
>Dear ALL: > >Some time the slave would crushed by I/O error.It happen at the server with the lower >CPU.( per 45 days ) >All of the slave database has block the binary log,it reduce the CPU loading. >The database would replicate text,int,varchar but no blob. >Network connection hasn't drop frequently,it seems hard to avoid that. > What does this mean? It does or does not drop frequently? If you have a poor network connection, you will never get this working. >Do any way make the slave query more time but not just idle and wait for the data? >Since we can't bear the slave need 10 minutes to synchronize the data with master. > > > >Here the master status >Uptime: 2592393 Threads: 24 Questions: 214644229 Slow queries: 197 Opens: 580 >Flush tables: 1 Open tables: 254 Queries per second avg: 82.798 > > >======== At 2004-07-01, 22:06:24 you wrote: ======== > >What does the network setup look like? What type of data is being replicated >varchar, text, blob? Is the network connection being dropped or are there >any errors being logged anywhere? > >-----Original Message----- >From: MaFai >To: [EMAIL PROTECTED] >Sent: 6/30/04 10:34 PM >Subject: Replication Performance > >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? > > >Best regards. > > MaFai > [EMAIL PROTECTED] > 2004-07-01 > > >= = = = = = = = = = = = = = = = = = = = = = >Best regards. > > MaFai > [EMAIL PROTECTED] > 2004-07-02 > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
