Re-verification for 5.5 is NOT needed, as it was not a real fix, just this:
"The current fix helps diagnose this issue by printing a message to the error log if the execution time for a given statement replicated using row-based replication takes more than 60 seconds. log_warnings must be greater than 1 for this message to be printed to the error log." This is the real fix: http://binlogtorelaylog.blogspot.in/2012/08/Batch- operations-in-RBR.html Variable is there since 5.6.6, see mysql.com/doc/refman/5.6/en /replication-options-slave.html#sysvar_slave_rows_search_algorithms Moreover: [openxs@centos Percona-Server-5.6.11-rc60.3-375.Linux.x86_64]$ strings bin/mysqld | grep slave_rows _ZN15Hash_slave_rows4sizeEv _ZN15Hash_slave_rows13make_hash_keyEP5TABLEP9st_bitmap _ZN15Hash_slave_rows3getEP5TABLEP9st_bitmap _ZN15Hash_slave_rows4initEv _ZN15Hash_slave_rows3putEP5TABLEP9st_bitmapP17hash_row_entry_st slave_rows_search_algorithms_options _ZN15Hash_slave_rows6deinitEv _ZN15Hash_slave_rows8is_emptyEv _ZN15Hash_slave_rows3delEP17hash_row_entry_st _ZN15Hash_slave_rows4nextEPP17hash_row_entry_st _ZN15Hash_slave_rows10make_entryEPKhS1_S1_S1_ slave_rows_search_algorithms So. PS 5.6.11 is NOT affected. ** Changed in: percona-server/5.6 Status: New => Invalid -- You received this bug notification because you are a member of Ubuntu Server/Client Support Team, which is subscribed to MySQL. Matching subscriptions: Ubuntu Server/Client Support Team https://bugs.launchpad.net/bugs/903506 Title: RBR + no PK => High load on slave (table scan/cpu) => slave failure To manage notifications about this bug go to: https://bugs.launchpad.net/mysql-server/+bug/903506/+subscriptions -- Mailing list: https://launchpad.net/~enterprise-support Post to : [email protected] Unsubscribe : https://launchpad.net/~enterprise-support More help : https://help.launchpad.net/ListHelp
