现象:
131020 10:21:01 [Warning] Statement may not be safe to log in statement format. Statement: UPDATE `instance` SET `instance_name` = 'Central' WHERE `instance_id` = '1' LIMIT 1 131020 10:22:01 [Warning] Statement may not be safe to log in statement format. Statement: UPDATE `instance` SET `instance_name` = 'Central' WHERE `instance_id` = '1' LIMIT 1
解决方法:
mysql> set global binlog_format=mixed; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec)