[Bug]: sysbench randoms point perf fluctuate significantly on daily regression

[aressu1985]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

2.0-dev

Commit ID

a060ad1

Other Environment Information

- Hardware parameters:
3*CN: 16C 64G
1*DN: 16C 64G
3*LOG: 4C 16G
3*PROXY: 3C 7G
- OS type:
- Others:

Actual Behavior

[tps = 38483.32]
job link:
https://github.com/matrixorigin/mo-nightly-regression/actions/runs/12468455215/job/34813223925

profile:

https://grafana.ci.matrixorigin.cn/explore?panes=%7B%226VN%22:%7B%22datasource%22:%22pyroscope%22,%22queries%22:%5B%7B%22groupBy%22:%5B%5D,%22labelSelector%22:%22%7B%20pod%20%3D%20%27nightly-regression-dis-tp-cn-9qvrv%27%7D%22,%22queryType%22:%22both%22,%22refId%22:%22A%22,%22profileTypeId%22:%22process_cpu:cpu:nanoseconds:cpu:nanoseconds%22,%22datasource%22:%7B%22type%22:%22grafana-pyroscope-datasource%22,%22uid%22:%22pyroscope%22%7D%7D%5D,%22range%22:%7B%22from%22:%221734990420000%22,%22to%22:%221734990779000%22%7D%7D%7D&schemaVersion=1&orgId=1

[tps = 57880]
job link:
https://github.com/matrixorigin/mo-nightly-regression/actions/runs/12455141774

profile:

https://grafana.ci.matrixorigin.cn/explore?panes=%7B%226VN%22:%7B%22datasource%22:%22pyroscope%22,%22queries%22:%5B%7B%22groupBy%22:%5B%5D,%22labelSelector%22:%22%7B%20pod%20%3D%20%27nightly-regression-dis-tp-cn-lsnkv%27%7D%22,%22queryType%22:%22both%22,%22refId%22:%22A%22,%22profileTypeId%22:%22process_cpu:cpu:nanoseconds:cpu:nanoseconds%22,%22datasource%22:%7B%22type%22:%22grafana-pyroscope-datasource%22,%22uid%22:%22pyroscope%22%7D%7D%5D,%22range%22:%7B%22from%22:%221734731460000%22,%22to%22:%221734731819000%22%7D%7D%7D&schemaVersion=1&orgId=1

Expected Behavior

No response

Steps to Reproduce

NA

Additional information

No response

[badboynt1]

tps变低的时候， CollectOffsetsByPrefixInFactory这个函数，以及gc的开销明显变大了。 这是最主要的两块
@XuPeng-SH

[gouhongshen]

这个函数的实现看起来没啥问题，可能是调用的频次或者 prefix in 带的数据变多了，要进一步排查。

[gouhongshen]

no progress