BestHub
Sign in
Tagged articles
38 articles
Page 1 of 1
StarRocks
StarRocks
Apr 16, 2026 · Databases

Why Traditional Databases Stall AI Agents—and How StarRocks Overcomes the Bottleneck

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 ConcurrencyLakehouseReal-time analytics
0 likes · 13 min read
Why Traditional Databases Stall AI Agents—and How StarRocks Overcomes the Bottleneck
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jan 8, 2026 · Databases

Understanding MySQL Transaction Isolation Levels with Practical Examples

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 ConcurrencyInnoDBSQL
0 likes · 10 min read
Understanding MySQL Transaction Isolation Levels with Practical Examples
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 19, 2025 · Databases

How OceanBase CPU Quotas and Large Queries Shape Performance

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 ConcurrencyOceanBasecpu quota
0 likes · 17 min read
How OceanBase CPU Quotas and Large Queries Shape Performance
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jun 11, 2025 · Databases

Understanding MySQL Transaction Isolation Levels with Real‑World Examples

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 ConcurrencyInnoDBSQL
0 likes · 10 min read
Understanding MySQL Transaction Isolation Levels with Real‑World Examples
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 14, 2024 · Databases

Granting Table Locks and Row Locks in InnoDB

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
Granting Table Locks and Row Locks in InnoDB
Architecture & Thinking
Architecture & Thinking
Apr 16, 2024 · Databases

Master MySQL InnoDB Locks: How SELECT…FOR UPDATE Behaves

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 ConcurrencyInnoDBSELECT FOR UPDATE
0 likes · 10 min read
Master MySQL InnoDB Locks: How SELECT…FOR UPDATE Behaves
Architecture & Thinking
Architecture & Thinking
Nov 17, 2023 · Databases

Mastering MySQL Transactions: ACID, Isolation Levels, and Common Pitfalls

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
Mastering MySQL Transactions: ACID, Isolation Levels, and Common Pitfalls
IT Services Circle
IT Services Circle
Aug 20, 2023 · Databases

Understanding MySQL Transaction Isolation Levels and Their Practical Implications

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 ConcurrencySQLdirty read
0 likes · 12 min read
Understanding MySQL Transaction Isolation Levels and Their Practical Implications
ITPUB
ITPUB
Jul 28, 2023 · Databases

Master InnoDB Row Locking: Rules, Examples, and How Locks Are Applied

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 ConcurrencyInnoDBNext-key Lock
0 likes · 10 min read
Master InnoDB Row Locking: Rules, Examples, and How Locks Are Applied
ITPUB
ITPUB
Jan 26, 2023 · Databases

What Locks Does SELECT … FOR UPDATE Acquire Under Different Isolation Levels?

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 ConcurrencyInnoDBIsolation Levels
0 likes · 16 min read
What Locks Does SELECT … FOR UPDATE Acquire Under Different Isolation Levels?
dbaplus Community
dbaplus Community
Jan 8, 2023 · Databases

Mastering MySQL Row‑Level Locks: Rules, Types, and How to Inspect Them

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
Mastering MySQL Row‑Level Locks: Rules, Types, and How to Inspect Them
JavaEdge
JavaEdge
Aug 1, 2022 · Databases

How Snapshot Isolation and MVCC Prevent Read Skew in Modern Databases

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
How Snapshot Isolation and MVCC Prevent Read Skew in Modern Databases
JavaEdge
JavaEdge
Jul 31, 2022 · Databases

Understanding Dirty Reads and Writes: How Transaction Isolation Keeps Your Data Safe

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 readdirty write
0 likes · 7 min read
Understanding Dirty Reads and Writes: How Transaction Isolation Keeps Your Data Safe
Wukong Talks Architecture
Wukong Talks Architecture
Jul 21, 2022 · Databases

Understanding MySQL MVCC Mechanism

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 ConcurrencyIsolation LevelsMVCC
0 likes · 8 min read
Understanding MySQL MVCC Mechanism
vivo Internet Technology
vivo Internet Technology
Jul 21, 2021 · Backend Development

Resolving Duplicate OpenID Insertions in Fast App Center: Analysis and Distributed Lock Solutions

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.

Backend DevelopmentDatabase ConcurrencyJava
0 likes · 18 min read
Resolving Duplicate OpenID Insertions in Fast App Center: Analysis and Distributed Lock Solutions
Xiaolei Talks DB
Xiaolei Talks DB
Jul 21, 2021 · Databases

Optimistic vs Pessimistic Transactions in TiDB: 10x Performance Boost

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
Optimistic vs Pessimistic Transactions in TiDB: 10x Performance Boost
Laravel Tech Community
Laravel Tech Community
Jul 8, 2021 · Databases

Understanding Optimistic and Pessimistic Locks in MySQL/InnoDB

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 ConcurrencyLaravellocking
0 likes · 6 min read
Understanding Optimistic and Pessimistic Locks in MySQL/InnoDB
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
MaGe Linux Operations
MaGe Linux Operations
Oct 9, 2020 · Databases

How MySQL Implements Transaction Isolation: Locks, MVCC, and Gap Locks Explained

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
How MySQL Implements Transaction Isolation: Locks, MVCC, and Gap Locks Explained
Architecture Digest
Architecture Digest
Apr 24, 2020 · Databases

Detailed Explanation of MySQL InnoDB Lock Mechanisms

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
Detailed Explanation of MySQL InnoDB Lock Mechanisms
Efficient Ops
Efficient Ops
May 29, 2019 · Databases

Understanding MySQL Locks: From Table Locks to InnoDB Row Locks

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
Understanding MySQL Locks: From Table Locks to InnoDB Row Locks
Java High-Performance Architecture
Java High-Performance Architecture
Jan 3, 2019 · Databases

Understanding Transaction Isolation Levels: Dirty, Non‑Repeatable, and Phantom Reads Explained

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 ConcurrencyRepeatable ReadSQL
0 likes · 6 min read
Understanding Transaction Isolation Levels: Dirty, Non‑Repeatable, and Phantom Reads Explained
ITPUB
ITPUB
Feb 22, 2018 · Databases

How to Diagnose and Resolve Oracle TX Row Lock Contention

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 ConcurrencyOracleSQL
0 likes · 8 min read
How to Diagnose and Resolve Oracle TX Row Lock Contention
MaGe Linux Operations
MaGe Linux Operations
Aug 22, 2016 · Databases

Master MySQL Transaction Isolation Levels and Locking Mechanisms

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 ConcurrencyInnoDBlocking
0 likes · 8 min read
Master MySQL Transaction Isolation Levels and Locking Mechanisms
21CTO
21CTO
Apr 16, 2016 · Databases

How MySQL InnoDB Locks Work: From MVCC Basics to Deadlock Analysis

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
How MySQL InnoDB Locks Work: From MVCC Basics to Deadlock Analysis
ITPUB
ITPUB
Apr 14, 2016 · Databases

Master MySQL Transaction Isolation Levels and Lock Mechanisms

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
Master MySQL Transaction Isolation Levels and Lock Mechanisms