cockroachdb / cockroachdb/cockroach

roachtest: create roachtest testing sql stats with a high fingerprint cardinality workload

Open
#123,922 0 comments 0 reactions 1 assignee Claimed by @xinhaoz View on GitHub
C-enhancement T-observability
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

We should create a roachtest that runs the `sqlstats` workload to test the impacts of the sql stats collection process when it is required to operate at its limits:
Things to verify / test:
* What is the impact on rest of system of storing and flushing the maximum number of statement and transaction fingerprints
* Flush operation should complete in reasonable times - data should be persisted at a consistent rate
* The system should operate normally when throttling inserting more stats into in-memory containers - i.e. throttling should not trigger any special / edge case behaviours in resource consumption

Jira issue: CRDB-38602

Epic CRDB-39776

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.