How Redisson Implements Distributed Locks: Deep Dive into Mechanisms and Pitfalls

This article explains why distributed locks are needed, outlines Redisson's lock properties, walks through its Lua‑based acquisition, renewal, and release processes, examines master‑slave pitfalls, compares RedLock with Zookeeper, and provides practical code examples for Java developers.

Lock MechanismRedlockconcurrency

0 likes · 14 min read

How Redisson Implements Distributed Locks: Deep Dive into Mechanisms and Pitfalls

Liangxu Linux

Oct 7, 2022 · Databases

Why MyISAM’s Table Locks Can Outperform InnoDB in High‑Concurrency Scenarios

This article provides a systematic deep‑dive into MySQL table‑lock mechanics, comparing storage engines, explaining the advantages of table locks, detailing lock acquisition and release rules, showing how to monitor lock statistics, and revealing why MyISAM can deliver superior performance for heavy concurrent insert and select workloads despite using only table‑level locking.

Database PerformanceLock MechanismMyISAM

0 likes · 7 min read

Why MyISAM’s Table Locks Can Outperform InnoDB in High‑Concurrency Scenarios

Full-Stack Internet Architecture

Jun 24, 2020 · Databases

Comprehensive Guide to MySQL Lock Mechanisms: Table, Row, Gap Locks and Deadlock Handling

This article provides a detailed overview of MySQL's locking mechanisms—including table, row, gap, and deadlock handling—across MyISAM and InnoDB storage engines, with practical code examples, performance considerations, and solutions for high‑concurrency scenarios.

Gap LockInnoDBLock Mechanism

0 likes · 19 min read

Comprehensive Guide to MySQL Lock Mechanisms: Table, Row, Gap Locks and Deadlock Handling