SQL Execution Plan

DeWu Technology

Nov 11, 2022 · Databases

TiDB Overview: Architecture, Storage Model, and Execution Plan

TiDB is an open‑source, MySQL‑compatible distributed database that unifies OLTP and OLAP by using a stateless SQL layer, a Placement Driver for metadata and Raft‑managed TiKV/TiFlash storage, key‑value mapping with RocksDB, and a push‑down execution engine that splits work between coprocessor and root tasks for scalable, highly available workloads.

Distributed DatabaseHTAPIndexing

0 likes · 17 min read

TiDB Overview: Architecture, Storage Model, and Execution Plan

Top Architect

Nov 4, 2022 · Databases

Deep Dive into MySQL Indexes, Execution Plans, Transactions, MVCC, and Buffer Pool

This article provides a comprehensive technical overview of MySQL's underlying index structures, SQL execution plan analysis, transaction isolation levels, MVCC concurrency control, and the InnoDB buffer pool mechanism, illustrating each concept with diagrams and practical SQL examples.

Buffer PoolMVCCMySQL

0 likes · 17 min read

Deep Dive into MySQL Indexes, Execution Plans, Transactions, MVCC, and Buffer Pool