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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
