确定删除吗?
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?
3.TiDB 2.1
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
9.Benchmark
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.
14.What’s Next?
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
20.Thanks !