[Bug]: 1.2-dev standalone: sysbench bulk_insert 100threads test mo oom

[heni02]

Is there an existing issue for the same bug?

• [X] I have checked the existing issues.

Branch Name

1.2-dev

Commit ID

6cfdcaf20fb7cda1a027e1b5c0b837607d4442d7

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

job:https://github.com/matrixorigin/mo-nightly-regression/actions/runs/9536425137/job/26283375736 oom时间04:48:25

oom前heap： heap_019022b9-0526-7e0a-9b0c-648731f5cf5d.gz heap_019022b8-9007-7bef-889d-171780b05b15.gz heap_019022b9-ef97-7447-b429-f85a47b2af74 (1).gz heap_019022b9-7a5f-7937-bd29-6edbb5171dad.gz

mo log plz contact me

Expected Behavior

No response

Steps to Reproduce

sysbench  --mysql-host=127.0.0.1 --mysql-port=6001 --mysql-user=dump --mysql-password=111 bulk_insert.lua --mysql-db=sysbench_db --tables=10 --table_size=100000 --threads=100 --time=30 --report-interval=10 prepare
sysbench  --mysql-host=127.0.0.1 --mysql-port=6001 --mysql-user=dump --mysql-password=111  bulk_insert.lua --mysql-db=sysbench_db --tables=10 --table_size=100000 --threads=100 --time=300 --report-interval=10 --range_selects=off --point_selects=1 run

Additional information

No response

[gouhongshen]

129 env:

150G: heap_bulk_insert (1).out.zip

200G: heap_bulk_insert2 (1).out.zip

[w-zr]

目前没有进展

[w-zr]

目前没有进展

[w-zr]

目前没有进展

[w-zr]

目前没有进展

[w-zr]

目前正在优化手动merge操作。

[w-zr]

一个优化merge 内存占用的pr合进main了 我最近测一下

[w-zr]

最新的main上bulk insert 100没有oom

[w-zr]

最新的main上拉通跑sysbench 10w， bulk insert 1000没有OOM

[w-zr]

后续会把https://github.com/matrixorigin/matrixone/pull/17656 合并到1.2-dev上

[w-zr]

等#17734 合并了就可以了

[heni02]

confirm,closed