Grafana使用InfluxDB作为数据源，呈现图表

Devops海洋的渔夫

发布于 2019-05-31 10:36:30

1K0

发布于 2019-05-31 10:36:30

准备InfluxDB的相关查询语句

> SELECT * FROM "CPU_All3" WHERE time < now() - 5m and "Idle%" =~ /94.5/ and host =~ /qc_predepl_cms/
name: CPU_All3
time                Cpus Idle% Steal% Sys% User% Wait% host
----                ---- ----- ------ ---- ----- ----- ----
1551689409000000000 4    94.5  0      0.9  0.7   3.9   qc_predepl_cms-ngx-02
> 
> SELECT * FROM "CPU_All3" WHERE host =~ /qc_predepl_cms/ limit 10
name: CPU_All3
time                Cpus Idle% Steal% Sys% User% Wait% host
----                ---- ----- ------ ---- ----- ----- ----
1551689409000000000 4    94.5  0      0.9  0.7   3.9   qc_predepl_cms-ngx-02
1551689412000000000 4    99.8  0      0.2  0.1   0     qc_predepl_cms-ngx-02
1551689415000000000 4    99.5  0      0    0.1   0.4   qc_predepl_cms-ngx-02
1551689418000000000 4    99.4  0      0.1  0.1   0.4   qc_predepl_cms-ngx-02
1551689421000000000 4    99.7  0      0.2  0.2   0     qc_predepl_cms-ngx-02
1551689424000000000 4    99.7  0      0.1  0.1   0.2   qc_predepl_cms-ngx-02
1551689427000000000 4    99.5  0      0.2  0.2   0.2   qc_predepl_cms-ngx-02
1551689430000000000 4    99.7  0      0.2  0.2   0     qc_predepl_cms-ngx-02
1551689433000000000 4    99.7  0      0.1  0.2   0.1   qc_predepl_cms-ngx-02
1551689436000000000 4    99.8  0      0.1  0.1   0     qc_predepl_cms-ngx-02
>

下面就在Grafana执行SELECT * FROM "CPU_All3" WHERE host =~ /qc_predepl_cms/查询出表里面的数据，并呈现在Grafana中。