Tag

SQL layer

0 views collected around this technical thread.

JD Cloud Developers
JD Cloud Developers
Jan 21, 2022 · Databases

Mastering TiDB SQL Layer: Architecture, Optimization, and Real-World Cases

This article explains TiDB's SQL layer architecture, details how SQL requests are processed and optimized, demonstrates the use of EXPLAIN and EXPLAIN ANALYZE, and presents two real‑world case studies that illustrate common performance pitfalls and practical optimization techniques.

Database performanceEXPLAINSQL layer
0 likes · 8 min read
Mastering TiDB SQL Layer: Architecture, Optimization, and Real-World Cases
Architect
Architect
Nov 7, 2015 · Databases

Design and Implementation of the NewSQL Distributed Database TiDB

This article presents a comprehensive technical overview of TiDB, a NewSQL distributed database, covering its architecture, SQL layer, KV engine, distributed transaction mechanisms, code implementation in Go, open‑source practices, and future roadmap.

Distributed DatabaseGoKV Store
0 likes · 23 min read
Design and Implementation of the NewSQL Distributed Database TiDB