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.

Sign up for GitHub

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

Jump to bottom

roachtest: add sysbench suite to roachperf #123071

Closed
nvanbenschoten opened this issue Apr 25, 2024 · 1 comment · Fixed by #124664
Closed

roachtest: add sysbench suite to roachperf #123071

nvanbenschoten opened this issue Apr 25, 2024 · 1 comment · Fixed by #124664
Assignees
@DarrylWong
Labels
A-testing Testing tools and infrastructure C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) C-performance Perf of queries or internals. Solution not expected to change functional behavior. T-testeng TestEng Team

Comments

@nvanbenschoten
Copy link
Member

nvanbenschoten commented Apr 25, 2024 •
edited by cockroach-jira-scripts
Loading

We run the following sysbench tests nightly:

➜ roachtest list sysbench
Listing tests which match regex "sysbench" and are compatible with cloud "gce".

sysbench/oltp_delete/nodes=3/cpu=32/conc=256 [test-eng]
sysbench/oltp_insert/nodes=3/cpu=32/conc=256 [test-eng]
sysbench/oltp_point_select/nodes=3/cpu=32/conc=256 [test-eng]
sysbench/oltp_read_only/nodes=3/cpu=32/conc=256 [test-eng]
sysbench/oltp_read_write/nodes=3/cpu=32/conc=256 [test-eng]
sysbench/oltp_update_index/nodes=3/cpu=32/conc=256 [test-eng]
sysbench/oltp_update_non_index/nodes=3/cpu=32/conc=256 [test-eng]
sysbench/oltp_write_only/nodes=3/cpu=32/conc=256 [test-eng]

These should be marked as benchmarks and uploaded to roachperf so that we can track performance over time and catch performance regressions.

Jira issue: CRDB-38187
@nvanbenschoten nvanbenschoten added C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) C-performance Perf of queries or internals. Solution not expected to change functional behavior. A-testing Testing tools and infrastructure T-testeng TestEng Team labels Apr 25, 2024
@blathers-crl blathers[crl]
Copy link

blathers-crl bot commented Apr 25, 2024

cc @cockroachdb/test-eng

@renatolabs renatolabs mentioned this issue May 20, 2024
Closed
@DarrylWong DarrylWong mentioned this issue May 24, 2024
Merged
@craig craig bot closed this as completed in ea234e2 May 24, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@DarrylWong DarrylWong

Labels
A-testing Testing tools and infrastructure C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) C-performance Perf of queries or internals. Solution not expected to change functional behavior. T-testeng TestEng Team
Projects
No open projects
Test Engineering
Status: Done
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

roachtest: export sysbench results to roachperf DarrylWong/fork
2 participants
@nvanbenschoten @DarrylWong