Note_Tech

All technological notes.

---

Project maintained by simonangel-fong Hosted on GitHub Pages — Theme by mattgraham

Prometheus - Grafana Data Source: MySQL

Back

• Prometheus - Grafana Data Source: MySQL
  • Data Source: MySQL

---

Data Source: MySQL

• Use Grafana to visualize time series data in MySQL.

• Query must return 3 mandatory columns:

  • metric: the metric name
  • value: the metric value
  • time_sec: the unix time stamp, can use unix_timestamp function

---

• 1. Create mysql data source with credential
     • create a read-only user for grafana
• 1. Create Dashboard
• 1. Query:

SELECT
    unix_timestamp(s.SalesDateTime) AS time_sec
    , p.ProductName AS metric
    , Sum(s.Amount) AS value
FROM Products AS p
JOIN Sales AS s
ON p.ProductID = s.ProductID
GROUP BY p.ProductName, s.SalesDataTime
HAVING $__timeFilter(s.SalesDataTime)       -- filter timerange dynamically.
;