matrixone
matrixone copied to clipboard
Published
20 hours ago •
matrixorigin
matrixorigin
[Bug]: sysbench delete tps with index is much lower that without index
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
