enterprise-support team mailing list archive

[Valerii Kravchuk <valerii.kravchuk@xxxxxxxxxxx>]

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