hit rate for the TiCDC Old Value in pessimistic transac- tions #10089 – Dumpling * Improve the logic of exporting data from TiDB v4.0 to avoid TiDB becoming out of memory (OOM) #273 * Fix the issue status_port: 20180 config: server.labels: { host: "logic-host-1" } - host: 10.0.1.1 port: 20161 status_port: 20181 config: server.labels: { host: "logic-host-2" } - host: 10.0.1.1 port: 20162 status_port: status_port: 20182 config: server.labels: { host: "logic-host-3" } tiflash_servers: - host: 10.0.1.1 monitoring_servers: - host: 10.0.1.1 grafana_servers: - host: 10.0.1.1 81 • user: "tidb": Use the tidb

status_port: 20180 config: server.labels: { host: "logic-host-1" } - host: 10.0.1.1 port: 20161 status_port: 20181 config: server.labels: { host: "logic-host-2" } - host: 10.0.1.1 port: 20162 status_port: status_port: 20182 config: server.labels: { host: "logic-host-3" } tiflash_servers: - host: 10.0.1.1 monitoring_servers: - host: 10.0.1.1 grafana_servers: - host: 10.0.1.1 108 • user: "tidb": Use the tidb schema. Step 5: Run the code Run the following command to execute the sample code: npm start Main logic in the sample code: // Step 1. Import the auto-generated `@prisma/client` package. import {Player

status_port: 20180 config: server.labels: { host: "logic-host-1" } - host: 10.0.1.1 port: 20161 status_port: 20181 config: server.labels: { host: "logic-host-2" } 95 - host: 10.0.1.1 port: 20162 status_port: status_port: 20182 config: server.labels: { host: "logic-host-3" } tiflash_servers: - host: 10.0.1.1 monitoring_servers: - host: 10.0.1.1 grafana_servers: - host: 10.0.1.1 • user: "tidb": Use the tidb schema. Step 5: Run the code Run the following command to execute the sample code: npm start Main logic in the sample code: // Step 1. Import the auto-generated `@prisma/client` package. import {Player

function #52779 @dveeden Before v8.2.0, you need to rely on external tools or customized validation logic for JSON data validation, which increases the complexity of development and maintenance, and reduces statements concur- rently, the performance is improved by 3 to 6 times #53246 @D3Hunter • Improve the logic of matching multi-column indexes using expressions like ((a �→ = 1 and b = 2 and c > 3)or (a = 4 status_port: 20180 config: server.labels: { host: "logic-host-1" } - host: 10.0.1.1 port: 20161 status_port: 20181 config: server.labels: { host: "logic-host-2" } 98 - host: 10.0.1.1 port: 20162 status_port:

applying the tidb_redact_log setting to the output of EXPLAIN state- ments and further optimize the logic in processing logs #54565 @hawkingrei • Support generating the Selection operator on IndexRangeScan status_port: 20180 config: server.labels: { host: "logic-host-1" } - host: 10.0.1.1 port: 20161 status_port: 20181 config: server.labels: { host: "logic-host-2" } 101 - host: 10.0.1.1 port: 20162 status_port: status_port: 20182 config: server.labels: { host: "logic-host-3" } tiflash_servers: - host: 10.0.1.1 monitoring_servers: - host: 10.0.1.1 grafana_servers: - host: 10.0.1.1 • user: "tidb": Use the tidb

collection task using the system variable tidb_auto_analyze_concurrency #53460 @hawkingrei • Optimize the logic of an internal function to improve performance when querying tables with numerous columns #52112 @Rustin170506 status_port: 20180 config: server.labels: { host: "logic-host-1" } - host: 10.0.1.1 port: 20161 status_port: 20181 config: server.labels: { host: "logic-host-2" } 128 - host: 10.0.1.1 port: 20162 status_port: status_port: 20182 config: server.labels: { host: "logic-host-3" } tiflash_servers: - host: 10.0.1.1 monitoring_servers: - host: 10.0.1.1 grafana_servers: - host: 10.0.1.1 • user: "tidb": Use the tidb

collection task using the system variable tidb_auto_analyze_concurrency #53460 @hawkingrei • Optimize the logic of an internal function to improve performance when querying tables with numerous columns #52112 @Rustin170506 status_port: 20180 123 config: server.labels: { host: "logic-host-1" } - host: 10.0.1.1 port: 20161 status_port: 20181 config: server.labels: { host: "logic-host-2" } - host: 10.0.1.1 port: 20162 status_port: status_port: 20182 config: server.labels: { host: "logic-host-3" } tiflash_servers: - host: 10.0.1.1 monitoring_servers: - host: 10.0.1.1 grafana_servers: - host: 10.0.1.1 • user: "tidb": Use the tidb system

@LykxSassinator • Add metrics for memory usage per thread #15927 @Connor1996 • PD • Optimize the logic for OperatorController to reduce the overhead of competition locks #7897 @nolouch • TiFlash 55 status_port: 20180 config: server.labels: { host: "logic-host-1" } - host: 10.0.1.1 port: 20161 status_port: 20181 config: server.labels: { host: "logic-host-2" } 98 - host: 10.0.1.1 port: 20162 status_port: status_port: 20182 config: server.labels: { host: "logic-host-3" } tiflash_servers: - host: 10.0.1.1 monitoring_servers: - host: 10.0.1.1 grafana_servers: - host: 10.0.1.1 • user: "tidb": Use the tidb

features or improvements are as follows: • Introduce temporary tables to simplify your application logic and improve performance • Support setting attributes for tables and partitions • Support creating 42 * Provides session-level data isolation, which enables you to design a simpler application logic. After the transaction finishes, the temporary tables are dropped. User document, #24169 • Support when backing up and restoring data in the SQL logical layer #27247 – Improve the default collection logic of ANALYZE when tidb_analyze_version is 2, which accelerates collection and reduces resource overhead

Support ordering the result of SHOW BINDINGS by (original_sql, update_time) #26139 – Improve the logic of query optimization when bindings exist, and reduce optimiza- tion times of a query #26141 – Support status_port: 20180 config: server.labels: { host: "logic-host-1" } - host: 10.0.1.1 port: 20161 status_port: 20181 config: server.labels: { host: "logic-host-2" } 80 - host: 10.0.1.1 port: 20162 status_port: status_port: 20182 config: server.labels: { host: "logic-host-3" } tiflash_servers: - host: 10.0.1.1 monitoring_servers: - host: 10.0.1.1 grafana_servers: - host: 10.0.1.1 • user: "tidb": Use the tidb