Skip to content

Latest commit

 

History

History
50 lines (44 loc) · 5.54 KB

release-2.0.6.md

File metadata and controls

50 lines (44 loc) · 5.54 KB
Raw
title aliases summary
TiDB 2.0.6 Release Notes
/docs/dev/releases/release-2.0.6/
/docs/dev/releases/206/
TiDB 2.0.6 was released on August 6, 2018, with improvements in system compatibility and stability. The release includes various improvements and bug fixes for TiDB and TiKV. Some notable improvements include reducing transaction conflicts, improving row count estimation accuracy, and adding a recover mechanism for panics during the execution of `ANALYZE TABLE`. Bug fixes address issues such as incompatible `DROP USER` statement behavior, OOM errors for `INSERT`/`LOAD DATA` statements, and incorrect results for prefix index and `DECIMAL` operations. TiKV also sees improvements in scheduler slots, rollback transaction records, and RocksDB log file management, along with a fix for a crash issue during data type conversion.

TiDB 2.0.6 Release Notes

On August 6, 2018, TiDB 2.0.6 is released. Compared with TiDB 2.0.5, this release has great improvement in system compatibility and stability.

TiDB

  • Improvements
    • Make "set system variable" log shorter to save disk space #7031
    • Record slow operations during the execution of ADD INDEX in the log, to make troubleshooting easier #7083
    • Reduce transaction conflicts when updating statistics #7138
    • Improve the accuracy of row count estimation when the values pending to be estimated exceeds the statistics range #7185
    • Choose the table with a smaller estimated row count as the outer table for Index Join to improve its execution efficiency #7277
    • Add the recover mechanism for panics occurred during the execution of ANALYZE TABLE, to avoid that the tidb-server is unavailable caused by abnormal behavior in the process of collecting statistics #7228
    • Return NULL and the corresponding warning when the results of RPAD/LPAD exceed the value of the max_allowed_packet system variable, compatible with MySQL #7244
    • Set the upper limit of placeholders count in the PREPARE statement to 65535, compatible with MySQL #7250
  • Bug Fixes
    • Fix the issue that the DROP USER statement is incompatible with MySQL behavior in some cases #7014
    • Fix the issue that statements like INSERT/LOAD DATA meet OOM after opening tidb_batch_insert #7092
    • Fix the issue that the statistics fail to automatically update when the data of a table keeps updating #7093
    • Fix the issue that the firewall breaks inactive gPRC connections #7099
    • Fix the issue that prefix index returns a wrong result in some scenarios #7126
    • Fix the panic issue caused by outdated statistics in some scenarios #7155
    • Fix the issue that one piece of index data is missed after the ADD INDEX operation in some scenarios #7156
    • Fix the wrong result issue when querying NULL values using the unique index in some scenarios #7172
    • Fix the messy code issue of the DECIMAL multiplication result in some scenarios #7212
    • Fix the wrong result issue of DECIMAL modulo operation in some scenarios #7245
    • Fix the issue that the UPDATE/DELETE statement in a transaction returns a wrong result under some special sequence of statements #7219
    • Fix the panic issue of the UNION ALL/UPDATE statement during the process of building the execution plan in some scenarios #7225
    • Fix the issue that the range of prefix index is calculated incorrectly in some scenarios #7231
    • Fix the issue that the LOAD DATA statement fails to write the binlog in some scenarios #7242
    • Fix the wrong result issue of SHOW CREATE TABLE during the execution process of ADD INDEX in some scenarios #7243
    • Fix the issue that panic occurs when Index Join does not initialize timestamps in some scenarios #7246
    • Fix the false alarm issue when ADMIN CHECK TABLE mistakenly uses the timezone in the session #7258
    • Fix the issue that ADMIN CLEANUP INDEX does not clean up the index in some scenarios #7265
    • Disable the Read Committed isolation level #7282

TiKV

  • Improvements
    • Enlarge scheduler's default slots to reduce false conflicts
    • Reduce continuous records of rollback transactions, to improve the Read performance when conflicts are extremely severe
    • Limit the size and number of RocksDB log files, to reduce unnecessary disk usage in long-running condition
  • Bug Fixes
    • Fix the crash issue when converting the data type from string to decimal