Better Continuous Profiling

[hawkingrei]

Enhancement

Continuous profiling does not provide a good experience in TiDB; it lacks stack search capabilities and is not convenient for examining profiles over extended periods. It also does not support visualization for goroutines. Here, we can leverage the infrastructure of Pyroscope to implement this system, which will be far more reliable than what we have developed on our own.

for example, we can find this which can be optimized.

---

• reuse memory when to (*HashAggExec).initPartialWorkers #52321
• reuse memory for parallelSortSpillHelper‘s tmpSpillChunk #53861
• make channel frequently in the sortExec.Open #53866
• types.MakeDatums take too much time in the (*memtableRetriever).setDataFromTables #53886
• TiDB OOM when init stats #52219

[hawkingrei]

ref #52321

[hawkingrei]

ref #53861

[hawkingrei]

ref #53866

[hawkingrei]

ref #53868