Grafana : Custom MySQL Time Series Queries

Channel:
United Kingdom SBCODE
Subscribers:
24,900
Published on ● Video Link: https://www.youtube.com/watch?v=dONVA2ViZ9c


Duration: 9:44
0 views
3

Documentation : https://sbcode.net/grafana/custom-mysql_time_series_query/

We can create custom MySQL time series queries that read data from our custom tables in our custom MySQL databases and reformat the result sets in a way that Grafana can use in visualisations.

Typically for any database that you have, the column names will vary. In this video, I will write a query in Grafana that will read from this custom table with its own custom column names and reformat that data into the format that Grafana can use for the Graph visualization.

After you have completed the steps, you can then save your dashboard with your new visualization that contained your custom query. You can adapt this example any way you wish to suit your own database tables.

#grafana
#grafanaMysql
#grafanaEngineer



Other Videos By SBCODE


2020-09-03Install Prometheus Dashboards in Grafana 7
2020-09-03Install Prometheus Service and Data Source in Grafana 7
2020-09-02Read Nginx Logs with Promtail, Loki 1.9.x and Grafana 7
2020-09-01Annotation Queries Linking the Log and Graph Panels : Grafana 7, Loki 1.9
2020-08-31Loki 1.9.x LogQL in Grafana 7
2020-08-27Install Loki Data Source and Explore in Grafana 7
2020-08-27Install Promtail Binary and Start as a Service in Grafana 7
2020-08-26Install Loki Binary and Start as a Service in Grafana 7
2020-08-23Zabbix : Reading Windows Event Logs in Zabbix
2020-08-22Graph Non Time Series Data in Grafana 7
2020-08-22Grafana : Custom MySQL Time Series Queries
2020-08-21Custom MySQL Time Series Queries in Grafana 6
2020-08-19Install MySQL Dashboard and Collector in Grafana 7
2020-08-18Grafana : Create MySQL Data Source in Grafana
2020-08-17Proxy Design Pattern
2020-08-17Composite Design Pattern
2020-08-17Facade Design Pattern
2020-08-17Decorator Design Pattern
2020-08-17Adapter Design Pattern
2020-08-17Mediator Design Pattern
2020-08-17Iterator Design Pattern


Tags:
grafana
grafana engineer
mysql
grafana mysql
grafana mysql query