TiDB
/
发布于
/
7926
人观看
主要介绍了 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?
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
