Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: shawn green (shawn.l.greenoracle.com)
Date: Fri Apr 20 2012 - 08:13:07 CDT
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
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql