TiDB 1.1 Alpha Release Notes

On January 19, 2018, TiDB 1.1 Alpha is released. This release has great improvement in MySQL compatibility, SQL optimization, stability, and performance.

TiDB

• SQL parser
  • Support more syntax
• SQL query optimizer
  • Use more compact structure to reduce statistics info memory usage
  • Speed up loading statistics info when starting tidb-server
  • Provide more accurate query cost evaluation
  • Use Count-Min Sketch to estimate the cost of queries using unique index more accurately
  • Support more complex conditions to make full use of index
• SQL executor
  • Refactor all executor operators using Chunk architecture, improve the execution performance of analytical statements and reduce memory usage
  • Optimize performance of the INSERT IGNORE statement
  • Push down more types and functions to TiKV
  • Support more SQL_MODE
  • Optimize the Load Data performance to increase the speed by 10 times
  • Optimize the Use Database performance
  • Support statistics on the memory usage of physical operators
• Server
  • Support the PROXY protocol

PD

• Add more APIs
• Support TLS
• Add more cases for scheduling Simulator
• Schedule to adapt to different Region sizes
• Fix some bugs about scheduling

TiKV

• Support Raft learner
• Optimize Raft Snapshot and reduce the I/O overhead
• Support TLS
• Optimize the RocksDB configuration to improve performance
• Optimize count (*) and query performance of unique index in Coprocessor
• Add more failpoints and stability test cases
• Solve the reconnection issue between PD and TiKV
• Enhance the features of the data recovery tool tikv-ctl
• Support splitting according to table in Region
• Support the Delete Range feature
• Support setting the I/O limit caused by snapshot
• Improve the flow control mechanism