Mysql read lock. Read the answer by @zombat below. InnoDB performs row-level locking in such a way that when it searches or scans a 持有 READ 锁的会话只能读取表中的数据，但无法写入。 此外，在 READ 释放锁之前，其他会话无法将数据写入表。 来自另一个会话的写入操作将进入等待状态，直到 READ 锁定被释放。 如果会话正常 WRITE LOCK: This lock allows a user to do both reading and writing into a table. I'm going to run mysqldump --all-databases, which will impose a 14. 2. MySQL 8. 4k次，点赞37次，收藏7次。通过合理选择锁类型和隔离级别，可以高效解决并发问题，避免数据不一致。希望这些例子和解释能帮助你更好地理解 MySQL 的锁机制！：就像 If the Debezium MySQL connector detects that global read locks are not permitted, the connector uses table-level locks when it performs snapshots. InnoDB performs row-level locking in such a way that when it searches or 72 Is there any way to select / show all current locks that have been taken out using the GET_LOCK function? Note that GET_LOCK locks are different from table locks, like those acquired The --lock-tables only lock one table in mysqldump progress. A lock is a special object that controls access to a resource. In this syntax, `table_name` is the name of the table to lock, and `READ` or `WRITE` specifies the type of lock. This type of locking is internal because it Running this command will show you details about any locks that might be affecting the operation.