[Bug]: lock consumes too much memory and OOM during daily run

[XuPeng-SH]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

main

Commit ID

latest

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

Expected Behavior

No response

Steps to Reproduce

https://github.com/matrixorigin/mo-nightly-regression/actions/runs/14081187486/job/39478806526

https://grafana.ci.matrixorigin.cn/explore?panes=%7B%223Ff%22:%7B%22datasource%22:%22pyroscope%22,%22queries%22:%5B%7B%22groupBy%22:%5B%5D,%22labelSelector%22:%22%7Bpod%3D%5C%22nightly-regression-dis-tp-cn-7qckm%5C%22%7D%22,%22queryType%22:%22both%22,%22refId%22:%22A%22,%22profileTypeId%22:%22memory:inuse_space:bytes:space:bytes%22,%22datasource%22:%7B%22type%22:%22grafana-pyroscope-datasource%22,%22uid%22:%22pyroscope%22%7D%7D%5D,%22range%22:%7B%22from%22:%22now-3h%22,%22to%22:%22now%22%7D%7D%7D&schemaVersion=1&orgId=1

Additional information

No response

[iamlinjunhong]

在一个事务中 每次插入一行，插入 1000w 次，会导致事务持有 1000w lock；并且并发的执行很多这样的事务，会导致内存膨胀，然后 oom。

https://grafana.ci.matrixorigin.cn/explore?panes=%7B%22f8U%22:%7B%22datasource%22:%22loki%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bnamespace%3D%5C%22mo-search-nightly-a486ef578-20250410%5C%22%7D%20%7C%3D%20%60count%20of%20lock%20and%20waiter%60%20%7C~%20%60%5C%22lock-count%5C%22:%5B1-9%5D%5B0-9%5D%5B0-9%5D%5B0-9%5D%5B0-9%5D%5B0-9%5D%2A%60%22,%22queryType%22:%22range%22,%22datasource%22:%7B%22type%22:%22loki%22,%22uid%22:%22loki%22%7D,%22editorMode%22:%22builder%22%7D%5D,%22range%22:%7B%22from%22:%221744249955926%22,%22to%22:%221744269300939%22%7D%7D%7D&schemaVersion=1&orgId=1

[iamlinjunhong]

已让 @heni02 先修改插入方式