Re: Replication blocked

2004-08-16 Thread Bill Easton
or that a deadlock can happen on the master, as well. = Original message follows = Date: Fri, 13 Aug 2004 14:42:28 -0700 From: Jeremy Zawodny [EMAIL PROTECTED] To: Donny Simonton [EMAIL PROTECTED] Cc: 'Batara Kesuma' [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Replication blocked

RE: Replication blocked

2004-08-13 Thread Donny Simonton
still cause problems because of multi-table deletes and updates. Donny -Original Message- From: Batara Kesuma [mailto:[EMAIL PROTECTED] Sent: Friday, August 13, 2004 1:00 AM To: [EMAIL PROTECTED] Subject: Replication blocked Hi, I have 2 DB server, running as master and slave. I

Re: Replication blocked

2004-08-13 Thread Jeremy Zawodny
On Fri, Aug 13, 2004 at 01:19:14AM -0500, Donny Simonton wrote: There is only one thread for replication on the slave. It does one step a time. If you use mysqlbinlog on one of your binary files on your master, you will see exactly how it all works. No, there are 2 threads: the IO (or

Replication blocked

2004-08-12 Thread Batara Kesuma
Hi, I have 2 DB server, running as master and slave. I just add an index to one of my table on master, it took about 12 minutes. During adding the index, I have insert/update queries to other tables. On master this has no problem at all. The problem is, on slave these queries were blocked by the