MySQL 8 Cookbook

Observations

1. You executed the UPDATE statement in statement-based replication and the same statement is logged in the binary log. Apart from the server, session variables are also saved in the binary log to replicate the same behavior on the slave:

# at 226#170815 13:28:38 server id 200  end_log_pos 324 CRC32 0x9d27fc78  Query thread_id=8 exec_time=0 error_code=0SET TIMESTAMP=1502803718/*!*/;SET @@session.pseudo_thread_id=8/*!*/;SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0,@@session.unique_checks=1, @@session.autocommit=1/*!*/;SET @@session.sql_mode=1436549152/*!*/;SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;/*!\C utf8 *//*!*/;SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=255/*!*/; ...