Better Continuous Profiling

## 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](https://grafana.com/oss/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.

-----------------------------

- [x] https://github.com/pingcap/tidb/issues/52321
- [x] https://github.com/pingcap/tidb/issues/53861
- [x] https://github.com/pingcap/tidb/issues/53866
- [ ] https://github.com/pingcap/tidb/issues/53886
- [x] https://github.com/pingcap/tidb/issues/52219
- [x] https://github.com/pingcap/tidb/issues/58784