Shulou(Shulou.com)05/31 Report--

Editor to share with you Percona MySQL 5.6 sentence lock error report "ERROR 1665 (HY000): Cannot execute statement" how to do, I hope you will learn something after reading this article, let's discuss it together!

Mysql > select * from tab_with_index where id=1 for update

ERROR 1665 (HY000): Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited

To row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.

Mysql > show variables like'% bin%format%'

+-+ +

| | Variable_name | Value |

+-+ +

| | binlog_format | STATEMENT |

+-+ +

1 row in set (0.00 sec)

Mysql > show variables like'% isolation%'

+-+ +

| | Variable_name | Value |

+-+ +

| | tx_isolation | READ-COMMITTED |

+-+ +

1 row in set (0.00 sec)

Solution:

Change the format of the log

Mysql > set global binlog_format='mixed'

Query OK, 0 rows affected (0.00 sec)

Mysql > exit

Mysql > show variables like'% bin%format%'

+-+ +

| | Variable_name | Value |

+-+ +

| | binlog_format | MIXED |

+-+ +

1 row in set (0.00 sec)

Mysql > select * from tab_with_index where id=1 for update

+-+ +

| | id | name |

+-+ +

| | 1 | 1 |

| | 1 | 4 |

+-+ +

2 rows in set (0.00 sec)

After reading this article, I believe you have a certain understanding of "Percona MySQL 5.6Lock error report" ERROR 1665 (HY000): Cannot execute statement "what to do". If you want to know more about it, welcome to follow the industry information channel, thank you for your reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.