updates to the table can be delayed 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'&qu
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 re
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 se
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 p
