shared lock — 3 Technical Articles

Jul 16, 2023 · Databases

How Do MySQL Locks Cause Deadlocks? Real‑World Cases and Solutions

This article explains MySQL deadlocks through practical examples, covering lock types, exclusive vs. shared locks, lock‑in‑share‑mode vs. FOR UPDATE differences, real‑world deadlock scenarios, and multiple strategies—including isolation level tweaks, optimistic locking, and distributed locks—to prevent and resolve them.

LockMySQLfor update

0 likes · 19 min read

How Do MySQL Locks Cause Deadlocks? Real‑World Cases and Solutions

JavaEdge

Sep 26, 2021 · Backend Development

Understanding Java's AbstractQueuedSynchronizer: Locks, Queues, and State Management

This article explains Java's AbstractQueuedSynchronizer (AQS) framework, covering its FIFO queue mechanism, lock acquisition and release processes for exclusive and shared modes, state handling, and the abstract methods developers must implement to build custom synchronizers.

AQSJavaSynchronization

0 likes · 12 min read

Understanding Java's AbstractQueuedSynchronizer: Locks, Queues, and State Management

Architecture Talk

Sep 27, 2018 · Databases

Understanding MySQL Shared vs Exclusive Locks: A Hands‑On Demo

This article explains MySQL shared (S) and exclusive (X) row‑level locks, demonstrates their behavior with two concurrent sessions, shows how lock ordering can cause deadlocks, and provides practical tips for using InnoDB locking correctly.

DeadlockInnoDBMySQL

0 likes · 8 min read

Understanding MySQL Shared vs Exclusive Locks: A Hands‑On Demo