偶看新闻全球十大恐怖杀人案:mysql warning .Statement may not be safe 处理
来源：百度文库 编辑：偶看新闻 时间：2024/04/30 07:30:32
]# du -hs ./*
12G ./group
4.0K ./mysql-bin.index
23G ./error.log
110516 9:42:14 [Warning] Statement may not be safe to log in statement format. Statement: update mg_member set mem_forward_cnt = me
m_forward_cnt + '1' where mgid='330817' and uid = '1660522573' limit 1
110516 9:42:14 [Warning] Statement may not be safe to log in statement format. Statement: update mg_member set mem_last_update_time
= '1305468636' where mgid='262948' and uid = '1449685404' limit 1
mysql>update mg_member set mem_setting=3 where mgid=0 and uid=1605628815 limit 1;
Query OK, 1 row affected, 1 warning (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql>show warnings;
+-------+------+-------------------------------------------------------+
| Level | Code | Message |
+-------+------+-------------------------------------------------------+
| Note | 1592 | Statement may not be safe to log in statement format. |
+-------+------+-------------------------------------------------------+
处理：
binlog_format的设置是不是STATEMENT？改成MIXED应该就没有警告.
mysql>show variables like 'binlog_format'
可以不重启来更改binlog_format：
mysql>set global binlog_format=mixed;
若是从库好象要先slave stop; slave start;才会生效~