MySQL Transaction Isolation Level

mysql_transaction_iso

##
# Set isolation level to READ-COMMITTED
# https://dev.mysql.com/doc/refman/5.6/en/set-transaction.html
##
SELECT @@GLOBAL.tx_isolation, @@tx_isolation;
SET GLOBAL tx_isolation='READ-COMMITTED';
SET SESSION tx_isolation='READ-COMMITTED';

##
# Set binlog to MIXED format
# http://dba.stackexchange.com/questions/6150/what-is-the-safest-way-to-switch-the-binlog-format-at-runtime/6753#6753?newreg=1e7f12bd452b4a93945c79402565e180
##

FLUSH TABLES WITH READ LOCK;
FLUSH LOGS;
SET GLOBAL binlog_format = 'MIXED';
FLUSH LOGS;
UNLOCK TABLES;