Pessimistic Locking - Definição do Glossário CI/CD
O pessimistic locking adquire um lock (por exemplo, SELECT ... FOR UPDATE) antes de modificar dados, bloqueando transações concorrentes até o commit. Ele evita conflitos, mas pode causar contenção e deadlocks.
Guias relacionados
Optimistic Locking - CI/CD Glossary DefinitionOptimistic locking lets transactions proceed without locks and checks a version column at commit, retrying if…
Transaction Isolation - CI/CD Glossary DefinitionTransaction isolation defines how concurrent transactions see each other’s uncommitted work, from read-uncomm…
ACID - CI/CD Glossary DefinitionACID - atomicity, consistency, isolation, durability - are the four guarantees a transactional database makes…