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
18.Open Source
● Document
○ Design Docs
○ Source Code Reading
○ Community
● Open Source Community
○ More open
○ 20k+ Stars
○ More contributors: 161 -> 215
○ One more committer
