From: gerald_clark (gerald_clarksuppliersystems.com)
Date: Fri Jul 02 2004 - 08:12:09 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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: mysqllists.mysql.com
>Sent: 6/30/04 10:34 PM
>Subject: Replication Performance
>
>Dear, mysqllists.mysql.com,
>
> 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
> zh-mahkbn.com.hk
> 2004-07-01
>
>
>= = = = = = = = = = = = = = = = = = = = = =
>Best regards.
>
> MaFai
> zh-mahkbn.com.hk
> 2004-07-02
>
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]