BestHub
Sign in
Tagged articles
158 articles
Page 1 of 2
MaGe Linux Operations
MaGe Linux Operations
Apr 1, 2026 · Databases

Master PostgreSQL 17 Locks: From Fundamentals to Advanced Monitoring & Optimization

This comprehensive guide explores PostgreSQL 17's lock mechanisms, covering lock classifications, table‑ and row‑level lock behavior, MVCC interaction, common pitfalls such as deadlocks and lock contention, and provides practical SQL queries, Bash monitoring scripts, advisory‑lock techniques, and best‑practice recommendations for performance tuning and reliable production deployment.

AdvisoryLocksLocksMVCC
0 likes · 36 min read
Master PostgreSQL 17 Locks: From Fundamentals to Advanced Monitoring & Optimization
dbaplus Community
dbaplus Community
Feb 27, 2026 · Databases

Understanding MySQL Locks: From Global to Row‑Level and Deadlock Prevention

The article explains why concurrent transactions cause data inconsistencies, describes MySQL’s lock hierarchy—including global, table, and row locks—covers AUTO_INCREMENT locking, illustrates lock compatibility tables, details common deadlock scenarios, and offers practical strategies such as fixed access order, optimistic locking, short transactions, proper indexing, and isolation‑level tuning to prevent deadlocks.

InnoDBLocksconcurrency
0 likes · 18 min read
Understanding MySQL Locks: From Global to Row‑Level and Deadlock Prevention
Code Wrench
Code Wrench
Dec 13, 2025 · Databases

Mastering Database Internals for Go Interviews: Indexes, Transactions, Locks, MVCC & Connection Pools

This article equips Go backend developers with deep, interview‑ready knowledge of database internals—covering how indexes truly work, why queries can still be slow, transaction isolation levels, lock types, MVCC mechanics, and connection‑pool tuning—to avoid performance pitfalls and stand out in technical interviews.

Connection PoolGoLocks
0 likes · 12 min read
Mastering Database Internals for Go Interviews: Indexes, Transactions, Locks, MVCC & Connection Pools
Senior Brother's Insights
Senior Brother's Insights
Oct 31, 2025 · Databases

Master MySQL Transactions: ACID, Locks, and Practical Examples

This article explains what database transactions are, why they matter, details MySQL’s transaction commands, the ACID properties, isolation levels, lock types, MVCC, how to use InnoDB, handle errors, employ savepoints, and provides concrete SQL examples for creating, committing, rolling back, and managing transactions.

ACIDDatabase TransactionsError Handling
0 likes · 12 min read
Master MySQL Transactions: ACID, Locks, and Practical Examples
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Oct 18, 2025 · Backend Development

Master Java Concurrency: Choose ReentrantLock, ReadWriteLock, StampedLock, or Semaphore

This article explores Java’s advanced lock mechanisms—ReentrantLock, ReentrantReadWriteLock, StampedLock, and Semaphore—detailing their core features, practical code examples, and ideal usage scenarios, helping developers decide which synchronization tool best fits their performance and concurrency requirements.

JavaLocksReadWriteLock
0 likes · 9 min read
Master Java Concurrency: Choose ReentrantLock, ReadWriteLock, StampedLock, or Semaphore
Sohu Smart Platform Tech Team
Sohu Smart Platform Tech Team
Aug 9, 2025 · Mobile Development

Mastering iOS Locks: From Spin Locks to Semaphores Explained

This article explains the purpose, actions, and common types of locks in iOS—including spin locks, mutexes, semaphores, and read‑write locks—provides practical code examples, discusses underlying principles such as busy‑waiting and priority inversion, and compares performance across different lock implementations.

LocksSynchronizationiOS
0 likes · 18 min read
Mastering iOS Locks: From Spin Locks to Semaphores Explained
Sohu Tech Products
Sohu Tech Products
Jul 23, 2025 · Mobile Development

Mastering iOS Locks: From NSLock to os_unfair_lock and Performance Tips

This article explains the relationship between locks and multithreading on iOS, introduces various lock types such as NSRecursiveLock, NSConditionLock, OSSpinLock, os_unfair_lock, pthread_mutex, and @synchronized, demonstrates resource contention with code examples, and compares their performance and usage scenarios.

LocksObjective‑CiOS
0 likes · 21 min read
Mastering iOS Locks: From NSLock to os_unfair_lock and Performance Tips
Architect's Guide
Architect's Guide
Jun 27, 2025 · Backend Development

Demystifying Java Locks: From Pessimistic vs Optimistic to ReentrantLock Internals

This article explains the classification of Java locks—including pessimistic, optimistic, fair, and unfair variants—details their state transitions from biased to heavyweight, and walks through the source code of ReentrantLock and Condition to illustrate how synchronization, queuing, and thread parking are implemented in the JVM.

AQSConditionLocks
0 likes · 20 min read
Demystifying Java Locks: From Pessimistic vs Optimistic to ReentrantLock Internals
Sohu Tech Products
Sohu Tech Products
Jun 11, 2025 · Fundamentals

Mastering iOS Locks: Types, Usage, and Performance Comparison

This article explains the relationship between locks and multithreading on iOS, introduces common lock types such as NSRecursiveLock, NSConditionLock, OSSpinLock, os_unfair_lock, pthread_mutex, and @synchronized, demonstrates resource contention with code examples, discusses lock selection, priority inversion, and provides a performance ranking of various locks.

LocksObjective‑CiOS
0 likes · 22 min read
Mastering iOS Locks: Types, Usage, and Performance Comparison
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Jun 4, 2025 · Backend Development

Understanding Java Locks, synchronized, ReentrantLock, and Kotlin Coroutine Synchronization

This article explains Java's lock mechanisms—including synchronized, ReentrantLock, and their JVM implementations—covers lock classifications, memory barriers, CAS, and compares them with Kotlin coroutine synchronization tools like Mutex, providing code examples and practical guidance for safe concurrent programming.

CoroutinesJVMJava
0 likes · 22 min read
Understanding Java Locks, synchronized, ReentrantLock, and Kotlin Coroutine Synchronization
Cognitive Technology Team
Cognitive Technology Team
May 6, 2025 · Backend Development

Understanding Java's AbstractQueuedSynchronizer (AQS): Core Components, Design, and Practical Applications

AbstractQueuedSynchronizer (AQS) is the core framework for building Java locks and synchronizers, providing state management, FIFO queuing, and blocking/unblocking mechanisms; this article explains its components, design patterns, thread safety operations, and real-world implementations such as ReentrantLock and Semaphore, with code examples.

AQSJavaLocks
0 likes · 11 min read
Understanding Java's AbstractQueuedSynchronizer (AQS): Core Components, Design, and Practical Applications
Sohu Tech Products
Sohu Tech Products
Apr 29, 2025 · Backend Development

Mastering Java Concurrency: Deep Dive into Threads, Locks, and AQS

This comprehensive guide explores Java multithreading fundamentals, covering thread creation, lifecycle, synchronization challenges, context switching costs, deadlock detection, various lock mechanisms such as synchronized, ReentrantLock, ReadWriteLock, and the underlying AbstractQueuedSynchronizer architecture with practical code examples and performance tips.

AQSConditionJava
0 likes · 42 min read
Mastering Java Concurrency: Deep Dive into Threads, Locks, and AQS
macrozheng
macrozheng
Feb 20, 2025 · Backend Development

Master Java Concurrency & SpringBoot: DJI Interview Insights & Advanced Locks

This article combines a DJI interview experience—including salary and bonus details—with an in‑depth guide to Java concurrency tools, lock implementations, SpringBoot AOP, filters vs. interceptors, Kafka ordering, zero‑copy techniques, and related backend development best practices.

Backend DevelopmentKafkaLocks
0 likes · 26 min read
Master Java Concurrency & SpringBoot: DJI Interview Insights & Advanced Locks
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 27, 2024 · Databases

Summary of InnoDB Lock Module Articles

This article provides a concise English recap of the 27 previously published InnoDB lock module articles, covering theoretical concepts such as table and row locks, lock waiting, deadlock handling, and practical scenarios like lock behavior during inserts and duplicate key operations.

Database InternalsInnoDBLocks
0 likes · 6 min read
Summary of InnoDB Lock Module Articles
Su San Talks Tech
Su San Talks Tech
Nov 3, 2024 · Backend Development

Mastering Java Locks: From Optimistic to Biased – A Complete Guide

This article offers a comprehensive overview of Java's lock mechanisms, detailing each lock type, its underlying principle, typical use cases, differences between synchronized and Lock, and practical code examples for implementing read‑write locks and optimizing concurrency.

JavaLocksSynchronization
0 likes · 19 min read
Mastering Java Locks: From Optimistic to Biased – A Complete Guide
Sanyou's Java Diary
Sanyou's Java Diary
Oct 14, 2024 · Fundamentals

Unlocking Java’s AQS: How AbstractQueuedSynchronizer Powers Locks and Synchronizers

This article explains Java's AbstractQueuedSynchronizer (AQS) framework, detailing its FIFO queue, state handling, entry‑wait queue, exclusive and shared lock acquisition, condition‑variable queues, and how core concurrency utilities like ReentrantLock, ReadWriteLock, CountDownLatch, Semaphore, and ThreadPoolExecutor are built on it.

AQSLocksSynchronization
0 likes · 31 min read
Unlocking Java’s AQS: How AbstractQueuedSynchronizer Powers Locks and Synchronizers
Qunar Tech Salon
Qunar Tech Salon
Oct 10, 2024 · Operations

Design and Architecture of a Distributed Task Scheduling System for Database Automation

This document outlines the terminology, background, requirements, task classifications, state model, and detailed architecture—including TaskScheduler, TaskWorker, and TaskConsole components—of a new distributed task scheduling system designed to replace Celery in a database automation platform, with emphasis on scalability, reliability, and extensibility.

Distributed SystemsLocksOperations
0 likes · 23 min read
Design and Architecture of a Distributed Task Scheduling System for Database Automation
Liangxu Linux
Liangxu Linux
May 19, 2024 · Fundamentals

Mastering Thread Safety: Turn Multithreaded Code into a Well‑Behaved Cat

This article explains why multithreaded programs often feel like untamable beasts, introduces the core concept of thread safety, distinguishes private and shared resources, shows concrete C/C++ examples of safe and unsafe patterns, and outlines practical techniques such as thread‑local storage, read‑only globals, atomic operations and synchronization to write reliable concurrent code.

C++Locksmultithreading
0 likes · 15 min read
Mastering Thread Safety: Turn Multithreaded Code into a Well‑Behaved Cat
Architect
Architect
Mar 31, 2024 · Backend Development

Common Lock Types in Distributed Systems and Their Java Implementations

This article explains the main lock mechanisms used in concurrent and distributed Java applications—including pessimistic, optimistic, distributed, reentrant, spin, shared, read/write, fair, non‑fair, interruptible, segment, and lock‑upgrade techniques—along with their characteristics, usage scenarios, and sample SQL or Java code snippets.

JavaLocksSynchronization
0 likes · 16 min read
Common Lock Types in Distributed Systems and Their Java Implementations
Su San Talks Tech
Su San Talks Tech
Mar 7, 2024 · Databases

Master MySQL Locks: Types, Mechanisms, and How to Avoid Deadlocks

This article explains why MySQL uses locks, categorizes lock types from global to row level, details their implementation and commands, and shows how intention, metadata, and auto‑increment locks work while offering strategies to prevent deadlocks and lock contention.

InnoDBLocksauto_increment
0 likes · 13 min read
Master MySQL Locks: Types, Mechanisms, and How to Avoid Deadlocks
Tencent Cloud Developer
Tencent Cloud Developer
Feb 22, 2024 · Databases

MongoDB Lock Mechanisms and Implementation Details

MongoDB’s locking system uses a hierarchical resource model with four lock modes, RAII‑style acquisition classes, ticket‑based throttling, and a bucketed lock manager that employs bit‑mask conflict checks and priority flags to grant exclusive locks promptly and prevent starvation.

Lock ManagerLocksRAII
0 likes · 42 min read
MongoDB Lock Mechanisms and Implementation Details
政采云技术
政采云技术
Dec 14, 2023 · Databases

Understanding MySQL Locks: Types, Mechanisms, and Deadlock Resolution

This article explains the various lock types in MySQL—including global, table, row, metadata, and intent locks—how they work under InnoDB, demonstrates lock acquisition with SQL examples, and provides practical guidance for detecting and resolving deadlocks in production environments.

InnoDBLocksdatabase
0 likes · 17 min read
Understanding MySQL Locks: Types, Mechanisms, and Deadlock Resolution
JD Tech
JD Tech
Nov 13, 2023 · Databases

Analysis of MySQL Lock Mechanisms and Deadlock Scenarios

This article examines MySQL's various lock types—including shared, exclusive, gap, next‑key, and insert‑intention locks—illustrates how they interact during concurrent transactions, analyzes a real‑world deadlock incident, and provides recommendations for preventing similar concurrency issues in high‑traffic systems.

Locksconcurrencymysql
0 likes · 19 min read
Analysis of MySQL Lock Mechanisms and Deadlock Scenarios
dbaplus Community
dbaplus Community
Nov 9, 2023 · Fundamentals

Mastering Java Locks: From Pessimistic to Distributed and Optimizations

This article explains the full spectrum of Java locking mechanisms—including pessimistic, optimistic, distributed, reentrant, spin, read/write, fair vs. non‑fair, JVM lock states, and optimization techniques—detailing their principles, use‑cases, SQL/Redis examples, and performance trade‑offs.

Distributed SystemsJVMLocks
0 likes · 16 min read
Mastering Java Locks: From Pessimistic to Distributed and Optimizations
ITPUB
ITPUB
Nov 9, 2023 · Databases

Understanding MySQL Locks: When to Use Them, How They Work, and When to Avoid Them

This article explains the fundamentals of MySQL locking—including explicit and implicit locks, transaction isolation levels, next‑key and gap locks, and practical session‑based examples—so developers can decide when to apply pessimistic locks and when to prefer safer alternatives.

Database PerformanceInnoDBLocks
0 likes · 17 min read
Understanding MySQL Locks: When to Use Them, How They Work, and When to Avoid Them
Senior Tony
Senior Tony
Nov 8, 2023 · Databases

Beyond Row and Table Locks: Uncovering MySQL’s Hidden Lock Types

This article examines MySQL's comprehensive lock taxonomy, starting from common row and table locks, then delving into lesser‑known mechanisms such as global locks, intention locks, auto‑increment locks, and Latch, while explaining their commands, use‑cases, and performance implications for developers and DBAs.

InnoDBLocksauto_increment
0 likes · 10 min read
Beyond Row and Table Locks: Uncovering MySQL’s Hidden Lock Types
Architecture & Thinking
Architecture & Thinking
Nov 7, 2023 · Databases

How MySQL InnoDB Achieves High Concurrency with MVCC and Locks

This article explains MySQL InnoDB's concurrency control mechanisms—including read‑write locks, transaction isolation levels, MVCC, redo/undo logs, and rollback segments—and shows how they work together to ensure data consistency while maximizing read/write performance in high‑traffic environments.

Concurrency ControlInnoDBLocks
0 likes · 12 min read
How MySQL InnoDB Achieves High Concurrency with MVCC and Locks
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Nov 4, 2023 · Databases

Understanding MySQL Lock Types: Shared, Exclusive, Intention, Gap, Next‑Key, and Insert‑Intention Locks with Deadlock Analysis

This article explains MySQL's various lock mechanisms—including shared (S) and exclusive (X) locks, intention locks, record, gap, next‑key, and insert‑intention locks—illustrates their behavior with SQL examples, analyzes a concurrent insert deadlock scenario, and offers practical mitigation strategies.

InnoDBLocksdatabase
0 likes · 11 min read
Understanding MySQL Lock Types: Shared, Exclusive, Intention, Gap, Next‑Key, and Insert‑Intention Locks with Deadlock Analysis
FunTester
FunTester
Oct 26, 2023 · Fundamentals

Mastering Java Locks: Reentrant, Synchronized, ReadWrite, and Spin Locks Explained

This article provides a comprehensive guide to Java locking mechanisms, covering ReentrantLock, synchronized, ReadWriteLock, and spin locks, with detailed code examples, performance considerations, common use cases, and best practices to ensure thread safety, avoid deadlocks, and optimize concurrency in multithreaded applications.

JavaLocksReadWriteLock
0 likes · 17 min read
Mastering Java Locks: Reentrant, Synchronized, ReadWrite, and Spin Locks Explained
dbaplus Community
dbaplus Community
Sep 27, 2023 · Databases

Understanding MySQL Locks: Which Queries Actually Acquire Locks?

This article breaks down MySQL's complex locking mechanisms—global, table, and row locks—explaining how different SELECT statements, transaction isolation levels, and index types affect lock acquisition, and provides practical test scripts and visual examples to help developers master lock behavior.

InnoDBIsolationLevelLocks
0 likes · 14 min read
Understanding MySQL Locks: Which Queries Actually Acquire Locks?
JD Cloud Developers
JD Cloud Developers
Aug 24, 2023 · Backend Development

Mastering Java Locks: From ReentrantLock to Distributed Redisson & Zookeeper

This article explains the fundamentals and practical usage of various Java locking mechanisms—including ReentrantLock, synchronized, ReentrantReadWriteLock, and the Atomic and Concurrent families—then explores distributed lock solutions such as Redisson’s multiple lock types and Zookeeper/Curator, comparing their performance, consistency, and suitability for different scenarios.

Distributed SystemsJavaLocks
0 likes · 22 min read
Mastering Java Locks: From ReentrantLock to Distributed Redisson & Zookeeper
Selected Java Interview Questions
Selected Java Interview Questions
Aug 11, 2023 · Databases

Introduction to MySQL Locks and Their Types

This article explains the purpose, classification, and implementation of MySQL locks—including global, table, page, row, intention, and gap/record/next-key locks—as well as optimistic and pessimistic locking strategies, providing code examples and usage scenarios for ensuring data consistency in concurrent transactions.

InnoDBIsolationLocks
0 likes · 11 min read
Introduction to MySQL Locks and Their Types
政采云技术
政采云技术
Mar 28, 2023 · Databases

Understanding MVCC and Lock Mechanisms in MySQL

This article explains why MySQL uses MVCC, how undo‑log version chains and read views implement multi‑version concurrency control, and details the various lock types—including global, table, metadata, intention, row, gap, and next‑key locks—under different isolation levels with practical code examples.

InnoDBIsolation LevelsLocks
0 likes · 11 min read
Understanding MVCC and Lock Mechanisms in MySQL
Su San Talks Tech
Su San Talks Tech
Dec 30, 2022 · Fundamentals

Unlocking Java Concurrency: A Deep Dive into AQS, Locks, and Condition Queues

This article explains Java's AbstractQueuedSynchronizer (AQS) framework, covering its MESA monitor model, entry and condition wait queues, exclusive and shared lock acquisition and release, and how core concurrency utilities like ReentrantLock, ReadWriteLock, CountDownLatch, Semaphore, ThreadPoolExecutor, and CyclicBarrier are built upon it.

AQSConditionJava
0 likes · 30 min read
Unlocking Java Concurrency: A Deep Dive into AQS, Locks, and Condition Queues
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Nov 30, 2022 · Backend Development

Understanding Java J.U.C Locks: ReentrantLock, ReentrantReadWriteLock, and Condition

This article introduces Java's java.util.concurrent (J.U.C) package, explains its lock mechanisms—including Lock, ReentrantLock, ReentrantReadWriteLock, and Condition—provides detailed code examples, and discusses lock types such as fair, non‑fair, and read/write locks for effective multithreaded synchronization.

ConditionJUCJava
0 likes · 16 min read
Understanding Java J.U.C Locks: ReentrantLock, ReentrantReadWriteLock, and Condition
ByteDance Terminal Technology
ByteDance Terminal Technology
Nov 23, 2022 · Fundamentals

Understanding and Solving Priority Inversion on iOS

This article analyzes a real‑world iOS deadlock caused by priority inversion when a low‑priority thread holds a read‑write lock, explains bounded and unbounded priority inversion, evaluates priority‑ceiling and priority‑inheritance protocols, and demonstrates practical fixes using QoS adjustments, temporary priority boosts, and appropriate lock choices.

LocksQoSiOS
0 likes · 26 min read
Understanding and Solving Priority Inversion on iOS
Top Architect
Top Architect
Oct 17, 2022 · Backend Development

Understanding Java Locks: volatile, synchronized, monitor, CAS, and AQS

This article explains why locks are needed in Java, describes the fundamentals of volatile and synchronized, details the monitor‑based implementation of synchronized, introduces CAS operations, and outlines advanced lock mechanisms such as biased, lightweight, lock coarsening, elimination, and the AbstractQueuedSynchronizer framework.

AQSCASJava
0 likes · 11 min read
Understanding Java Locks: volatile, synchronized, monitor, CAS, and AQS
Selected Java Interview Questions
Selected Java Interview Questions
Aug 5, 2022 · Backend Development

Understanding Interface Call Idempotency and Practical Solutions for Backend Systems

The article explains the concept of interface call idempotency in distributed micro‑service architectures, outlines scenarios that cause idempotency problems, and presents practical solutions such as token mechanisms, various lock strategies, unique constraints, deduplication tables, and global request IDs, with code examples in Java and Redis.

BackendDistributed SystemsJava
0 likes · 13 min read
Understanding Interface Call Idempotency and Practical Solutions for Backend Systems
Top Architect
Top Architect
Jul 16, 2022 · Databases

Understanding MySQL Locks: Table, Row, and Gap Locks in InnoDB and MyISAM

This article explains MySQL locking mechanisms—including table‑level, row‑level, shared and exclusive locks, as well as gap locks—covers the differences between MyISAM and InnoDB engines, shows how to monitor lock statistics, and provides practical optimization tips for reducing lock contention.

Database OptimizationInnoDBLocks
0 likes · 9 min read
Understanding MySQL Locks: Table, Row, and Gap Locks in InnoDB and MyISAM
OPPO Kernel Craftsman
OPPO Kernel Craftsman
Jul 15, 2022 · Mobile Development

Understanding User‑Space Locks on Android: Java, JUC, and Native Locks

The article explains Android’s user‑space locking hierarchy—from Java intrinsic and JUC locks to C++ std::mutex and pthread mutexes—detailing their internal structures, state transitions, and reliance on futex system calls for kernel‑level blocking, helping developers optimize synchronization across Java and native layers.

AndroidJavaLocks
0 likes · 17 min read
Understanding User‑Space Locks on Android: Java, JUC, and Native Locks
Sohu Tech Products
Sohu Tech Products
Jul 13, 2022 · Mobile Development

What Is a Lock? Understanding iOS Synchronization Primitives

This article explains the concept of locks in iOS, describing their purpose, the actions of acquiring and releasing, common lock types such as spin locks, mutexes, semaphores, and their implementations using OSSpinLock, pthread_mutex, NSCondition, NSLock, recursive locks, and read‑write locks, along with performance considerations and underlying principles.

LocksSynchronizationconcurrency
0 likes · 19 min read
What Is a Lock? Understanding iOS Synchronization Primitives
IT Services Circle
IT Services Circle
Jun 2, 2022 · Fundamentals

Comprehensive Guide to Java Concurrency: Threads, Locks, Executors, and Synchronization Primitives

This article provides an in-depth overview of Java concurrency, covering thread creation, lifecycle, synchronization mechanisms such as locks, semaphores, barriers, atomic classes, concurrent collections, executor frameworks, fork/join, CompletableFuture, and various blocking queues, with code examples and implementation details.

BlockingQueueExecutorServiceJava
0 likes · 52 min read
Comprehensive Guide to Java Concurrency: Threads, Locks, Executors, and Synchronization Primitives
Top Architect
Top Architect
Apr 5, 2022 · Backend Development

Deep Dive into Java's AbstractQueuedSynchronizer (AQS) and Concurrency Utilities

This article provides an in‑depth analysis of Java's AbstractQueuedSynchronizer (AQS), explaining its internal data structures, lock acquisition and release mechanisms for ReentrantLock and ReentrantReadWriteLock, and demonstrates how higher‑level concurrency utilities such as Condition, CountDownLatch, CyclicBarrier, and Semaphore are built on top of AQS.

AQSJUCJava
0 likes · 28 min read
Deep Dive into Java's AbstractQueuedSynchronizer (AQS) and Concurrency Utilities
Su San Talks Tech
Su San Talks Tech
Mar 18, 2022 · Databases

Unlock 16 Powerful Redis Patterns for Scalable Backend Systems

This article presents sixteen practical Redis use cases—including caching, distributed sessions, locks, global IDs, counters, rate limiting, bitmaps, shopping carts, timelines, queues, lotteries, likes, tags, filtering, follow models, and ranking—illustrating how to leverage Redis data structures for high‑performance, scalable backend applications.

BitmapsDistributed SystemsLocks
0 likes · 9 min read
Unlock 16 Powerful Redis Patterns for Scalable Backend Systems
Su San Talks Tech
Su San Talks Tech
Jan 17, 2022 · Backend Development

Understanding Optimistic vs Pessimistic Locks and Advanced Java Lock Types

This article explains the concepts, differences, and appropriate use cases of optimistic and pessimistic locks, exclusive and shared locks, mutex and read‑write locks, fair and unfair locks, reentrant, spin, segment locks, lock upgrades, and lock‑optimization techniques in Java concurrency programming.

LocksOptimisticLockPessimisticLock
0 likes · 13 min read
Understanding Optimistic vs Pessimistic Locks and Advanced Java Lock Types
Open Source Linux
Open Source Linux
Dec 16, 2021 · Fundamentals

From Mechanical Calculators to Modern CPUs: Exploring Computer Fundamentals and Java Concurrency

This comprehensive guide traces the evolution of computing from early mechanical calculators to today's CPUs, delving into binary systems, memory hierarchies, synchronization primitives, thread states, lock mechanisms, and Java concurrency intricacies, while providing code examples, diagrams, and interview insights for developers.

CPU architectureJava concurrencyLocks
0 likes · 38 min read
From Mechanical Calculators to Modern CPUs: Exploring Computer Fundamentals and Java Concurrency
JavaEdge
JavaEdge
Dec 11, 2021 · Backend Development

Master Java Locks: From Pessimistic to Optimistic and Beyond

This article explains the full spectrum of Java concurrency locks—including pessimistic, optimistic, exclusive, shared, fair, unfair, segment, reentrant, and spin locks—detailing their principles, typical use cases, implementation details, and code examples to help you ace interview questions.

CASJavaLocks
0 likes · 12 min read
Master Java Locks: From Pessimistic to Optimistic and Beyond
Java Tech Enthusiast
Java Tech Enthusiast
Nov 18, 2021 · Fundamentals

Pessimistic and Optimistic Locks in Java: Theory and Code Examples

The article compares Java's pessimistic locking mechanisms such as synchronized blocks and ReentrantLock with optimistic approaches like version checks, CAS‑based AtomicInteger and custom spin locks, illustrating each method through counter examples and discussing their performance trade‑offs and limitations.

CASJavaLocks
0 likes · 11 min read
Pessimistic and Optimistic Locks in Java: Theory and Code Examples
NiuNiu MaTe
NiuNiu MaTe
Oct 21, 2021 · Databases

Master MySQL ACID, Isolation Levels, Locks & Indexes – A Deep Dive

This article walks through MySQL's core concepts—including ACID guarantees, the four isolation levels, undo and redo logs, buffer pool flushing, lock types, gap locks, deadlock scenarios, and the B+‑tree based index architecture—providing interview‑ready insights and practical examples.

ACIDB+TreeDatabase Interview
0 likes · 12 min read
Master MySQL ACID, Isolation Levels, Locks & Indexes – A Deep Dive
MaGe Linux Operations
MaGe Linux Operations
Oct 9, 2021 · Fundamentals

Master Python Thread Synchronization: Locks, RLocks, Conditions, Events & Semaphores Explained

This article delves into Python's threading module, explaining thread safety, the role of various lock types—including Lock, RLock, Condition, Event, and Semaphore—along with their methods, usage patterns, common pitfalls like deadlocks, and practical code examples to illustrate proper synchronization techniques.

LocksSynchronizationconcurrency
0 likes · 25 min read
Master Python Thread Synchronization: Locks, RLocks, Conditions, Events & Semaphores Explained
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Sep 14, 2021 · Databases

Common MySQL Interview Questions and Answers

This article provides a comprehensive collection of typical MySQL interview questions covering storage engines, lock types, gap locks, deadlock avoidance, isolation levels, index types, covering indexes, left‑most prefix rule, replication, distributed transactions, optimization techniques, sharding challenges and solutions, and global unique ID generation.

LocksReplicationdatabase
0 likes · 15 min read
Common MySQL Interview Questions and Answers
Ops Development Stories
Ops Development Stories
Sep 13, 2021 · Backend Development

Mastering Java Locks: When to Use synchronized vs ReentrantLock

This article explains how Java locks solve concurrent access problems, compares the built‑in synchronized lock with ReentrantLock, describes their upgrade mechanisms, usage patterns, and scenarios, and offers guidance on choosing the appropriate lock for different environments.

JavaLocksReentrantLock
0 likes · 7 min read
Mastering Java Locks: When to Use synchronized vs ReentrantLock
JavaEdge
JavaEdge
Sep 10, 2021 · Databases

MySQL Lock Types Explained: Row, Gap, Metadata and Deadlock Prevention

This article examines MySQL’s locking mechanisms—including shared and exclusive row locks, gap and next‑key locks, table‑level and metadata locks—detailing how different SQL statements and index types affect lock acquisition, illustrating lock behavior with examples, and offering practical strategies to avoid deadlocks.

InnoDBLocksdeadlock
0 likes · 15 min read
MySQL Lock Types Explained: Row, Gap, Metadata and Deadlock Prevention
Top Architect
Top Architect
Aug 26, 2021 · Databases

Understanding MySQL Locks: Table, Row, and Page Locking Mechanisms

This article explains why MySQL uses locks, describes table‑level, row‑level, and page‑level locking, outlines lock types such as shared, exclusive, and intention locks, and provides practical usage examples and common troubleshooting tips for InnoDB and other storage engines.

InnoDBLocksSQL
0 likes · 7 min read
Understanding MySQL Locks: Table, Row, and Page Locking Mechanisms
Wukong Talks Architecture
Wukong Talks Architecture
Aug 4, 2021 · Databases

Understanding MySQL InnoDB Locks: Shared, Exclusive, Intention, Gap, Next‑Key, Auto‑Inc, and Predicate Locks

The article presents a detailed interview‑style walkthrough of MySQL InnoDB locking mechanisms, covering table‑ versus row‑level locks, shared and exclusive locks, intention locks, gap and next‑key locks, auto‑increment locks, predicate locks, and related SQL statements, illustrated with tables and code examples.

InnoDBLocksSQL
0 likes · 13 min read
Understanding MySQL InnoDB Locks: Shared, Exclusive, Intention, Gap, Next‑Key, Auto‑Inc, and Predicate Locks
Fulu Network R&D Team
Fulu Network R&D Team
Jul 6, 2021 · Operations

Understanding Throughput, Concurrency, and Lock Contention in System Design

Throughput measures the rate at which an application processes tasks, distinct from concurrency, and can be improved by reducing task latency, increasing parallelism, and optimizing lock usage through finer granularity, lower cost, and techniques like buffering, merging, and batch processing to mitigate contention and enhance scalability.

LocksParallelismScalability
0 likes · 11 min read
Understanding Throughput, Concurrency, and Lock Contention in System Design
Top Architect
Top Architect
May 11, 2021 · Fundamentals

Understanding Java Locks: From Synchronized to Lock Upgrade Mechanisms

This article explains how Java implements locks—from the basic use of the synchronized keyword and Lock interface to the internal object header structures, bias, lightweight, and heavyweight lock upgrades, and the role of CAS and monitor objects in JVM concurrency control.

JVMJavaLocks
0 likes · 18 min read
Understanding Java Locks: From Synchronized to Lock Upgrade Mechanisms
Su San Talks Tech
Su San Talks Tech
Apr 6, 2021 · Backend Development

Mastering Java Locks: From Optimistic to Biased – A Complete Guide

This article provides a comprehensive overview of Java's lock mechanisms—including optimistic, pessimistic, spin, reentrant, read‑write, fair, unfair, shared, exclusive, heavyweight, lightweight, biased, segment, mutex, and synchronized locks—explaining their principles, typical usages, performance trade‑offs, and key differences with code examples.

LocksSynchronizationperformance
0 likes · 15 min read
Mastering Java Locks: From Optimistic to Biased – A Complete Guide
360 Tech Engineering
360 Tech Engineering
Mar 12, 2021 · Databases

Comprehensive Overview of the InnoDB Lock System in MySQL

This article provides a detailed explanation of MySQL InnoDB's lock system, covering lock granularity, shared and exclusive locks, intention and auto‑increment locks, various row‑lock types, deadlock scenarios with examples, and the internal representation of locks in the engine.

InnoDBLocksdatabase
0 likes · 22 min read
Comprehensive Overview of the InnoDB Lock System in MySQL
Sohu Tech Products
Sohu Tech Products
Feb 24, 2021 · Frontend Development

Understanding the Web Locks API: Concepts, Usage, and Risks

The article explains the concept of locks, introduces the Web Locks API for synchronizing resource access across scripts, details its request workflow, optional parameters, potential risks such as deadlocks, and notes browser compatibility, providing code examples for practical use.

BrowserLocksWeb Locks API
0 likes · 13 min read
Understanding the Web Locks API: Concepts, Usage, and Risks
Java Captain
Java Captain
Feb 20, 2021 · Backend Development

Systematic Overview of Java Concurrency and the J.U.C Framework

This article provides a comprehensive, systematic guide to Java concurrency, covering fundamental concepts, key keywords such as volatile, final, and synchronized, and an in‑depth exploration of the J.U.C framework including locks, atomic classes, concurrent collections, thread pools, and utility classes.

JUCJavaLocks
0 likes · 23 min read
Systematic Overview of Java Concurrency and the J.U.C Framework
ITPUB
ITPUB
Jan 26, 2021 · Databases

Master MySQL Transactions, Locks, and Advanced SQL Techniques

This guide walks through MySQL's advanced features, covering lock types, transaction control commands, autocommit handling, savepoints, SQL mode configuration, regular expression usage, common SQL tricks, and a comprehensive overview of built‑in functions with practical code examples.

LocksSQL ModeTransactions
0 likes · 25 min read
Master MySQL Transactions, Locks, and Advanced SQL Techniques
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jan 13, 2021 · Backend Development

Understanding Java's AbstractQueuedSynchronizer (AQS) and Concurrency Utilities

This article provides an in-depth explanation of Java's AbstractQueuedSynchronizer (AQS) framework, covering its role in JUC concurrency utilities such as locks, semaphores, CountDownLatch, ReentrantReadWriteLock, and Condition, including template methods, state management, node structures, queue algorithms, and practical code examples.

AQSConditionJUC
0 likes · 25 min read
Understanding Java's AbstractQueuedSynchronizer (AQS) and Concurrency Utilities
Programmer DD
Programmer DD
Dec 19, 2020 · Databases

Master MySQL Locks: Isolation Levels, Types, and Deadlock Solutions

This article explains MySQL locking mechanisms, covering lock concepts, isolation level interactions, lock granularity (row, table, page), lock types (shared, exclusive, record, gap, next-key), InnoDB row‑lock implementation, deadlock causes and remedies, and the differences between optimistic and pessimistic locking.

Database ConcurrencyInnoDBIsolation Levels
0 likes · 10 min read
Master MySQL Locks: Isolation Levels, Types, and Deadlock Solutions