Bug #74808 Hard to identify if the SQL thread is using SBR/RBR
Submitted: 12 Nov 2014 7:38 Modified: 18 Apr 2016 12:52
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server: Row Based Replication ( RBR ) Severity:S4 (Feature request)
Version:5.6.16 OS:Any
Assigned to: CPU Architecture:Any
Tags: RBR, replication

[12 Nov 2014 7:38] Daniël van Eeden
Description:
When using binlog_rows_query_log_events it might seem that a slave is executing statements while it is actually applying row events.

http://dev.mysql.com/doc/refman/5.6/en/replication-options-binary-log.html#sysvar_binlog_r...

How to repeat:
Setup master with:
binlog_format=ROW
binlog_rows_query_log_events

On the slave it shows in the processlist for the SQL thread:
State: Reading event from the relay log
Info: UPDATE t1 SET a=1 WHERE b=2

If you now get the relaylog file name and position and use mysqlbinlog -vv to inspect it you can see:
Rows_query
Table_map
Update_rows (multiple)

Suggested fix:
Make sure there is an indication about if a slave is executing a query or update_rows event.
[18 Apr 2016 12:52] Daniël van Eeden
marked as feature request