![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
![MySQL Concurrency: Locking and Transactions for MySQL Developers and DBAs: 9781484266519: Computer Science Books @ Amazon.com MySQL Concurrency: Locking and Transactions for MySQL Developers and DBAs: 9781484266519: Computer Science Books @ Amazon.com](https://m.media-amazon.com/images/I/613N-LDxg2L._AC_UF1000,1000_QL80_.jpg)
MySQL Concurrency: Locking and Transactions for MySQL Developers and DBAs: 9781484266519: Computer Science Books @ Amazon.com
![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
![process - What is "Field List" command in mysql processlist? - Database Administrators Stack Exchange process - What is "Field List" command in mysql processlist? - Database Administrators Stack Exchange](https://i.stack.imgur.com/OhSjx.png)
process - What is "Field List" command in mysql processlist? - Database Administrators Stack Exchange
![How does database pessimistic locking interact with INSERT, UPDATE, and DELETE SQL statements - Vlad Mihalcea How does database pessimistic locking interact with INSERT, UPDATE, and DELETE SQL statements - Vlad Mihalcea](https://vladmihalcea.com/wp-content/uploads/2017/02/predicatelockinsertmysql1.png)