On January 19, 2018, TiDB released 1.1 Alpha. This release does a lot of work on MySQL compatibility, SQL optimizer, system stability, and performance.

TiDB

  • SQL parser
    • More syntax compatible
  • SQL query optimizer
    • Statistics Reduce memory usage
    • Optimize the loading time when statistics are started
    • More accurate cost estimation
    • Use the count-min Sketch to estimate the cost of spot checks more accurately
    • Support for more complex conditions and better use of indexes
  • SQL actuators
    • The Chunk structure is used to reconstruct all executor operators to improve analysis statement execution performance and reduce memory usage
    • Optimize INSERT INGORE statement performance
    • Push down for more types and functions
    • Support for more SQL_modes
    • To optimize theLoad DataPerformance, speed increased by 10 times
    • To optimize theUse Databaseperformance
    • Supports statistics on physical operator memory usage
  • Server
    • Support the PROXY protocol

PD

  • Add more apis
  • Support TLS
  • Add more cases to the Simulator
  • Scheduling is applicable to different region sizes
  • Fixed some scheduling bugs

TiKV

  • Support the Raft learner
  • Optimize Raft Snapshot to reduce IO overhead
  • Support TLS
  • Optimize RocksDB configuration to improve performance
  • Coprocessor supports more push-down operations
  • Add more Failpoint and stability test cases
  • Fixed reconnection between PD and TiKV
  • Enhanced the function of data recovery tool tiKV-CTL
  • Region Supports splitting by table
  • Supports the Delete range function
  • Supports I/O upper limit caused by snapshot
  • Improve flow control mechanism

Source code address: github.com/pingcap/tid…

Today, TiDB 1.1 Alpha has been released thanks to the community and PingCAP technology team for their continued participation and contributions.

As a world-class open source distributed relational database, TiDB is inspired by Google Spanner/F1 and has core features such as “distributed strong consistent transactions, online elastic horizontal scaling, high availability for fault recovery, and multi-activity across data centers”. TiDB was launched on GitHub in May 2015, followed by Alpha in December 2015, Beta in June 2016, RC1 in December, RC2 in March 2017, and RC3 in June. RC4 was released in August and TiDB 1.0 was released in October.