Custom MySQL Time Series Queries in Grafana 6

Article : https://medium.com/grafana-tutorials/custom-mysql-time-series-queries-in-grafana-47c5d312302e

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.