Tagged articles
Database Concurrency
38 articles · Page 1 of 1
Traditional databases were built for low‑frequency, human‑driven queries, but AI agents generate dozens of concurrent, sub‑second queries that expose architectural limits, and StarRocks addresses these challenges with self‑healing optimization, real‑time data pipelines, extreme concurrency handling, and seamless lakehouse access.
Database ConcurrencySelf-HealingStarRocks
0 likes · 13 min read

This article explains MySQL's four transaction isolation levels—Read Uncommitted, Read Committed, Repeatable Read, and Serializable—by creating a simple table, running paired transactions, and showing how each level affects data visibility, concurrency, and potential anomalies such as dirty reads, non‑repeatable reads, and phantom reads.
Database ConcurrencyInnoDBMySQL
0 likes · 10 min read

This comprehensive guide explains MySQL's ACID fundamentals, typical isolation anomalies, the four isolation levels with their lock behaviors, practical SQL examples, how to view and set isolation levels, lock types, a bank‑transfer case study, deadlock avoidance tips, and key interview takeaways.
ACIDDatabase ConcurrencyMySQL
0 likes · 10 min read

This article explains MySQL's four transaction isolation levels, the concurrency problems they address, how MVCC works, and provides practical guidance on selecting the appropriate level based on business requirements and performance trade‑offs.
Database ConcurrencyMVCCMySQL
0 likes · 15 min read

This article explores OceanBase v4 CPU‑related parameters such as workers_per_cpu_quota, cpu_quota_concurrency, and parallel_servers_target, explains their formulas, demonstrates experimental setups and results on tenant thread limits, large‑query impact, and provides practical tuning recommendations based on observed performance data.
Database ConcurrencyOceanBasePerformance Tuning
0 likes · 17 min read

This article explains MySQL's four transaction isolation levels—READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE—through step‑by‑step examples, demonstrating their effects on dirty reads, non‑repeatable reads, phantom reads, and performance considerations, helping developers choose the appropriate level.
Database ConcurrencyInnoDBMySQL
0 likes · 10 min read

This article explains MySQL InnoDB's multi-version concurrency control (MVCC), covering its basic concepts, hidden columns, isolation levels, the creation and evaluation of Read Views, and includes detailed source code examples and step‑by‑step experiments to illustrate transaction visibility.
Database ConcurrencyInnoDBMVCC
0 likes · 18 min read

This article explains how InnoDB in MySQL 8.0.32 grants table and row locks, detailing the active versus passive acquisition, the lock‑granting algorithms for tables and rows, and the priority, weight, and FIFO rules that determine lock ordering and deadlock handling.
Database ConcurrencyInnoDBMySQL
0 likes · 11 min read

The article explains why transaction isolation is essential in databases, describes common concurrency problems such as lost updates, dirty reads, non‑repeatable reads, and phantom reads, and outlines MySQL's four isolation levels with their effects and trade‑offs.
ACIDDatabase ConcurrencyMySQL
0 likes · 8 min read

This article explains the default repeatable‑read isolation level in InnoDB, details the three main lock types—record, gap, and next‑key—and shows how SELECT … FOR UPDATE applies different locking rules depending on primary key, unique, ordinary, range, or table‑scan queries, with practical SQL examples.
Database ConcurrencyInnoDBMySQL
0 likes · 10 min read

This article explains MySQL transaction fundamentals, the necessity of ACID properties, details the four isolation levels and their impact on phenomena like dirty reads, non‑repeatable reads, and phantom reads, and provides practical SQL examples and strategies for ensuring data consistency in high‑concurrency environments.
ACIDDatabase ConcurrencyInnoDB
0 likes · 15 min read

This article explains MySQL's four transaction isolation levels—READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE—detailing their definitions, associated phenomena such as dirty reads, non‑repeatable reads, and phantom reads, and demonstrates how to query and set isolation levels with practical SQL examples.
Database ConcurrencyDirty ReadMySQL
0 likes · 12 min read


ITPUBJul 28, 2023 · Databases
This article explains InnoDB's three row‑lock types, when MySQL statements acquire implicit or explicit locks, and walks through concrete examples for unique and non‑unique index queries, showing how Next‑key, Record and Gap locks are determined.
Database ConcurrencyInnoDBMySQL
0 likes · 10 min read

This article explains MySQL transaction fundamentals, including the ACID properties, isolation levels, MVCC mechanics, transaction start methods, and practical examples that illustrate how different isolation levels affect data visibility and consistency.
Database ConcurrencyInnoDBMVCC
0 likes · 20 min read


ITPUBJan 26, 2023 · Databases
This article experimentally demonstrates how MySQL's SELECT … FOR UPDATE statement acquires various locks—IX, X, and gap locks—under RC (read‑committed) and RR (repeatable‑read) isolation levels with unique, primary, normal, and missing indexes, revealing when row‑level versus table‑level locking occurs.
Database ConcurrencyInnoDBMySQL
0 likes · 16 min read

This article explains how InnoDB implements row‑level locking in MySQL, detailing the lock types (record, gap, next‑key), the scenarios that trigger each lock, how unique and non‑unique indexes affect locking, and provides step‑by‑step commands and examples for analyzing locks with performance_schema.
Database ConcurrencyInnoDBLock Types
0 likes · 45 min read

The article explains how snapshot isolation and multi-version concurrency control (MVCC) address read skew and nonrepeatable reads in databases, detailing transaction IDs, version visibility rules, implementation differences across PostgreSQL, MySQL, Oracle, and the impact on backups, analytics, and index handling.
Database ConcurrencyMVCCread skew
0 likes · 11 min read

When two transactions access the same data without proper coordination, concurrency bugs such as dirty reads and dirty writes can arise; the article explains these problems, the guarantees of isolation levels, and how row locks and snapshot techniques prevent them in modern databases.
Database ConcurrencyDirty ReadRow Lock
0 likes · 7 min read

This article explains MySQL's multi-version concurrency control (MVCC), describing how version chains, undo logs, and ReadView work together to implement isolation levels, prevent dirty reads, non‑repeatable reads, and phantom reads, and how RC and RR isolation differ in practice.
Database ConcurrencyMVCCMySQL
0 likes · 8 min read


政采云技术May 10, 2022 · Databases
This article explains MySQL 8.0.17 InnoDB locking mechanisms—including latches, row and table locks, lock modes, intention locks, their compatibility matrix, and detailed source‑code examples that illustrate how IX and X locks are acquired during record updates.
Database ConcurrencyInnoDBIntention Locks
0 likes · 13 min read

The Fast App Center’s duplicate OpenID rows were traced to a non‑atomic check‑then‑insert race condition, prompting the team to evaluate a unique‑index safeguard versus application‑level distributed locking, ultimately implementing a Redis‑based lock to serialize inserts and adding a cleanup job to purge existing duplicates.
Database ConcurrencyDistributed LockJava
0 likes · 18 min read

This article compares TiDB's optimistic and pessimistic transaction models through a real‑world high‑concurrency write‑conflict scenario, showing how pessimistic locking can achieve over ten times higher throughput than optimistic retries.
Database ConcurrencyOptimistic TransactionPessimistic Transaction
0 likes · 14 min read

This article explains MySQL deadlocks, describes InnoDB lock types, shows how to read deadlock logs, analyzes classic concurrency cases, and offers practical tips to design indexes and write SQL that minimize lock conflicts and avoid deadlocks.
Database ConcurrencyInnoDBLock Types
0 likes · 16 min read

This article explains the concepts, mechanisms, and practical code examples of optimistic and pessimistic locking in MySQL/InnoDB, including version‑based optimistic locks, shared (read) locks, exclusive (write) locks, and how to apply them with Laravel's query builder.
Database ConcurrencyLaravelMySQL
0 likes · 6 min read

This article explains MySQL transaction fundamentals, the ACID properties, common concurrency problems, isolation level differences, and how InnoDB implements MVCC using version chains and consistency views, illustrated with practical examples and diagrams.
ACIDDatabase ConcurrencyMVCC
0 likes · 15 min read

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 ConcurrencyInnoDBLocks
0 likes · 10 min read

This article explores the underlying mechanisms MySQL uses to enforce transaction isolation levels, detailing how InnoDB leverages locking, multi-version concurrency control, gap locks, and explicit versus implicit locks to prevent dirty reads, non‑repeatable reads, and phantom reads across the four standard isolation levels.
Database ConcurrencyInnoDBMVCC
0 likes · 11 min read

This article analyzes a real‑world MySQL incident where concurrent transactions caused an account balance to become negative, explains the underlying MVCC mechanism, consistency view rules, and how different isolation levels (RR vs RC) affect data visibility and locking behavior.
Database ConcurrencyInnoDBMVCC
0 likes · 14 min read

This article provides a comprehensive overview of MySQL InnoDB locking, covering shared/exclusive locks, intention locks, record locks, gap locks, next‑key locks, insert‑intention locks, and auto‑increment locks, with examples, compatibility tables, and practical SQL snippets to illustrate each mechanism.
Database ConcurrencyInnoDBLocks
0 likes · 12 min read

This article explains the new NOWAIT and SKIP LOCKED keywords introduced in MySQL 8.0.1, describes their background, functionality, and internal implementation, and demonstrates their practical impact on lock‑wait scenarios through a fictional flash‑sale case study with code examples.
Database ConcurrencyInnoDBLock Wait
0 likes · 9 min read

This article explains MySQL's lock mechanisms, comparing MyISAM's table‑level locks with InnoDB's row‑level locks, covering lock types, compatibility, transaction isolation levels, deadlock scenarios, and practical tips to avoid lock contention and improve database concurrency.
Database ConcurrencyInnoDBLocks
0 likes · 22 min read

This article explains the three classic concurrency anomalies—dirty read, non‑repeatable read, and phantom read—describes the four standard isolation levels (read uncommitted, read committed, repeatable read, serializable), and shows how databases implement isolation using rollback logs and read‑views.
Database ConcurrencyDirty ReadRepeatable Read
0 likes · 6 min read

This article explains how to use pessimistic (FOR UPDATE) and optimistic (version field) database locks in a Java SSM red‑packet application to prevent over‑issuance, details implementation steps, code changes, performance testing, and the trade‑offs between lock types.
Database ConcurrencyJavaMyBatis
0 likes · 11 min read

This article explains MySQL's lock mechanisms, covering table‑level, row‑level, and page locks, the differences between pessimistic and optimistic locking, shared locks, and provides guidance on when to choose table locks versus row locks in various application scenarios.
Database ConcurrencyLocksMySQL
0 likes · 7 min read


ITPUBFeb 22, 2018 · Databases
This guide explains Oracle's TX row lock mechanism, shows how to identify blocking sessions, locate the exact locked rows using system views and ROWID functions, and provides practical steps to prevent and mitigate TX lock waiting issues.
Database ConcurrencyOracleRow Lock
0 likes · 8 min read

An in‑depth guide explains MySQL’s four transaction isolation levels, how to modify them globally or per session, the role of autocommit, shared and exclusive lock mechanisms, and provides step‑by‑step InnoDB examples with screenshots illustrating each level’s behavior.
Database ConcurrencyInnoDBMySQL
0 likes · 8 min read


21CTOApr 16, 2016 · Databases
This article provides an in‑depth analysis of MySQL/InnoDB locking mechanisms, covering MVCC snapshot vs current reads, cluster indexes, two‑phase locking, isolation levels, lock behavior for simple and complex SQL statements, and practical deadlock diagnosis techniques.
Database ConcurrencyInnoDBIsolation Level
0 likes · 26 min read


ITPUBApr 14, 2016 · Databases
This guide explains MySQL's four transaction isolation levels, how to change them globally or per session, the impact of autocommit, the different lock types, and provides step‑by‑step InnoDB examples that illustrate the behavior of READ‑UNCOMMITTED, READ‑COMMITTED, REPEATABLE‑READ, and SERIALIZABLE.
Database ConcurrencyInnoDBMySQL
0 likes · 8 min read
