What is the relationship between the increase in TSO latency and the load on TiDB, TiKV, and TiFlash, and how can it be optimized?

This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: TSO的耗时上升,与tid,tikv、tiflash的负载有哪些关系,怎样优化?

| username: anafin

[TiDB Usage Environment] Production Environment
[TiDB Version] 7.5.1

The TSO in the figure below is very unstable and is significantly affected by large analytical queries. Currently, the PD leader has been placed on a dedicated machine with low load, but the PD fellows overlap with KV and have a relatively high load.