在需要多个锁时，使用分层方式。

Use a layered approach when multiple locks are needed.

youdao

使用悲观会话锁时还需注意一些问题

There are also several issues to be aware of with pessimistic session locks

youdao

当获得少量的行锁时，行锁就会自动地逐渐升级为表锁。

After some small number of row locks are obtained, a lock escalation to a table lock will occur automatically.

youdao

What does that say about your thinking about ? your fellow citizens when you arm yourselves going for a trip, of his fellow citizens ? when he locks his doors at night or of his children ? and servants when he locks his chests?

你们觉得你的同胞对你,带着武器骑行有什么看法,把门闩起来的时候,对同胞们是什么看法,把箱子锁起来时对自己的子女仆人是什么看法？

耶鲁公开课 - 政治哲学导论课程节选