« Changelog History


tidb v3.0.0-beta.1 Release Notes

Release Date: 2019-03-26 // about 5 years ago

  • ⚡️ SQL Optimizer

    • 👌 Support calculating the Cartesian product by using Sort Merge Join #9032
    • 👌 Support Skyline Pruning, with some rules to prevent the execution plan from relying too heavily on statistics #9337
    • 👌 Support Window Functions
    • ➕ Add a type of statistic that indicates the order correlation between columns and the handle column #9315 ### SQL Execution Engine
    • ➕ Add built-in functions:
    • ⚡️ Optimize the Chunk size based on the query context, to reduce the execution time of SQL statements and resources consumption of the cluster #6489 ### Privilege management
    • 👌 Support SET ROLE and CURRENT_ROLE #9581
    • 👌 Support DROP ROLE #9616
    • 👌 Support CREATE ROLE #9461 ### Server
    • ➕ Add the /debug/zip HTTP interface to get information of the current TiDB instance #9651
    • 👌 Support the show pump status and show drainer status SQL statements to check the Pump or Drainer status 9456
    • 👌 Support modifying the Pump or Drainer status by using SQL statements #9789
    • 👌 Support adding HASH fingerprints to SQL text for easy tracking of slow SQL statements #9662
    • ➕ Add the log_bin system variable ("0" by default) to control the enabling state of binlog; only support checking the state currently #9343
    • 👌 Support managing the sending binlog strategy by using the configuration file #9864
    • Support querying the slow log by using the INFORMATION_SCHEMA.SLOW_QUERY memory table #9290
    • 🔄 Change the MySQL version displayed in TiDB from 5.7.10 to 5.7.25 #9553
    • 🌲 Unify the log format for easy collection and analysis by tools
    • Add the high_error_rate_feedback_total monitoring item to record the difference between the actual data volume and the estimated data volume based on statistics #9209
    • ➕ Add the QPS monitoring item in the database dimension, which can be enabled by using a configuration item #9151 ### DDL
    • Add the ddl_error_count_limit global variable ("512" by default) to limit the number of DDL task retries (If this number exceeds the limit, the DDL task is canceled) #9295
    • 👌 Support ALTER ALGORITHM INPLACE/INSTANT #8811
    • 👌 Support the SHOW CREATE VIEW statement #9309
    • 👌 Support the SHOW CREATE USER statement #9240