What is New TiDB

主要介绍了 TiDB 2.1 版本的重要 Feature,包括这些 Feature 所解决的问题、背后的原理、达到的效果,特别是 TiDB 在优化器、计算引擎、存储引擎方面的改进,使得 2.1 版本成为更智能、更迅速、更稳定的数据库。接着展示了部分 Benchmark 结果,分别从 OLAP、OLTP 两个场景表明 TiDB 的性能提升。最后介绍了下一步工作的展望,让大家了解 TiDB 的演进方向。
展开查看详情

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 !

TiDB 是一款定位于在线事务处理/在线分析处理( HTAP: Hybrid Transactional/Analytical Processing)的融合型数据库产品,实现了一键水平伸缩,强一致性的多副本数据安全,分布式事务,实时 OLAP 等重要特性。
关注他