Multiple Rows DELETE Fails on Replication

Multiple Rows DELETE Fails on Replication

am 24.06.2009 03:46:31 von uYe

Hi,
I found every time I try to do multiple rows delete on replicated MySQL
is always failed. Is there any explanation regarding this issue and how
to solve it? TIA.



Willy


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Multiple Rows DELETE Fails on Replication

am 26.06.2009 10:14:04 von yueliangdao0608

--0016e6475b047d7f81046d3bece4
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Could you tell me your detail statements?
On Wed, Jun 24, 2009 at 9:46 AM, sangprabv wrote:

> Hi,
> I found every time I try to do multiple rows delete on replicated MySQL
> is always failed. Is there any explanation regarding this issue and how
> to solve it? TIA.
>
>
>
> Willy
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=yueliangdao0608@gmail.com
>
>


--
David Yeung,
MySQL Senior Support Engineer,
Sun Gold Partner.
My Blog:http://yueliangdao0608.cublog.cn

--0016e6475b047d7f81046d3bece4--

Re: Multiple Rows DELETE Fails on Replication

am 26.06.2009 15:07:55 von uYe

DELETE FROM table WHERE key LIKE '%100%'
Also I tried to continously insert big numbers of new records (around 50
millions new records) and tried to delete 1 record on master, I checked
the slave not synchronized. Is it just a lag?


Willy


On Fri, 2009-06-26 at 16:14 +0800, Moon's Father wrote:
>
> Could you tell me your detail statements?
> On Wed, Jun 24, 2009 at 9:46 AM, sangprabv
> wrote:
> Hi,
> I found every time I try to do multiple rows delete on
> replicated MySQL
> is always failed. Is there any explanation regarding this
> issue and how
> to solve it? TIA.
>
>
>
> Willy
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=yueliangdao0608@gmail.com
>
>
>
>
> --
> David Yeung,
> MySQL Senior Support Engineer,
> Sun Gold Partner.
> My Blog:http://yueliangdao0608.cublog.cn


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org