Shulou(Shulou.com)06/01 Report--

What if the mysql update fails? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

The solution to the failure of mysql update is to open the command window first, and then solve it by executing the "select * from information_schema.innodb_trx kill 15758" statement.

Mysql update error

Today, when I was at work, I found that a field in a update table timed out. I thought about it for a long time. The first thing I thought of was to extend the operation time:

Mysql > set innodb_lock_wait_timeout=100mysql > show variables like 'innodb_lock_wait_timeout'

However, although the time has been extended, the problem has not been solved. I looked around on the Internet and found that it may be that the mysql transaction was not committed, resulting in locking the table. the solution is as follows:

Select * from information_schema.innodb_trxkill 15758

Of which 15758 is the id of thread

Thank you for reading! After reading the above, do you have a general idea of what to do if the mysql update fails? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

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.