参考文献
Using InfluxDB in Grafana
准备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中。
配置Grafana的数据源
![6ddaa66be288a7e053f51fc38f8c427a.png](https://i-blog.csdnimg.cn/blog_migrate/ef1ccafa43343ea1ad5e23aad2c5893d.png)
![2ddbfcb3bbd4d8fac3e3d98e598b3ca4.png](https://i-blog.csdnimg.cn/blog_migrate/a233f548c4e209ff3d8a105a428f2951.png)
填写基本连接访问influxdb数据库的信息,点击下方的test
按钮,可以测试是否连接成功。
创建Table表
![0e65869d31746933c493f7ea0a601f7c.png](https://i-blog.csdnimg.cn/blog_migrate/ece5c1207a29a6defc36482d4ac57944.png)
![2203605a34ec58476f84b02599e0cc85.png](https://i-blog.csdnimg.cn/blog_migrate/543e1fb09482d21ace2cbcb1ce174eff.png)
点击表格的Edit
按钮,就可以进入编辑页面,下面主要讲如何获取数据到图表呈现。
设置数据的查询语句,并图表呈现
![dc5ef30ddb776b9fd4b6f278d6ddc0c8.png](https://i-blog.csdnimg.cn/blog_migrate/becf0c2ce5f5a56f0a885b881dcd14a2.png)
![9dd2fe9a7cd03373aeed0f080a2d9692.png](https://i-blog.csdnimg.cn/blog_migrate/02c8db74f72790a4659216c951602ebe.png)
设置好查询语句,因为我的数据是3月4号的,所以还要设置一下时间区间才可以查询出来,如下:
![c74514c40a40c974faff7afd82c4cdcf.png](https://i-blog.csdnimg.cn/blog_migrate/83ca6c59e3dc5e0e77a23dbc8a44e2f2.png)
制造曲线图
![ddf0fe695c0d4189864392ac519a0037.png](https://i-blog.csdnimg.cn/blog_migrate/0b74a7c67faa0f6cdde604c6a2348f60.png)