cockroachdb / cockroachdb/cockroach

perf: intelligently enable global_reads (12% throughput TPC-C)

Open
#144,569 1 comment 0 reactions 0 assignees View on GitHub
C-enhancement C-performance o-perf-efficiency T-kv
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

In instances where a table is read-only (and more generally, read-mostly), there are significant advantages in enabling `global_reads`, which prevent the need to read from the leaseholder. In TPC-C, the `ITEM` table contains 100,000 items which are never modified once inserted. In benchmark runs (using BenchBase), enabling `global_reads` on the `ITEM` table yields a 12% throughput improvement (50 WH, 45 clients, 3 node cluster).

We should investigate methods for sampling table accesses and, in cases where a table is found to be read-only (or read-mostly), enable `global_reads` until the next sampling interval.

Jira issue: CRDB-49431

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.