TiDB 3.0.9 Release Notes

Release date: January 14, 2020

TiDB version: 3.0.9

TiDB Ansible version: 3.0.9

TiDB

  • Executor
    • Fix the incorrect result when the aggregate function is applied to the ENUM column and the collection column #14364
  • Server
    • Support the auto_increment_increment and auto_increment_offset system variables #14396
    • Add the tidb_tikvclient_ttl_lifetime_reach_total monitoring metric to monitor the number of pessimistic transactions with a TTL of 10 minutes #14300
    • Output the SQL information in the log when the SQL query causes a panic during its execution #14322
    • Add the plan and plan_digest fields in the statement summary table to record the plan that is being executed and the plan signature #14285
    • Adjust the default value of the stmt-summary.max-stmt-count configuration item from 100 to 200 #14285
    • Add the plan_digest field in the slow query table to record the plan signature #14292
  • DDL
    • Fix the issue that the results of anonymous indexes created using alter table ... add index on the primary column is inconsistent with MySQL #14310
    • Fix the issue that VIEWs are mistakenly dropped by the drop table syntax #14052
  • Planner
    • Optimize the performance of statements such as select max(a), min(a) from t. If an index exists in the a column, the statement is optimized to select * from (select a from t order by a desc limit 1) as t1, (select a from t order by a limit 1) as t2 to avoid full table scan #14410

TiKV

  • Raftstore
    • Speed up the configuration change to speed up the Region scattering #6421
  • Transaction
    • Add the tikv_lock_manager_waiter_lifetime_duration, tikv_lock_manager_detect_duration, and tikv_lock_manager_detect_duration monitoring metrics to monitor waiters’ lifetime, the time cost of detecting deadlocks, and the status of Wait table #6392
    • Optimize the following configuration items to reduce transaction execution latency caused by changing Region leader or the leader of deadlock detector in extreme situations #6429
      • Change the default value of wait-for-lock-time from 3s to 1s
      • Change the default value of wake-up-delay-duration from 100ms to 20ms
    • Fix the issue that the leader of the deadlock detector might be incorrect during the Region Merge process #6431

PD

  • Support using backlash / in the location label name #2083
  • Fix the incorrect statistics because the tombstone store is mistakenly included by the label counter #2067

Tools

  • TiDB Binlog
    • Add the unique key information in the binlog protocol output by Drainer #862
    • Support using the encrypted password for database connection for Drainer #868

TiDB Ansible

  • Support automatically creating directories to optimize the deployment of TiDB Lightning #1105