MySQL升5.6引發的問題

標籤：style   blog   http   color   io   ar   for   資料   2014   

昨天項目MySQL資料庫從5.5升級到5.6，導致部分表無法進行更新操作，報如下錯誤：

When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.

MySQL官方給出的解決辦法：

“updates to tables using nontransactional storage engines such as MyISAM cannot be made in the same statement or transaction as updates to tables using transactional storage engines such as InnoDB.” 

https://dev.mysql.com/doc/refman/5.6/en/replication-gtids-restrictions.html

參考文章：

http://blog.webyog.com/2014/05/12/suddenly-myisam-became-transaction-aware

MySQL升5.6引發的問題