is a lot of garbage collection pressure on the JVM; this needs to be addressed by adding nodes, lowering cache sizes, or adjusting the JVM options regarding garbage collection. Tuning Compaction During

Reduce the number of column details fetched from TiKV for DELETE operations in certain scenarios, lowering the resource overhead of these operations #38911 @winoros • Support setting the concurrency within dirty_ratio is 20% and usually does not need adjustment. For high-performance SSDs such as NVMe devices, lowering this value helps improve the efficiency of memory reclamation. • dirty_background_ratio percentage perform GC on MVCC versions in memory, reducing the number of versions scanned during queries, thereby lowering request latency and reducing CPU overhead. The following diagram illustrates how TiKV organizes

Reduce the number of column details fetched from TiKV for DELETE operations in certain scenarios, lowering the resource overhead of these operations #38911 @winoros • Support setting the concurrency within dirty_ratio is 20% and usually does not need adjustment. For high-performance SSDs such as NVMe devices, lowering this value helps improve the efficiency of memory reclamation. • dirty_background_ratio percentage frequency. • If the resources are not properly controlled, they are prone to affect TP and AP tasks, lowering the database service quality. Enabling the DXF can solve the above problems and has the following

dirty_ratio is 20% and usually does not need adjustment. For high-performance SSDs such as NVMe devices, lowering this value helps improve the efficiency of memory reclamation. • dirty_background_ratio percentage frequency. • If the resources are not properly controlled, they are prone to affect TP and AP tasks, lowering the database service quality. Enabling the DXF can solve the above problems and has the following results in more frequent GC in Titan. Increasing the value reduces the frequency of Titan GC, thereby lowering the corresponding I/O bandwidth and CPU usage, but increases disk usage. 3435 • Default value:

dirty_ratio is 20% and usually does not need adjustment. For high-performance SSDs such as NVMe devices, lowering this value helps improve the efficiency of memory reclamation. • dirty_background_ratio percentage frequency. • If the resources are not properly controlled, they are prone to affect TP and AP tasks, lowering the database service quality. Enabling the DXF can solve the above problems and has the following results in more frequent GC in Titan. Increasing the value reduces the frequency of Titan GC, thereby lowering the corresponding I/O bandwidth and CPU usage, but increases disk usage. • Default value: 0.5

dirty_ratio is 20% and usually does not need adjustment. For high-performance SSDs such as NVMe devices, lowering this value helps improve the efficiency of memory reclamation. • dirty_background_ratio percentage frequency. • If the resources are not properly controlled, they are prone to affect TP and AP tasks, lowering the database service quality. Enabling the DXF can solve the above problems and has the following results in more frequent GC in Titan. Increasing the value reduces the frequency of Titan GC, thereby lowering the corresponding I/O bandwidth and CPU usage, but increases disk usage. • Default value: 0.5

dirty_ratio is 20% and usually does not need adjustment. For high-performance SSDs such as NVMe devices, lowering this value helps improve the efficiency of memory reclamation. • dirty_background_ratio percentage frequency. • If the resources are not properly controlled, they are prone to affect TP and AP tasks, lowering the database service quality. Enabling the DXF can solve the above problems and has the following results in more frequent GC in Titan. Increasing the value reduces the frequency of Titan GC, thereby lowering the corresponding I/O bandwidth and CPU usage, but increases disk usage. • Default value: 0.5

dirty_ratio is 20% and usually does not need adjustment. For high-performance SSDs such as NVMe devices, lowering this value helps improve the efficiency of memory reclamation. • dirty_background_ratio percentage frequency. • If the resources are not properly controlled, they are prone to affect TP and AP tasks, lowering the database service quality. Enabling the DXF can solve the above problems and has the following results in more frequent GC in Titan. Increasing the value reduces the frequency of Titan GC, thereby lowering the corresponding I/O bandwidth and CPU usage, but increases disk usage. • Default value: 0.5

dirty_ratio is 20% and usually does not need adjustment. For high-performance SSDs such as NVMe devices, lowering this value helps improve the efficiency of memory reclamation. • dirty_background_ratio percentage frequency. • If the resources are not properly controlled, they are prone to affect TP and AP tasks, lowering the database service quality. Enabling the DXF can solve the above problems and has the following results in more frequent GC in Titan. Increasing the value reduces the frequency of Titan GC, thereby lowering the corresponding I/O bandwidth and CPU usage, but increases disk usage. • Default value: 0.5

dirty_ratio is 20% and usually does not need adjustment. For high-performance SSDs such as NVMe devices, lowering this value helps improve the efficiency of memory reclamation. • dirty_background_ratio percentage frequency. • If the resources are not properly controlled, they are prone to affect TP and AP tasks, lowering the database service quality. Enabling the TiDB backend task distributed execution framework can transfer when sending them to TiKV, thus reducing the amount of data transferred over the network and lowering the network bandwidth overhead. In the earlier TiDB versions before this feature is supported, TiDB