Tagged articles

Database Deadlock

6 articles · Page 1 of 1
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Sep 4, 2025 · Backend Development

How to Prevent and Handle Database Deadlocks in Spring Boot 3

Learn how Spring Boot 3 handles database deadlocks by exploring transaction isolation levels, optimistic and pessimistic locking, and practical code examples that show prevention, detection, and retry strategies to keep your applications reliable under high concurrency.

Database DeadlockTransaction Isolationoptimistic lock
0 likes · 12 min read
How to Prevent and Handle Database Deadlocks in Spring Boot 3
DevOps
DevOps
Feb 10, 2022 · Operations

Eight Real-World Online Failure Cases and Their Resolution Strategies

The article presents eight authentic production incidents—including JVM Full GC, memory leaks, idempotency flaws, cache avalanches, disk‑I/O thread blocking, MySQL deadlocks, DNS hijacking, and bandwidth exhaustion—detailing their causes, diagnostics, and practical remediation steps for engineers.

Bandwidth ExhaustionCache AvalancheDNS hijacking
0 likes · 15 min read
Eight Real-World Online Failure Cases and Their Resolution Strategies
Architect's Journey
Architect's Journey
Jan 5, 2022 · Backend Development

Why @Transactional Can Trigger Production Outages: Lessons from a Long‑Transaction Failure

The author recounts a real‑world incident where a Spring @Transactional annotation caused database connection exhaustion, deadlocks, and a production outage, explains how long‑running transactions arise from holding a single connection during costly operations, and offers practical ways to avoid them by splitting methods or using programmatic transactions.

@TransactionalDatabase DeadlockJava
0 likes · 10 min read
Why @Transactional Can Trigger Production Outages: Lessons from a Long‑Transaction Failure
dbaplus Community
dbaplus Community
Jan 21, 2021 · Operations

7 Real‑World Production Failures and How to Diagnose Them Quickly

The article shares eight concrete production incidents—from JVM Full GC spikes and memory leaks to cache avalanches, deadlocks, DNS hijacking and bandwidth exhaustion—detailing their root causes, step‑by‑step diagnostics, code snippets, monitoring tricks and practical remediation measures for engineers.

Cache AvalancheDatabase DeadlockJVM
0 likes · 18 min read
7 Real‑World Production Failures and How to Diagnose Them Quickly
dbaplus Community
dbaplus Community
Aug 11, 2020 · Operations

7 Real-World Production Failures and Fast Diagnosis Techniques

The article shares seven authentic production incident cases—from JVM Full GC spikes and memory leaks to cache avalanches, disk I/O blocks, database deadlocks, DNS hijacking, and bandwidth exhaustion—detailing root causes, step‑by‑step troubleshooting methods, code snippets, and practical mitigation strategies for engineers.

Cache AvalancheDNS hijackingDatabase Deadlock
0 likes · 17 min read
7 Real-World Production Failures and Fast Diagnosis Techniques
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Oct 24, 2016 · Backend Development

How to Fix Common Java Backend Performance Pitfalls: Deadlocks, Thread Pools, and Logging

This article examines typical Java backend performance problems such as database deadlocks, overly long transactions, thread‑pool misuse, and excessive logging, and provides concrete optimization strategies—including Redis distributed locks, short‑lived transactions, proper thread‑pool configuration, and disciplined log formatting—to dramatically improve throughput and stability.

Backend DevelopmentDatabase Deadlockthread pool
0 likes · 11 min read
How to Fix Common Java Backend Performance Pitfalls: Deadlocks, Thread Pools, and Logging