1.2 Go in TiDB.pdf


立即下载 谦逊的毛巾
2024-03-10
c1 c2 Plan Logical 10 gopherchina Physical SQL count TiD
935.5 KB

Go in TiDB
申砾@PingCAP
Agenda
• About Me
• What is TiDB
• TiDB Architecture
• SQL Layer Internal
• Golang in TiDB
• Next Step of TiDB
About Me
• Shen Li (申砾)
• Tech Lead of TiDB, VP of Engineering
• Netease / 360 / PingCAP
• Infrastructure software engineer
What is TiDB
A Distributed, Consistent, Scalable, SQL Database
that supports the best features of both traditional
RDBMS and NoSQL.
Scalability High Availability
ACIDSQL
Architecture - the Whole Picture
Architecture - SQL Layer
Example - SQL
Schema:
CREATE TABLE t (c1 INT, c2 VARCHAR(32), INDEX
idx1 (c1));
Query:
SELECT COUNT(c1) FROM t WHERE c1 > 10 AND c2
= “gopherchina”;
Example - Logical Plan
SelectStmt Node
DataSource
from t
Where
c1 > 10 and c2 =
“gopherchina”
Projection
count(c1)
Logical Plan
AST
Example - Physical Plan
Logical Plan
IndexScan
idx1: (10, +∞)
Filter
c2 = “gopherchina”
Aggregation
count(c1)
Physical Plan
Example - Distributed
Physical Plan
Fina


c1/c2/Plan/Logical/10/gopherchina/Physical/SQL/count/TiD/ c1/c2/Plan/Logical/10/gopherchina/Physical/SQL/count/TiD/
-1 条回复
登录 后才能参与评论
-->