perf: flushing SQL stats to disk consumes significant cpu (1.5% cpu)

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.

https://www.cockroachlabs.com

Other

30.19k stars 3.82k forks source link

perf: flushing SQL stats to disk consumes significant cpu (1.5% cpu) #136324

Open ajstorm opened 1 day ago

ajstorm commented 1 day ago

When running sysbench oltp_read_write we're seeing that disabling sql.stats.flush.enabled yields 1.5% higher QPS. We should investigate whether we can reduce this overhead and/or turn this off by default.

Jira issue: CRDB-44974

blathers-crl[bot] commented 1 day ago

Hi @ajstorm, please add branch-* labels to identify which branch(es) this C-bug affects.

_{:owl: Hoot! I am a Blathers, a bot for CockroachDB. My owner is dev-inf.}