<p>Databases are not my main domain, but I double checked all terms. Here you go.</p>
<p><strong>Blue central box</strong></p>
<p>锁 = lock</p>
<p><strong>Green box</strong></p>
<div class="s-table-container">
<table class="s-table">
<thead>
<tr>
<th>Box</th>
<th>ZH</th>
<th>EN</th>
</tr>
</thead>
<tbody>
<tr>
<td>main</td>
<td>加锁机制</td>
<td>lock engine</td>
</tr>
<tr>
<td>upper leaf</td>
<td>乐观锁</td>
<td>optimistic lock</td>
</tr>
<tr>
<td>lower leaf</td>
<td>悲观锁</td>
<td>pessimistic lock</td>
</tr>
</tbody>
</table>
</div>
<p><strong>Purple box</strong></p>
<div class="s-table-container">
<table class="s-table">
<thead>
<tr>
<th>Box</th>
<th>ZH</th>
<th>EN</th>
</tr>
</thead>
<tbody>
<tr>
<td>main</td>
<td>兼容性</td>
<td>compatibility</td>
</tr>
<tr>
<td>upper leaf</td>
<td>共享锁</td>
<td>shared lock</td>
</tr>
<tr>
<td>lower leaf</td>
<td>排他锁</td>
<td>exclusive lock</td>
</tr>
</tbody>
</table>
</div>
<p><strong>Orange box</strong></p>
<div class="s-table-container">
<table class="s-table">
<thead>
<tr>
<th>Box</th>
<th>ZH</th>
<th>EN</th>
</tr>
</thead>
<tbody>
<tr>
<td>main</td>
<td>锁粒度</td>
<td>lock granularity</td>
</tr>
<tr>
<td>upper leaf</td>
<td>表锁</td>
<td>table lock</td>
</tr>
<tr>
<td>middle leaf</td>
<td>页锁</td>
<td>page lock</td>
</tr>
<tr>
<td>lower leaf</td>
<td>行锁</td>
<td>row lock</td>
</tr>
</tbody>
</table>
</div>
<p><strong>Yellow box</strong></p>
<div class="s-table-container">
<table class="s-table">
<thead>
<tr>
<th>Box</th>
<th>ZH</th>
<th>EN</th>
</tr>
</thead>
<tbody>
<tr>
<td>main</td>
<td>锁模式</td>
<td>lock mode</td>
</tr>
<tr>
<td>1</td>
<td>记录锁</td>
<td>record lock</td>
</tr>
<tr>
<td>2</td>
<td>gap锁</td>
<td>gap lock</td>
</tr>
<tr>
<td>3</td>
<td>next-key锁</td>
<td>next-key lock</td>
</tr>
<tr>
<td>4</td>
<td>意向锁</td>
<td>intention lock</td>
</tr>
<tr>
<td>5</td>
<td>插入意向锁</td>
<td>insert intention lock</td>
</tr>
</tbody>
</table>
</div>
CC BY-SA 4.0
2021-07-05T19:46:00.490Z
2021-07-05T20:12:33.080Z
2021-07-05T20:12:33.080Z
blackgreen
<p>I am reading a mysql article about different kind of locks and this image appeared:</p>
<p><a href="https://i.sstatic.net/dysAB.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/dysAB.png" alt="enter image description here" /></a></p>
<p>Unfortunately, I cannot copy paste the words because it's in an image. I also don't know how to reproduce this with my keyboard.</p>
<p>If anyone could kindly translate this for me, would be very kind.</p>

<translation><terminology><database>
What does this MYSQL image say? (Database Locks)
# What does this MYSQL image say? (Database Locks)

(Asked by: username_0 on 2021-07-05)

I am reading a mysql article about different kind of locks and this image appeared:

[![enter image description here](https://i.sstatic.net/dysAB.png)](https://i.sstatic.net/dysAB.png)

Unfortunately, I cannot copy paste the words because it's in an image. I also don't know how to reproduce this with my keyboard.

If anyone could kindly translate this for me, would be very kind.

**Tags:** translation, terminology, database

---

## 1 answers

### Answer by username_1 on 2021-07-05. Score: 3 | Accepted answer

Databases are not my main domain, but I double checked all terms. Here you go.

**Blue central box**

锁 = lock

**Green box**

| Box | ZH | EN |
| --- | --- | --- |
| main | 加锁机制 | lock engine |
| upper leaf | 乐观锁 | optimistic lock |
| lower leaf | 悲观锁 | pessimistic lock |

**Purple box**

| Box | ZH | EN |
| --- | --- | --- |
| main | 兼容性 | compatibility |
| upper leaf | 共享锁 | shared lock |
| lower leaf | 排他锁 | exclusive lock |

**Orange box**

| Box | ZH | EN |
| --- | --- | --- |
| main | 锁粒度 | lock granularity |
| upper leaf | 表锁 | table lock |
| middle leaf | 页锁 | page lock |
| lower leaf | 行锁 | row lock |

**Yellow box**

| Box | ZH | EN |
| --- | --- | --- |
| main | 锁模式 | lock mode |
| 1 | 记录锁 | record lock |
| 2 | gap锁 | gap lock |
| 3 | next-key锁 | next-key lock |
| 4 | 意向锁 | intention lock |
| 5 | 插入意向锁 | insert intention lock |


---

