mysql行锁实现_数据库行锁实现

https://dev.mysql.com/doc/refman/5.7/en/innodb-locking-reads.html

有两种模式：

读数据时，其他事务也能读，但不能修改。如果在修改数据，其他事务则不能读取。

Sets a shared mode lock on any rows that are read. Other sessions can read the rows, but cannot modify them until your transaction commits. If any of these rows were changed by another transaction that has not yet committed, your query waits until that transaction ends and then uses the latest values.

锁定所有相关实体，如同对这些实体提交UPDATE，其他事务从读取数据就开始被阻塞。

For index records the search encounters, locks the rows and any associated index entries, the same as if you issued an UPDATE statement for those rows. Other transactions are blocked from updating those rows, from doing SELECT ... LOCK IN SHARE MODE, or from reading the data in certain transaction isolation levels. Consistent reads ignore any locks set on the records that exist in the read view. (Old versions of a reco