List:General Discussion« Previous MessageNext Message »
From:sangprabv Date:June 26 2009 1:07pm
Subject:Re: Multiple Rows DELETE Fails on Replication
View as plain text  
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 <sangprabv@stripped>
> 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=1
>         
> 
> 
> 
> -- 
> David Yeung,
> MySQL Senior Support Engineer,
> Sun Gold Partner.
> My Blog:http://yueliangdao0608.cublog.cn

Thread
Multiple Rows DELETE Fails on Replicationsangprabv24 Jun
  • Re: Multiple Rows DELETE Fails on ReplicationMoon's Father26 Jun
    • Re: Multiple Rows DELETE Fails on Replicationsangprabv26 Jun