![MySQL engine features - about InnoDB transaction locks (3) - Alibaba Cloud Developer Forums: Cloud Discussion Forums MySQL engine features - about InnoDB transaction locks (3) - Alibaba Cloud Developer Forums: Cloud Discussion Forums](https://intl.aliyun.com/forum/attachment/1611/thread/21_634_141deeb0748c6e3.png)
MySQL engine features - about InnoDB transaction locks (3) - Alibaba Cloud Developer Forums: Cloud Discussion Forums
![sql update - MySQL updating data by non-primary indexed column requires primary index locks on irrelevant record - Stack Overflow sql update - MySQL updating data by non-primary indexed column requires primary index locks on irrelevant record - Stack Overflow](https://i.stack.imgur.com/1M9wE.png)
sql update - MySQL updating data by non-primary indexed column requires primary index locks on irrelevant record - Stack Overflow
![sql update - MySQL updating data by non-primary indexed column requires primary index locks on irrelevant record - Stack Overflow sql update - MySQL updating data by non-primary indexed column requires primary index locks on irrelevant record - Stack Overflow](https://i.stack.imgur.com/ZMAEk.png)
sql update - MySQL updating data by non-primary indexed column requires primary index locks on irrelevant record - Stack Overflow
![Chasing a Hung MySQL Transaction: InnoDB History Length Strikes Back - Percona Database Performance Blog Chasing a Hung MySQL Transaction: InnoDB History Length Strikes Back - Percona Database Performance Blog](https://www.percona.com/blog/wp-content/uploads/2017/05/innodb_history_length.png)