StarRocks is a MySQL-compatible MPP OLAP engine. A cluster is Frontend (FE) nodes for metadata and query coordination plus Backend (BE) or Compute …

RocksDB is the embeddable LSM key-value engine under each TiKV store. TiKV builds tikv/rocksdb (branch 8.10.tikv) through rust-rocksdb, and opens two …

TiKV is TiDB’s row store built on Multi-Raft: every Region is a Raft group, every durable write is a Raft log entry, and RocksDB holds the Raft log ( …

The CAP theorem states what a replicated store can guarantee when the network splits. Raft implements CAP’s CP choice via majority quorum. This post …

TiDB is a MySQL-compatible distributed SQL system. A deployment is a cluster of TiDB servers (compute), PD (control), TiKV (row store), and optionally …

This article examines MySQL INSERT and UPDATE from the SQL command layer through table and metadata locking into InnoDB record locking, undo …

For many years, MySQL executed SQL queries using a deeply nested, monolithic executor loop. Functions like JOIN::exec() and evaluate_join_record() …

Grouping and aggregation are cornerstones of relational databases. In MySQL, executing a GROUP BY statement involves a sophisticated dance between the …

This article introduces the internal architecture and implementation details of MySQL’s default storage engine, InnoDB, exploring its memory …

This article introduces Mysql Metadata

This article provides an in-depth dive into MySQL query processing internals, tracing the lifecycle of a query from the network connection to parsing, …