BestHub
Sign in
Tagged articles
17 articles
Page 1 of 1
IT Services Circle
IT Services Circle
Oct 11, 2025 · Databases

Crack Backend Interviews: Redis, MySQL Locks, MQs & XiaoHongShu Salary Secrets

The article combines a surprising look at XiaoHongShu's record‑breaking graduate salaries with a comprehensive backend interview guide covering Redis advantages and drawbacks, common data structures, persistence and high‑availability, MySQL lock types, optimistic vs. pessimistic locking, message‑queue fundamentals, RabbitMQ vs. Kafka differences, deadlock avoidance, and a sample algorithm question.

Database LocksSalary Insightsbackend interview
0 likes · 19 min read
Crack Backend Interviews: Redis, MySQL Locks, MQs & XiaoHongShu Salary Secrets
Cognitive Technology Team
Cognitive Technology Team
Jun 7, 2025 · Databases

Mastering MySQL Locks: Types, Mechanisms, and Best Practices

This article explains MySQL’s locking mechanisms, categorizing locks by performance, operation type, data granularity, and finer‑grained levels such as gap and next‑key locks, and offers guidance on selecting the appropriate lock strategy for reliable concurrent database operations.

Concurrency ControlDatabase LocksInnoDB
0 likes · 9 min read
Mastering MySQL Locks: Types, Mechanisms, and Best Practices
Sanyou's Java Diary
Sanyou's Java Diary
Aug 21, 2023 · Databases

Master MySQL Optimization: Indexing, Locking, Pagination & Profiling Tips

This article presents practical MySQL optimization techniques—including proper index creation, avoiding index invalidation, choosing appropriate lock granularity, efficient pagination strategies, steering clear of SELECT *, and using EXPLAIN and SHOW PROFILE—to help developers write faster, more reliable SQL queries.

Database LocksSQL Optimizationindexing
0 likes · 10 min read
Master MySQL Optimization: Indexing, Locking, Pagination & Profiling Tips
Selected Java Interview Questions
Selected Java Interview Questions
May 29, 2021 · Databases

Understanding Database Locks: Shared, Exclusive, Mutex, Pessimistic, Optimistic, Row, Table, and Page Locks, and Common Concurrency Issues

This article explains the concepts, usage scenarios, and differences of various database locks—including shared (S) lock, exclusive (X) lock, mutex, pessimistic and optimistic locks—as well as row‑level, table‑level, and page‑level locks, and it discusses common concurrency problems such as lost updates, non‑repeatable reads, dirty reads, and deadlocks.

Concurrency ControlDatabase Locksmysql
0 likes · 8 min read
Understanding Database Locks: Shared, Exclusive, Mutex, Pessimistic, Optimistic, Row, Table, and Page Locks, and Common Concurrency Issues
Java Interview Crash Guide
Java Interview Crash Guide
Mar 26, 2021 · Databases

Understanding MySQL InnoDB Locks: Types, Isolation, and MVCC Explained

This article explains the concept of locks in computing and databases, compares InnoDB and MyISAM storage engines, details transaction isolation phenomena such as dirty reads, non‑repeatable reads and phantom reads, and explores InnoDB lock types, lock algorithms, intention locks, auto‑increment lock modes, and MVCC mechanisms.

Database LocksInnoDBMVCC
0 likes · 13 min read
Understanding MySQL InnoDB Locks: Types, Isolation, and MVCC Explained
Architecture Digest
Architecture Digest
Sep 5, 2020 · Databases

Understanding SQL Server Lock Escalation and How to Prevent It

This article explains the fundamentals of SQL Server locking, illustrates how row‑level locks can automatically escalate to table‑level locks during large batch operations, and provides practical techniques—such as batching deletes, adding appropriate indexes, and holding intent locks—to avoid lock escalation and improve concurrency.

Database LocksLock EscalationSQL
0 likes · 12 min read
Understanding SQL Server Lock Escalation and How to Prevent It
MaGe Linux Operations
MaGe Linux Operations
Apr 7, 2020 · Databases

Understanding MySQL Locks: Types, Engines, and Deadlock Prevention

This article explains why MySQL requires locking, compares table and row lock types, details MyISAM and InnoDB lock mechanisms—including optimistic vs. pessimistic locks, lock algorithms, and deadlock handling—while providing practical SQL examples and prevention strategies.

Database LocksInnoDBMyISAM
0 likes · 16 min read
Understanding MySQL Locks: Types, Engines, and Deadlock Prevention
Youzan Coder
Youzan Coder
Jan 25, 2019 · Databases

MySQL/InnoDB Deadlock Analysis: Detection, Handling, and Prevention

The guide explains MySQL/InnoDB deadlocks—how circular lock waits arise, the wait‑for‑graph detection that rolls back the transaction with fewer undo logs, the various lock modes and their behavior in UPDATE/INSERT/DELETE, and practical strategies such as proper indexing, consistent access order, and configuration tweaks to detect, handle, and prevent deadlocks.

Concurrency ControlDatabase LocksDatabase Optimization
0 likes · 13 min read
MySQL/InnoDB Deadlock Analysis: Detection, Handling, and Prevention
Ctrip Technology
Ctrip Technology
Mar 14, 2018 · Databases

Understanding MySQL Metadata Locks and InnoDB Lock Mechanisms

This article explains MySQL's architecture, details the various metadata lock types, their acquisition and release processes, lock levels, and relationships, and then examines InnoDB's transaction isolation levels, lock types, lock levels, gap locks, and relevant source‑code structures.

Database LocksInnoDBLock Levels
0 likes · 15 min read
Understanding MySQL Metadata Locks and InnoDB Lock Mechanisms
ITPUB
ITPUB
Oct 17, 2016 · Databases

Quickly Diagnose Oracle Lock Contention with AWK and ass109.awk

This guide demonstrates how to use the ass109.awk script and Oracle's oradebug tool to capture, parse, and analyze trace files, quickly identifying lock and deadlock sessions in Oracle 11gR2 without resorting to costly restarts.

Database LocksOracleSQL
0 likes · 9 min read
Quickly Diagnose Oracle Lock Contention with AWK and ass109.awk
ITPUB
ITPUB
Aug 6, 2016 · Databases

Understanding K-DB Lock Structure and Operation Mechanisms

This article explains the components stored in each K-DB lock—including data block address, instance ID, lock mode, block state, and role—and describes how locks are created, used, and released, with a focus on the CWLS module that manages lock granting and conversion in a clustered environment.

CWLSCluster ArchitectureDatabase Locks
0 likes · 7 min read
Understanding K-DB Lock Structure and Operation Mechanisms