scatter- ing policy to avoid the TiKV OOM issues caused by uneven distri- bution of regions during fast table cre- ation in batches. 59 Variable name Change type Description tidb_ �→ schema �→ _ �→ cache port and ex- port 8.4 8.3 8.2 8.1 7.5 7.1 6.5 6.1 5.4 5.3 5.2 5.1 Fast im- port us- ing TiDB Light- ning Y Y Y Y Y Y Y Y Y Y Y Y Fast im- port us- ing the IMPORT �→ �→ INTO �→ state- ment Y Y Y Y Y N 3.4.1 Connect to TiDB with node-mysql2 TiDB is a MySQL-compatible database, and node-mysql2 is a fast mysqljs/mysql com- patible MySQL driver for Node.js. In this tutorial, you can learn how to use TiDB

scatter- ing policy to avoid the TiKV OOM issues caused by uneven distri- bution of regions during fast table cre- ation in batches. 54 Variable name Change type Description tidb_ �→ schema �→ _ �→ cache port and ex- port 8.4 8.3 8.2 8.1 7.5 7.1 6.5 6.1 5.4 5.3 5.2 5.1 Fast im- port us- ing TiDB Light- ning Y Y Y Y Y Y Y Y Y Y Y Y Fast im- port us- ing the IMPORT �→ �→ INTO �→ state- ment Y Y Y Y Y N 3.4.1 Connect to TiDB with node-mysql2 TiDB is a MySQL-compatible database, and node-mysql2 is a fast mysqljs/mysql com- patible MySQL driver for Node.js. In this tutorial, you can learn how to use TiDB

and ADD COLUMN by 2 times #54436 @D3Hunter TiDB v8.0.0 introduces the system variable tidb_enable_fast_create_table to im- prove table creation performance in batch table creation scenarios. In v8.3.0 creating bindings. • The SQL execution plan binding supports more optimizer hints, and optimizes the conversion method for complex execution plans, making the binding more stable in restoring the execution plan im- port and ex- port 8.3 8.2 8.1 7.5 7.1 6.5 6.1 5.4 5.3 5.2 5.1 Fast im- port us- ing TiDB Light- ning Y Y Y Y Y Y Y Y Y Y Y Fast im- port us- ing the IMPORT �→ �→ INTO �→ state- ment Y Y Y Y N N

Fix the issue that checking binary versions might cause PD panic #7978 @JmPotato • Fix the type conversion error that occurs when TTL parameters are parsed #7980 @HuSharp • Fix the issue that the Leader 67 Data im- port and ex- port 8.1 7.5 7.1 6.5 6.1 5.4 5.3 5.2 5.1 Fast im- port us- ing TiDB Light- ning Y Y Y Y Y Y Y Y Y Fast im- port us- ing the IMPORT �→ �→ INTO �→ state- ment Y Y N N N N N 3.4.1 Connect to TiDB with node-mysql2 TiDB is a MySQL-compatible database, and node-mysql2 is a fast mysqljs/mysql com- patible MySQL driver for Node.js. In this tutorial, you can learn how to use TiDB

the issue of excessive statistical error in constructing statistics caused by Golang’s implicit conversion algorithm #49801 @qw4990 • Fix the issue that Daylight Saving Time is displayed incorrectly in 5 7.1 6.5 6.1 6.0 5.4 5.3 5.2 5.1 5.0 Automatically up- date statis- tics Y Y Y Y Y Y Y Y Y Y Y Fast An- a- lyze Deprecated Deprecated E E E E E E E E E Dynamic prun- ing Y Y Y Y Y E E E E E N Collect im- port and ex- port 7.6 7.5 7.1 6.5 6.1 5.4 5.3 5.2 5.1 5.0 4.0 Fast im- port us- ing TiDB Light- ning Y Y Y Y Y Y Y Y Y Y Y Fast im- port us- ing the IMPORT �→ �→ INTO �→ state- ment Y Y N N N N

Data im- port and ex- port 8.2 8.1 7.5 7.1 6.5 6.1 5.4 5.3 5.2 5.1 Fast im- port us- ing TiDB Light- ning Y Y Y Y Y Y Y Y Y Y Fast im- port us- ing the IMPORT �→ �→ INTO �→ state- ment Y Y Y N N N N 3.4.1 Connect to TiDB with node-mysql2 TiDB is a MySQL-compatible database, and node-mysql2 is a fast mysqljs/mysql com- patible MySQL driver for Node.js. In this tutorial, you can learn how to use TiDB types. • For the fields to be joined, ensure that the data types are consistent and avoid implicit conversion. • Avoid defining primary keys on a single monotonic data column. If you use a single monotonic

variables Variable name Change type Description tidb_enable_fast_analyze �→ Deprecated Controls whether to enable the statis- tics Fast �→ Analyze �→ fea- ture. This feature is dep- recated in v7.5 future versions. It is recommended to use PITR as an alternative solution for data recovery. • The Fast Analyze feature (experimental) for statistics is deprecated in v7.5.0. • The incremental collection common scenarios. #45384 @nolouch • Improve the performance of adding indexes with tidb_ddl_enable_fast_reorg �→ enabled. In internal tests, v7.5.0 improves the performance by up to 62.5% compared with

Before v8.0.0, after enabling the acceleration of ADD INDEX and CREATE INDEX (tidb �→ _ddl_enable_fast_reorg = ON), the encoded index key ingests data to TiKV with a fixed concurrency of 16, which cannot enable TiDB DDL V2. Start- ing from v8.0.0, this vari- able is re- named to tidb_ �→ enable �→ _ �→ fast �→ _ �→ create �→ _ �→ table �→ to better reflect its pur- pose. 51 Variable name Change type Description avail- able in a future release. 57 Variable name Change type Description tidb_ �→ enable �→ _ �→ fast �→ _ �→ create �→ _ �→ table �→ Newly added Controls whether to enable TiDB Accer- ates Table Cre-

Fix the issue that checking binary versions might cause PD panic #7978 @JmPotato • Fix the type conversion error that occurs when TTL parameters are parsed #7980 @HuSharp • Fix the issue that the Leader feed- back N N N N DeprecatedDeprecatedE E E Automatically up- date statis- tics Y Y Y Y Y Y Y Y Y Fast An- a- lyze DeprecatedDeprecatedE E E E E E E Dynamic prun- ing Y Y Y Y Y E E E E 62 Statistics 64 Data im- port and ex- port 8.1 7.5 7.1 6.5 6.1 5.4 5.3 5.2 5.1 Fast im- port us- ing TiDB Light- ning Y Y Y Y Y Y Y Y Y Fast im- port us- ing the IMPORT �→ �→ INTO �→ state- ment Y Y N N N N N

checkpoint mechanism for Fast Online DDL to improve fault tolerance and automatic recovery capability #42164 @tangenta TiDB v7.1.0 introduces a checkpoint mechanism for Fast Online DDL, which signifi- signifi- cantly improves the fault tolerance and automatic recovery capability of Fast Online DDL. Even if the TiDB owner node is restarted or changed due to failures, TiDB can 40 still recover progress from #38988 #24321 @tiancaiamao • Fix the issue that the error message is incorrect in certain type conversion errors #41730 @hawkingrei • Fix the issue that after a TiDB node is normally shutdown, DDL tasks