TIDB RC3 Release

This is a creation in Article, where the information may have evolved or changed.

June 16, TIDB officially released version RC3. This version does a lot of work on MySQL compatibility, SQL optimizer, System stability, and performance. Performance-focused optimization of load balancing scheduling policies and processes. function to further improve the rights management functions, users can follow the MySQL Rights Management mode control data access rights. In addition, the speed of DDL has also been significantly improved.

At the same time, in order to simplify operation and maintenance work, open source Tidb-ansible project, you can deploy/upgrade/start-stop TIDB cluster with one click.

TIDB:

• SQL query optimizer

  • Support Statistics Incremental Update

  • Support for the Merge Sort Join operator

  • Supports the Index Lookup Join operator

  • Supports Optimizer hint syntax

  • Optimizes memory consumption for scan,join and Aggregation operators

  • Optimize the CBO framework

  • Refactoring Expression

• Support for more complete rights management

• DDL acceleration

• Support HTTP API to get data distribution information of table

• Control query concurrency through system variables

• Added a lot of MySQL built-in functions

• Automatic splitting of large transactions into small transactions by system variables commit

Pd

• Support GRPC

• Offers disaster Recovery Toolkit

• Automatic GC-out of expired data

• More efficient Data Balance

• Support the scheduling of hotspot region, so that the machine load balance, improve data import speed

• Performance optimization

  • Accelerated Client TSO Acquisition

  • Improve region Heartbeat processing efficiency

• Perfecting Pd-ctl function

  • Dynamic Update Replica Configuration

  • Get TSO

  • Get region information by ID

Tikv

• Support GRPC

• Supports SST format snapshot to increase cluster load balancing speed

• Support for Profile memory usage

• Support SSE, accelerate the calculation of CRC32

• Accelerates Transfer Leader for faster load balancing

• Batch Apply, reduce CPU usage, improve write performance

• Supports parallel prewrite to improve transaction write speed

• Optimizing coprocessor thread pool scheduling to reduce the impact of large queries on point checking

• The new Loader supports table-level concurrent import, and also supports the partitioning of large tables into multiple logical blocks for concurrent import, increasing data import speed

As a world-class open source distributed relational database, TIDB is inspired by Google Spanner/f1, with core features such as "distributed strong consistency transactions, on-line elastic level scaling, high availability of fault self-recovery, and multi-data center-live". Tidb was created on GitHub in May 2015, the Alpha version was released in December, and then released in June 2016 with a beta version, released in December in RC1, and released in March 2017 in RC2.

Today, with the concerted efforts of the community and the PINGCAP technical team, TIDB RC3 is now on-line, thanks to the community's small partners for their long-standing involvement and contribution .

Source Address: Https://github.com/pingcap/tidb