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
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.
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN