摘要: 今天生产环境遇到一个问题,如下: ERROR 1665 (HY000): Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one tabl 阅读全文
posted @ 2016-11-09 13:13 Mr.Liu08 阅读(438) 评论(0) 推荐(0) 编辑
摘要: 查看版本号 :SELECT @@version;或者status; 1.设置数据库系统的事务隔离级别 mysql> set global transaction isolation level read committed; Query OK, 0 rows affected (0.00 sec) mysql> SELECT @@global.tx_isolation; +--------... 阅读全文
posted @ 2016-11-09 10:24 Mr.Liu08 阅读(966) 评论(0) 推荐(0) 编辑