Скачать или смотреть "Row-Level Locking in MySQL"

Multiple transactions can access and edit various rows in a table at the same time in MySQL thanks to a system called row-level locking that prevents them from blocking one another. This implies that multiple transactions can operate on different rows in the same table concurrently while one transaction is working on a particular row. Row-level locking has some negotiations but can reduce competition for resources and increase concurrency.

One useful example of row-level locking in MySQL is when several transactions are accessing and changing a table's rows at the same time. In this example, we will use two MySQL client connections to simulate concurrent transactions by creating a basic table. To obtain an exclusive lock on particular rows, we shall employ the SELECT... FOR UPDATE command.