deepflow icon indicating copy to clipboard operation
deepflow copied to clipboard

[BUG] Grafana ClickHouse Query Analysis面板数据展示几秒后无数据

Open chrisdamon opened this issue 11 months ago • 2 comments

Search before asking

  • [X] I had searched in the issues and found no similar feature requirement.

DeepFlow Component

Grafana Dashbaord

What you expected to happen

在ClickHouse Query Analysis dashboard展示数据的时候存在有两个问题: Q1: 数据查询慢,默认查询最近12h,数据加载很慢,调整成6h、3h、30m、15m、5m间隔数据加载还是慢 Q2:数据加载成功后面板突然变no data, 数据加载好过几秒,面板上面展示的都是no data,点击右上角 Refresh Dashboard按钮并不生效。 image

How to reproduce

No response

DeepFlow version

deepflow-server: v6.4 deepflow-agent: v6.4 grafana: v9.0.6

DeepFlow agent list

No response

Kubernetes CNI

No response

Operation-System/Kernel version

No response

Anything else

No response

Are you willing to submit a PR?

  • [ ] Yes I am willing to submit a PR!

Code of Conduct

chrisdamon avatar Mar 20 '24 09:03 chrisdamon

image

chrisdamon avatar Mar 20 '24 09:03 chrisdamon

https://ce-demo.deepflow.yunshan.net/d/ClickHouse_Query_Analysis/clickhouse-query-analysis?orgId=1

@chrisdamon ,前往这个 dashboard 评估下 clickhouse 的性能表现是否正常,以及 clickhouse 所在节点的负载是否很高。

另外能否提供一些规模信息:

  • agent 数量
  • server 数量
  • server cpu/mem 配置

sharang avatar Mar 29 '24 06:03 sharang

目前在多分片,但副本情况下,查询已无问题

1473371932 avatar Apr 23 '24 10:04 1473371932