Pessimistic Lock, Optimistic Lock, and In-Memory Pessimistic Lock

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 悲观锁乐观锁内存悲观锁

| username: 小于同学

Have you ever used pessimistic locks and optimistic locks in practice?

| username: zhaokede | Original post link

No, we generally use pessimistic locking.

| username: DBAER | Original post link

Higher versions only support in-memory pessimistic locks, so business retries need to be added.

| username: kkpeter | Original post link

Default pessimistic lock

| username: zhanggame1 | Original post link

The default pessimistic lock and optimistic lock were from earlier versions, and now they can be considered as non-existent.

| username: TiDBer_QYr0vohO | Original post link

The default is to use pessimistic locking.

| username: linnana | Original post link

It is generally recommended to use pessimistic locking.

| username: 呢莫不爱吃鱼 | Original post link

The default is a pessimistic lock.

| username: 健康的腰间盘 | Original post link

By default, it’s pessimistic. If needed for business, you can try modifying the session or global settings to see if it works.

| username: zhh_912 | Original post link

By default, it’s all pessimistic, right?

| username: TiDBer_rvITcue9 | Original post link

The current environment is most suitable for pessimistic locking.