[Bug]: sysbench delete tps with index is much lower that without index

aressu1985 commented 7 months ago

Is there an existing issue for the same bug?

[X] I have checked the existing issues.

Branch Name

1.1-dev

Commit ID

32a05ab

Other Environment Information

- Hardware parameters:64C 256G
- OS type:
- Others:

Actual Behavior

on standlone mode, sysbench delete tps with index is much lower that without index: [with index]

[no index]

prof: delete_index.tar.gz delete_no_index.tar.gz

Expected Behavior

No response

Steps to Reproduce

1. run a mo standlone mode,and create two databases:sysbench_100w_no_auto_no_index,sysbench_100w_no_auto_index
2. git clone https://github.com/matrixorigin/mo-sysbench.git
3. prepare data:
sysbench --mysql-host=127.0.0.1 --mysql-port=6001 --mysql-user=dump --mysql-password='111' oltp_common.lua --mysql-db=sysbench_100w_no_auto_index  --tables=10 cleanup
sysbench --mysql-host=127.0.0.1 --mysql-port=6001 --mysql-user=dump --mysql-password='111' oltp_common.lua --mysql-db=sysbench_100w_no_auto_index --auto_inc=off --tables=10 --table_size=1000000 --threads=10  prepare

sysbench --mysql-host=127.0.0.1 --mysql-port=6001 --mysql-user=dump --mysql-password='111' oltp_common.lua --mysql-db=sysbench_100w_no_auto_no_index --create_secondary=off  --tables=10 cleanup
sysbench --mysql-host=127.0.0.1 --mysql-port=6001 --mysql-user=dump --mysql-password='111' oltp_common.lua --mysql-db=sysbench_100w_no_auto_no_index --auto_inc=off --create_secondary=off --tables=10 --table_size=1000000 --threads=10  prepare

4.run test
[no index]
sysbench  --mysql-host=127.0.0.1 --mysql-port=6001 --mysql-user=dump --mysql-password=111 --db-ps-mode=disable oltp_delete.lua --mysql-db=sysbench_100w_no_auto_no_index --tables=10 --table_size=1000000  --time=60 --report-interval=2 --threads=100 run

[with index]
sysbench  --mysql-host=127.0.0.1 --mysql-port=6001 --mysql-user=dump --mysql-password=111 --db-ps-mode=disable oltp_delete.lua --mysql-db=sysbench_100w_no_auto_index --tables=10 --table_size=1000000  --time=60 --report-interval=2 --threads=100 run

Additional information

No response

aunjgr commented 7 months ago

not working on it today

aunjgr commented 7 months ago

not working on it today

aunjgr commented 6 months ago

在解决中移物联的issue

aunjgr commented 6 months ago

not working on it today

aunjgr commented 6 months ago

not working on it today

aunjgr commented 5 months ago

not working on it today

aunjgr commented 5 months ago

等存储优化完成

aunjgr commented 5 months ago

待重新验证

aunjgr commented 5 months ago

等存储优化完成

aunjgr commented 5 months ago

not working on it today

aunjgr commented 4 months ago

not working on it today

aunjgr commented 4 months ago

not working on it today

aunjgr commented 4 months ago

not working on it today

aunjgr commented 4 months ago

not working on it today