cockroachdb / cockroachdb/cockroach

ts: maintaining time series costs a few percent of sysbench oltp_read_only throughput

Open
#135,901 2 comments 0 reactions 0 assignees View on GitHub
branch-master C-performance o-perf-efficiency T-observability
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

Not a scientific experiment, but: throughput on oltp_read_only with all background work and timeseries disabled is very stable, with timeseries enabled throughput oscillates between 41k and 43k. The effect is likely larger in practice in long-running clusters, as timeseries roll-ups and pruning also kicks in.

There is a direct effect of consuming CPU for these writes, but also timeseries writes were observed to contribute 7mb/s of steady state write traffic to disk, with bursty writes into the 70+mb/s range likely caused by compactions. Compactions occupy CPU for 10s of ms and thus significantly reduce the amount of foreground work the system can do.

TODO: run a more representative experiment.

SHA was 6a7b1e20e70c0ba8e6bb7a42d52512d9437cd75b

Jira issue: CRDB-44781

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.