List:General Discussion« Previous MessageNext Message »
From:shawn green Date:April 20 2012 1:13pm
Subject:Re: Maser-Slave replication is playing up
View as plain text  
Hello Egor,

On 4/20/2012 8:52 AM, nixofortune wrote:
> Hi Shaw,
> I have two more question here.
> 1. Why those rows hasn't been deleted on slaves?
> 2. Why no slow logs entries were created?
> Many thanks for your time and effort.

1) Perhaps the slave has not reached that point in the binary logs? You 
did say they were still behind.  The other thing to check is if the 
master wrote those commands into the binary log (check the master's 
config file for any binlog* filters) or if the slave has been told to 
not execute those commands (look in the slave's config file for any 
replicate* filters)
http://dev.mysql.com/doc/refman/5.5/en/replication-options-binary-log.html#option_mysqld_binlog-do-db
http://dev.mysql.com/doc/refman/5.5/en/replication-options-slave.html#option_mysqld_replicate-do-db

2) The SLAVE SQL thread, by default,  does not contribute to the Slow 
Query Log.  To enable this, use the --log-slow-slave-statements option.
http://dev.mysql.com/doc/refman/5.5/en/slow-query-log.html

Yours,
-- 
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
Thread
Maser-Slave replication is playing upnixofortune20 Apr
  • Re: Maser-Slave replication is playing upReindl Harald20 Apr
    • Re: Maser-Slave replication is playing upnixofortune20 Apr
      • Re: Maser-Slave replication is playing upshawn green20 Apr
      • Re: Maser-Slave replication is playing upReindl Harald20 Apr
        • Re: Maser-Slave replication is playing upnixofortune20 Apr
  • Re: Maser-Slave replication is playing upshawn green20 Apr
    • Re: Maser-Slave replication is playing upnixofortune20 Apr
    • Re: Maser-Slave replication is playing upnixofortune20 Apr
      • Re: Maser-Slave replication is playing upshawn green20 Apr