mysql:tx:locking
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| mysql:tx:locking [2026/05/16 08:09] – [6 Row Lock vs Table Lock] phong2018 | mysql: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. | ||
mysql/tx/locking.1778918941.txt.gz · Last modified: by phong2018