数据WEB可视化工具Grafana RPM方式安装并图形展示MySQL数据源数据

桃扇骨 2023-10-06 11:59 62阅读 0赞

wget https://dl.grafana.com/oss/release/grafana-7.0.4-1.x86\_64.rpm

yum localinstall grafana-7.0.4-1.x86\_64.rpm

systemctl daemon-reload

systemctl enable grafana-server.service  
systemctl start grafana-server.service

netstat -an | grep 3000  
ps -ef | grep grafana

通过浏览器打开：http://localhost:3000/，

系统默认用户名和密码为admin/admin

首先设置 Data Sources，如下图所示

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FsbHdheTI_size_16_color_FFFFFF_t_70][]

然后新建一个 Graph 类型的 dashboard，点击 Panel Title，从列表中选择 Edit，将 Data Source 设置成上面给 Data Source 起的名字，并编写 sql 语句

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FsbHdheTI_size_16_color_FFFFFF_t_70 1][]

SELECT $\_\_timeEpoch(phpsnmp.snaps.\`datetime\`), cast(phpsnmp.processors.cpu\_load as unsigned int) as value, phpsnmp.processors.cpu\_id as metric from phpsnmp.snaps,phpsnmp.processors where $\_\_timeFilter(phpsnmp.snaps.\`datetime\`) and phpsnmp.snaps.snap\_id=phpsnmp.processors.snap\_id and phpsnmp.processors.device\_id=64 order by phpsnmp.processors.snap\_id,phpsnmp.processors.cpu\_id

注意：value一定是数值类型，如果是字符串需要转换

最终的显示效果

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FsbHdheTI_size_16_color_FFFFFF_t_70 2][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FsbHdheTI_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/2020062608381072.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FsbHdheTI=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FsbHdheTI_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200626083951160.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FsbHdheTI=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FsbHdheTI_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200626101620511.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2FsbHdheTI=,size_16,color_FFFFFF,t_70