search

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.04k stars 3.8k forks source link

ui: QPS in Admin UI sidebar disagrees with SQL dashboard QPS #13611

Closed rjnn closed 7 years ago

rjnn commented 7 years ago

The sidebar rotates between ~7k-8k QPS

screenshot 2017-02-15 16 35 44

However, under the SQL dashboard, the "SQL Queries" shows

screenshot 2017-02-15 16 36 19

This is confirmed by the Grafana dashboard which shows

screenshot 2017-02-15 16 37 03

This is on cluster Denim, which is the first cluster running a new load generator (YCSB). I'm wondering if the new load pattern is uncovering a bug that we haven't seen with block writer or photos. This is currently a live cluster if that would be useful for debugging, let me know if I should not take this cluster down and preserve it as a running artifact (I currently have no plans to, but it is running with degraded performance, which I am scheduled to investigate in the next couple days, which might involve restarting load).

@mrtracy, assigning to you, could you please route this to the right person?

mrtracy commented 7 years ago

I can't duplicate this, the numbers seem to match on the clusters I'm checking. @arjunravinarayan can you let me know if this still reproduces? Moving to 1.1.

rjnn commented 7 years ago

Closing as I can't reproduce this now either, will reopen and preserve the cluster artifact if this is seen again.