Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Pessimistic lock, the concept of optimistic lock

2025-03-29 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Pessimistic lock: as the name implies, it is very pessimistic, it refers to the data by the outside world (including other current transactions of the system

As well as from other transactions, as well as transactions from external systems) modifications are conservative, so the data is locked throughout the data processing. Pessimistic lock implementation often depends on the locking mechanism provided by the database. Typical is the FOR UPDATE statement.

Optimistic locking: compared with pessimistic locking, optimistic locking mechanism adopts a more relaxed locking mechanism.

Every time I go to get the data, I think that others will not change it, so it will not be locked, but when I update it, I will judge whether others have updated the data during the period. We can use mechanisms such as version number.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report