FLASHBACK CLUSTER Y N N N N N N N 2.3.6 Transactions Transactions 6.5 6.1 5.4 5.3 5.2 5.1 5.0 4.0 Async commit Y Y Y Y Y Y Y N 1PC Y Y Y Y Y Y Y N Large transactions (10GB) Y Y Y Y Y Y Y Y Pessimistic from "fs"; // Step 2. Load environment variables from .env file to process.env. dotenv.config(); async function main() { // Step 3. Create a connection to the TiDB cluster. const options = { host: process TIDB_CA_PATH) : undefined } : null, } const conn = await createConnection(options); // Step 4. Perform some SQL operations... // Step 5. Close the connection. await conn.end(); } void main(); Note For TiDB

�→ Newly added Controls the sam- pling concur- rency of the ANALYZE �→ pro- cess. tidb_enable_async_merge_global_stats �→ Newly added This vari- able is used by TiDB to merge statis- tics asyn- chronously Improvements • TiDB • Optimize the concurrency model of merging GlobalStats: introduce tidb_enable_async_merge_global_stats �→ to enable simultaneous loading and merging of statistics, which speeds up the DDL Y N N N N N N N N N 2.3.6 Transactions Transactions 7.5 7.1 6.5 6.1 5.4 5.3 5.2 5.1 5.0 4.0 Async commit Y Y Y Y Y Y Y Y Y N 1PC Y Y Y Y Y Y Y Y Y N Large transactions (10GB) Y Y Y Y Y Y Y Y Y Y

meta Region leader reads on schema version updates #48125 @cfzjywxk • TiKV • Add an API endpoint /async_tasks for querying asynchronous tasks #15759 @YuJuncen • Add priority labels to gRPC monitoring N N N N N N N N N 2.3.6 Transactions Transactions 7.6 7.5 7.1 6.5 6.1 5.4 5.3 5.2 5.1 5.0 4.0 Async commit Y Y Y Y Y Y Y Y Y Y N 1PC Y Y Y Y Y Y Y Y Y Y N Large transactions (10GB) Y Y Y Y Y Y Y Y from "fs"; // Step 2. Load environment variables from .env file to process.env. dotenv.config(); async function main() { // Step 3. Create a connection to the TiDB cluster. const options = { host: process

CLUSTER Y Y N N N N N N N 2.3.6 Transactions Transactions 7.1 6.5 6.1 5.4 5.3 5.2 5.1 5.0 4.0 Async commit Y Y Y Y Y Y Y Y N 4Starting from v6.4.0, TiDB supports high-performance and globally monotonic from "fs"; // Step 2. Load environment variables from .env file to process.env. dotenv.config(); async function main() { // Step 3. Create a connection to the TiDB cluster. const options = { host: process TIDB_CA_PATH) : undefined } : null, } const conn = await createConnection(options); // Step 4. Perform some SQL operations... // Step 5. Close the connection. await conn.end(); } void main(); Note For TiDB

ashagg_spill sys- tem variable will be deprecated. • In v7.5.0, TiDB introduces the tidb_enable_async_merge_global_stats sys- tem variable to enable TiDB to merge partition statistics asynchronously to future versions, partition statistics will be merged asynchronously by default, and the tidb_enable_async_merge_global_stats system variable will be deprecated. 53 • It is planned to redesign the auto-evolution that involve data modification opera- tions #53951 @qw4990 • Fix the issue that the tidb_enable_async_merge_global_stats and tidb_ �→ analyze_partition_concurrency system variables do not take effect

statistics, so this system variable will be deprecated. • TiDB introduces the system variable tidb_enable_async_merge_global_stats in v7.5.0. You can use it to set TiDB to use asynchronous merging of partition Region scan time #7963 @lhy1024 • TiKV • Optimize the batching policy for writing Raft logs when async-io is enabled to re- duce the consumption of disk I/O bandwidth resources #16907 @LykxSassinator E N N N N N N N N 2.3.6 Transactions Transactions 8.3 8.2 8.1 7.5 7.1 6.5 6.1 5.4 5.3 5.2 5.1 Async commit Y Y Y Y Y Y Y Y Y Y Y 1PC Y Y Y Y Y Y Y Y Y Y Y Large transactions (1 TiB) Y Y Y Y Y Y Y

so this system variable will be deprecated. 84 • TiDB introduces the system variable tidb_enable_async_merge_global_stats in v7.5.0. You can use it to set TiDB to use asynchronous merging of partition AUTO_INCREMENT columns 94 2.3.6 Transactions Transactions 8.4 8.3 8.2 8.1 7.5 7.1 6.5 6.1 5.4 5.3 5.2 5.1 Async commit Y Y Y Y Y Y Y Y Y Y Y Y 1PC Y Y Y Y Y Y Y Y Y Y Y Y Large transactions (1 TiB) Y Y Y Y Y from "fs"; // Step 2. Load environment variables from .env file to process.env. dotenv.config(); async function main() { // Step 3. Create a connection to the TiDB cluster. const options = { host: process

so this system variable will be deprecated. 79 • TiDB introduces the system variable tidb_enable_async_merge_global_stats in v7.5.0. You can use it to set TiDB to use asynchronous merging of partition AUTO_INCREMENT columns 89 2.3.6 Transactions Transactions 8.4 8.3 8.2 8.1 7.5 7.1 6.5 6.1 5.4 5.3 5.2 5.1 Async commit Y Y Y Y Y Y Y Y Y Y Y Y 1PC Y Y Y Y Y Y Y Y Y Y Y Y Large transactions (1 TiB) Y Y Y Y Y from "fs"; // Step 2. Load environment variables from .env file to process.env. dotenv.config(); async function main() { // Step 3. Create a connection to the TiDB cluster. const options = { host: process

BDR mode E N N N N N N N N 2.3.6 Transactions Transactions 8.1 7.5 7.1 6.5 6.1 5.4 5.3 5.2 5.1 Async commit Y Y Y Y Y Y Y Y Y 1PC Y Y Y Y Y Y Y Y Y Large transactions (10GB) Y Y Y Y Y Y Y Y Y Pessimistic from "fs"; // Step 2. Load environment variables from .env file to process.env. dotenv.config(); async function main() { // Step 3. Create a connection to the TiDB cluster. const options = { host: process undefined } : null, } 198 const conn = await createConnection(options); // Step 4. Perform some SQL operations... // Step 5. Close the connection. await conn.end(); } void main(); Note For TiDB

BDR mode E N N N N N N N N 2.3.6 Transactions Transactions 8.1 7.5 7.1 6.5 6.1 5.4 5.3 5.2 5.1 Async commit Y Y Y Y Y Y Y Y Y 1PC Y Y Y Y Y Y Y Y Y Large transactions (10GB) Y Y Y Y Y Y Y Y Y Pessimistic from "fs"; // Step 2. Load environment variables from .env file to process.env. dotenv.config(); async function main() { // Step 3. Create a connection to the TiDB cluster. const options = { host: process PATH) : undefined } : null, } const conn = await createConnection(options); // Step 4. Perform some SQL operations... // Step 5. Close the connection. await conn.end(); } void main(); Note For TiDB