sists the vari- able value to the cluster. Changes the default value from OFF to ON after further tests, which means that the op- timizer is al- lowed to push Projection �→ down to the TiKV copro- cessor statements for query or write requests. For the tables with TiFlash replicas, TiDB uses the front-end optimizer to automatically choose the optimal execution plan. Note: The MPP mode of TiFlash is enabled duration integer not null, start_date datetime, end_date datetime, start_station_number integer, start_station varchar(255), end_station_number integer, end_station varchar(255), bike_number varchar(255)

statements for query or write requests. For the tables with TiFlash replicas, TiDB uses the front-end optimizer to automatically choose the optimal execution plan. Note: The MPP mode of TiFlash is enabled duration integer not null, start_date datetime, end_date datetime, start_station_number integer, start_station varchar(255), end_station_number integer, end_station varchar(255), bike_number varchar(255) LINES TERMINATED BY '\r\n' IGNORE 1 LINES (duration, start_date, end_date, start_station_number, start_station, end_station_number, end_station, bike_number, member_type); 3.5.2.1 Import all files Note:

statements for query or write requests. For the tables with TiFlash replicas, TiDB uses the front-end optimizer to automatically choose the optimal execution plan. Note: The MPP mode of TiFlash is enabled duration integer not null, start_date datetime, end_date datetime, start_station_number integer, start_station varchar(255), end_station_number integer, end_station varchar(255), bike_number varchar(255) LINES TERMINATED BY '\r\n' IGNORE 1 LINES (duration, start_date, end_date, start_station_number, start_station, end_station_number, end_station, bike_number, member_type); 3.5.2.1 Import all files Note:

statements for query or write requests. For the tables with TiFlash replicas, TiDB uses the front-end optimizer to automatically choose the optimal execution plan. Note: The MPP mode of TiFlash is enabled duration integer not null, start_date datetime, end_date datetime, start_station_number integer, start_station varchar(255), end_station_number integer, end_station varchar(255), bike_number varchar(255) LINES TERMINATED BY '\r\n' IGNORE 1 LINES (duration, start_date, end_date, start_station_number, start_station, end_station_number, end_station, bike_number, member_type); 3.5.2.1 Import all files Note:

large-scale clusters. �→ Real-world tests show that this feature can saturate the download �→ bandwidth, with the download speed improving by 8 to 10 times, and �→ the end-to-end restore speed improving by approximately statements for query or write requests. For the tables with TiFlash replicas, TiDB uses the front-end optimizer to automatically choose the optimal execution plan. Note: The MPP mode of TiFlash is enabled duration integer not null, start_date datetime, end_date datetime, start_station_number integer, start_station varchar(255), end_station_number integer, end_station varchar(255), bike_number varchar(255)

large-scale clusters. �→ Real-world tests show that this feature can saturate the download �→ bandwidth, with the download speed improving by 8 to 10 times, and �→ the end-to-end restore speed improving by approximately statements for query or write requests. For the tables with TiFlash replicas, TiDB uses the front-end optimizer to automatically choose the optimal execution plan. Note: The MPP mode of TiFlash is enabled duration integer not null, start_date datetime, end_date datetime, start_station_number integer, start_station varchar(255), end_station_number integer, end_station varchar(255), bike_number varchar(255)

use this feature with TiCDC. After pausing data replication and conducting pre-online read-write tests in your down- stream TiDB cluster, this feature allows the cluster to gracefully and quickly roll tidb_auto_analyze_partition_batch_size �→ Modified Changes the default value from 1 to 128 after further tests. tidb_sysproc_scan_concurrency �→ Modified In a large- scale cluster, the concur- rency of scan statements for query or write requests. For the tables with TiFlash replicas, TiDB uses the front-end optimizer to automatically choose the optimal execution plan. 122 Note: The MPP mode of TiFlash

from 1 to 2 after further tests. 42 Variable name Change type Description tidb_build_stats_concurrency �→ Modified Changes the default value from 4 to 2 after further tests. tidb_merge_partition_stats_concurrency TiCDC case- �→ sensitive �→ Modified Changes the default value from true to false after further tests, which means that the table names and database names in the TiCDC configu- ration file are case- insensitive 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 v6.5.0. #47757 @tangenta • TiKV •

large-scale clusters. �→ Real-world tests show that this feature can saturate the download �→ bandwidth, with the download speed improving by 8 to 10 times, and �→ the end-to-end restore speed improving by approximately #51372 @guo-shaoge • Fix the issue that ALTER TABLE ... COMPACT TIFLASH REPLICA might incor- rectly end when the primary key type is VARCHAR #51810 @breezewish • Fix the issue that the check on the NULL statements for query or write requests. For the tables with TiFlash replicas, TiDB uses the front-end optimizer to automatically choose the optimal execution plan. Note: The MPP mode of TiFlash is enabled

optimistic mode for merging and migrating sharded tables becomes GA DM adds a large number of scenario tests for tasks that merge and migrate data from sharded tables in the optimistic mode, which covers 90% Kafka par- ti- tions. TiCDCschema �→ - �→ registry �→ Newly added Specifies the schema reg- istry end- point that stores Avro schema. 78 Configuration file Configuration Change type Description DM worker concurrency tests, which ensures data consistency for each test. 5. Start the Sysbench client to perform the point_select, read_write, update_index, and update_non_index tests. Perform stress tests on TiDB