![MySQL 8.0 Metadata Lock Extension for Foreign Keys causing requests to hang - Database Administrators Stack Exchange MySQL 8.0 Metadata Lock Extension for Foreign Keys causing requests to hang - Database Administrators Stack Exchange](https://i.stack.imgur.com/Civ4i.png)
MySQL 8.0 Metadata Lock Extension for Foreign Keys causing requests to hang - Database Administrators Stack Exchange
![mysql - why i can have two locks( X and S) on one record in innodb? i know that S and X lock can not exists at the same time - Stack Overflow mysql - why i can have two locks( X and S) on one record in innodb? i know that S and X lock can not exists at the same time - Stack Overflow](https://i.stack.imgur.com/H69iA.png)
mysql - why i can have two locks( X and S) on one record in innodb? i know that S and X lock can not exists at the same time - Stack Overflow
![21 - Shared and Exclusive Locks | InnoDB Locking | MySQL DBA Tutorial | MySQL 8 DBA Tutorial - YouTube 21 - Shared and Exclusive Locks | InnoDB Locking | MySQL DBA Tutorial | MySQL 8 DBA Tutorial - YouTube](https://i.ytimg.com/vi/uc0SqX2QbCc/mqdefault.jpg)