mysql修改log_bin_MySQL在线更改binlog格式

今天变更jboss报错如下：

SQLWarning ignored: SQL state 'HY000', error code '1592', message [Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave.]

提示：警告，从另一个表中选择一个具有自动增量列的表的语句是不安全的，因为检索行的顺序决定了将写入哪些行(如果有的话)。这个命令是无法预测的，会使主从的数据不一致。

于是修改主库和从库的binglog格式由statement改为ROW格式。

方法：

1、先修改从库

mysql> show global variables like "binlog%";+-----------------------------------------+--------------+

| Variable_name | Value |

+-----------------------------------------+--------------+

| binlog_cache_