Wiki.Quizz.vn

User Tools

Site Tools

Trace:
mysql:tx:locking

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
mysql:tx:locking [2026/05/16 08:08] – phong2018mysql:tx:locking [2026/05/16 08:09] (current) – [1 Read Lock (Shared Lock)] phong2018
Line 11: Line 11:
 ---- ----
  
-==== 1 Read Lock (Shared Lock) ====+==== 1. Read Lock (Shared Lock) ====
  
 Allows multiple transactions to read the same row at the same time, Allows multiple transactions to read the same row at the same time,
Line 213: Line 213:
 ---- ----
  
-==== 3 Lock Compatibility Matrix ====+==== 3. Lock Compatibility Matrix ====
  
 Shows whether two locks can be held simultaneously on the same row. Shows whether two locks can be held simultaneously on the same row.
Line 298: Line 298:
 ---- ----
  
-==== 6 Row Lock vs Table Lock ====+==== 6. Row Lock vs Table Lock ====
  
 ^ Feature            ^ Row Lock (FOR UPDATE / FOR SHARE) ^ Table Lock ^ ^ Feature            ^ Row Lock (FOR UPDATE / FOR SHARE) ^ Table Lock ^
mysql/tx/locking.1778918885.txt.gz · Last modified: by phong2018