L
Jul 7, 2026Lock Manager — Lock Overview
Lock trong Postgres: hai tầng heavyweight/lightweight, vì sao một ALTER đứng yên kéo theo cả...
Jul 7, 202613 min read0 reactions0 comments
Back to articles 
Feb 14, 2026
Jan 11, 2026
Feb 11, 2023
Tag archive
#locking
L
Jul 7, 2026Lock Monitoring — Production Lock Analysis
Production lock analysis: vì sao pg_stat_activity một mình không đủ, và join với pg_locks...
Jul 7, 202614 min read0 reactions0 comments
R
Jul 7, 2026Row Lock — FOR UPDATE
FOR UPDATE: pessimistic row lock để chặn lost update, và cái giá deadlock khi không lock...
Jul 7, 202614 min read0 reactions0 comments
D
Jul 7, 2026Deadlock — Deadlock Detection
Deadlock detection: vì sao Postgres chỉ dò cycle sau deadlock_timeout, và vì sao retry mù...
Jul 7, 202616 min read0 reactions0 comments
T
Jul 7, 2026Table Lock — DDL Lock
DDL lock: vì sao một ALTER TABLE 50ms vẫn đủ làm sập cả API trong giờ cao điểm DDL trong...
Jul 7, 202612 min read0 reactions0 comments
U
Jul 15, 2026Understanding Database Locking in Ruby on Rails: Types, Examples, and Best Practices
Goal of this article: Build a strong foundation before learning pessimistic locking, optimistic...
Jul 15, 20263 min read0 reactions0 comments
D
May 15, 2026Distributed Lock Alternatives: 3 Methods Every System Architect
When building distributed systems or breaking down an existing monolithic system, managing...
May 15, 20269 min read0 reactions0 comments
H
May 2, 2026How to Implement Distributed Locking with Redis 8 and Go 1.23 for Microservices
How to Implement Distributed Locking with Redis 8 and Go 1.23 for...
May 2, 20265 min read0 reactions0 comments
P
Mar 3, 2026Preventing Redundant Cron Job Executions in Multi-Instance Node.js Environments with Locking Mechanisms
Introduction: The Cron Job Conundrum Imagine a well-oiled machine, humming along in your...
Mar 3, 202612 min read0 reactions0 comments
Week 1 — When LLM Failures Weren’t About Load, But Timing (ZooKeeper + Distributed Locking)
This post starts a weekly series where I’ll be writing about practical things I’ve learned while...
Feb 14, 20263 min read1 reactions0 comments
Ticket Booking System (BookMyShow) High-level System Design
High-Level Design: Ticket Booking System (BookMyShow) Table of...
Jan 11, 202658 min read0 reactions0 comments
Introduction to Multithreading in Python
Multithreading is a process of executing multiple threads (small units of a program) concurrently...
Feb 11, 20232 min read3 reactions1 comments