matrixorigin / matrixone

Hyperconverged cloud-edge native database
https://docs.matrixorigin.cn/en
Apache License 2.0
1.78k stars 276 forks source link

[Bug]: sharding extensibility doesn't work. #19052

Open Ariznawlll opened 1 month ago

Ariznawlll commented 1 month ago

Is there an existing issue for the same bug?

Branch Name

zhangxu19830126

Commit ID

0dd4e4c28

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

image

Expected Behavior

No response

Steps to Reproduce

修改环境启动配置cn副本为1,tke环境启动mo集群,sysbench 10w(10个分区) update测试,观察tps:

git clone https://github.com/matrixorigin/matrixone.git
cd mo-sysbench

(1)sysbench  --mysql-host=172.16.108.201 --mysql-port=6001 --mysql-user=dump --mysql-password=111 oltp_update_index.lua --mysql-db=sysbench_db --tables=1 --table_size=100000 --threads=100 --time=30 --report-interval=10  cleanup

(2)创建分区表:
sysbench  --mysql-host=172.16.108.201 --mysql-port=6001 --mysql-user=dump --mysql-password=111 oltp_update_index.lua --mysql-db=sysbench_db --tables=1 --table_size=100000 --threads=100 --time=30 --report-interval=10  prepare

(3)执行测试60s:
sysbench  --mysql-host=172.16.108.201 --mysql-port=6001 --mysql-user=dump --mysql-password=111  oltp_update_index.lua --mysql-db=sysbench_db --tables=1 --table_size=100000 --threads=100 --time=60 --report-interval=10  --range_selects=off --point_selects=1 run

修改环境启动配置cn副本为2,(3)中--threads参数修改为200,启动测试60s
修改环境启动配置cn副本为3,(3)中--threads参数修改为300,启动测试60s
修改环境启动配置cn副本为4,(3)中--threads参数修改为400,启动测试60s

Additional information

No response

zhangxu19830126 commented 2 weeks ago

目前看, partition的range导致的,xiliang在解决。

zhangxu19830126 commented 1 week ago

等解决partition的问题

zhangxu19830126 commented 1 week ago

等解决 partition 的问题

zhangxu19830126 commented 1 week ago

等解决 partition 的问题

zhangxu19830126 commented 1 week ago

等解决 partition 的问题

zhangxu19830126 commented 2 days ago

等解决了 parittion 的问题再看。