Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug]: nopk point randoms perf decreased significantly when running in the daily regression compared to running alone #20992

Open
1 task done
aressu1985 opened this issue Dec 27, 2024 · 2 comments
Assignees
Labels
kind/bug Something isn't working phase/testing severity/s0 Extreme impact: Cause the application to break down and seriously affect the use
Milestone

Comments

@aressu1985
Copy link
Contributor

Is there an existing issue for the same bug?

  • I have checked the existing issues.

Branch Name

2.0-dev

Commit ID

a060ad1

Other Environment Information

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

Actual Behavior

job link:
https://github.com/matrixorigin/mo-nightly-regression/actions/runs/12505371460/job/34888650007

[running in daily regression]
image

profile:
image
LOG_7c4dccb4-4d3c-41f8-b482-5251dc7a41bf_cpu_019405e6-26a0-79aa-bd7f-c54c6fa5bc89.gz

[running alone]
image

profile:
image

nopk_random_points_highter_cpu.tar.gz

Expected Behavior

No response

Steps to Reproduce

1、run daily regression
2. run no pk random points
sysbench  --mysql-host=127.0.0.1 --mysql-port=6001 --mysql-user=dump --mysql-password=111  oltp_write_only.lua --mysql-db=sysbench_db --tables=10 --table_size=100000 --threads=100 --time=30 --report-interval=10  cleanup
  
sysbench  --mysql-host=127.0.0.1 --mysql-port=6001 --mysql-user=dump --mysql-password=111 select_random_points.lua --mysql-db=sysbench_db --tables=10 --table_size=100000 --threads=100 --time=30 --report-interval=10 --secondary=on prepare

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

Additional information

No response

@badboynt1
Copy link
Contributor

daily流程里有点问题,nopk的场景下,索引没有建出来 需要修改 @heni02

@badboynt1
Copy link
Contributor

最新的daily已经没问题了

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
kind/bug Something isn't working phase/testing severity/s0 Extreme impact: Cause the application to break down and seriously affect the use
Projects
None yet
Development

No branches or pull requests

3 participants