展开查看详情
1.TiDB 2.1: What's New and What's Next
shenli@pingcap.com
2.Agenda
● What’s new in TiDB 2.1
○ PD/TiKV
○ TiDB
○ Tools
● What’s next?
4.PD/TiKV (1/2)
● Version Control
● PreVote
○ PD
○ TiKV
● Raft Learner
● Hotspot scheduling
● Asynchronous log
5.PD/TiKV (2/2)
● Fix DST issue
● Batch Split, Fast Split
6.SQL Layer (1/2)
● Optimizer && Execution Engine
○ Optimize the selection range of `Index Join` to improve the execution performance
○ Support `Index Hint` and `Join Hint` in the `UPDATE` and `DELETE` statements
○ Parallel `Hash Aggregate`, `Project` operators
○ New Aggregation Framework
○ Update statistic based on query feedback
○ Explain Analyze Statement
● DDL
○ Parallely executing DDL: AddIndex, Other DDL statements
○ Optimize the execution speed of `ADD INDEX`
7.SQL Layer (2/2)
● DML && Server
○ Optimize the conflicted transaction performance
○ Optimize the statement performance of `insert ignore on duplicate key update`
○ Optimize explain output
○ Server-side cursor
○ Slow query
○ Table Partition (Range Partition, Experimental)
● HTTP API
○ Scatter the distribution of table Regions in the TiKV cluster
○ General log
○ Log level
8.Tools
● Lightning
● New binlog
10.2.0 VS 1.0 on TPC-H Scale 50
11.2.1 VS 2.0 on TPC-H Scale 50
12.2.1 VS 2.0 on Sysbench Point-Query
13. 2.1.0-RC5 is shipped.
2.1.0-GA is not far away.
15.PD
● Hotspot Scheduling
○ Collecting Information
○ Auto balance/split hot region
● Powerful replica strategy
○ IDC
○ Replica count 3/5/7
16.TiKV
● Multi-thread Raft store
● Multi-thread Apply worker
● Consensus Join
● The next generation storage engine
○ Optimize for large key-value
○ Compaction
17.TiDB
● Optimizer
○ Join Reorder
○ Cascades Optimizer
● Execution Engine
○ Parallel operators
○ Projection pushdown
○ Improve the performance of OLTP workload
○ File sort
● Table Partition (Range Partition, GA)
● View, Window Function, CTE
18.Open Source
● Document
○ Design Docs
○ Source Code Reading
○ Community
● Open Source Community
○ More open
○ 20k+ Stars
○ More contributors: 161 -> 215
○ One more committer
19.One more thing: A brand new admin tool
