Grafana
is a cool Open Source tool You can use to create amazing dashboards.
Here are some of the dashboards we developed to monitor relational databases.
Maybe they are not the best, but we found them useful.
Some of these dashboard are shared in the official
Grafana Site too.
But there were other dashboards that were too simple or too specialized or too new
to be published there... and here they are!
| Dashboard | JSON File | Note |
| 2MySQL Simple Dashboard | Download | A MySQL dashboard. Fully described here (in Italian). Published also on the Grafana site! |
| Processlist | Download | The SHOW PROCESSLIST infos with some additions: locks and most demanding SQL statements |
| Space Usage | Download | Space usage statistics |
| Performance | Download | Several useful MySQL performance statistics |
| Threads | Download | Threads statistics |
| 2MySQL Simple Dashboard 4 MariaDB | Download | A specialized version for MariaDB. Published on the Grafana site too! |
| 4All MySQLs | Download | Multi-row dashboard for several MySQL DB together |
| 3CH Simple Dashboard | Download | A ClickHouse dashboard. Published on the Grafana site! |
| CH Queries | Download | Shows running queries on ClickHouse. Similar to the Hagens' one but linked to 3CH dashboard and with the possibility to choose databases |
| CH DDV | Download | Shows table and column definition. Published on the Grafana site too! |
| 4Pg Simple Dashboard | Download | A PostgreSQL dashboard. Published on the Grafana site! |
| Performance | Download | Several useful PostgreSQL performance statistics |
| 4Oracle Simple Dashboard | Download | An Oracle dashboard. Published on the Grafana site! |
Some of these Consoles are already published in the Grafana Dashboards Official Site but here they are refreshed more often.
Data collection is important too!
my2Collector for MySQL (GitHub),
my2Collector latest version,
ch2Collector for ClickHouse,
pgStatsPack for PostgreSQL,
...
Those dashboards use Telegraf as collector:
| Dashboard | JSON File | Note |
| MySQL | Download | A MySQL dashboard. Published also on the X Grafana site! |
Those dashboards do not need any collector at all!
| Dashboard | JSON File | Note |
| My DDV | Download | Shows table and column definition. Published on the Grafana site too! |
| Processlist | Download | The SHOW PROCESSLIST infos with some additions: locks and most demanding SQL statements |
| CH DDV | Download | Shows table and column definition. Published on the Grafana site too! |
| Pg DDV | Download | Shows table and column definition. Published on the X Grafana site too! |
Title: YAGC: Yet Another Grafana Console
Level: Advanced
Date:
14th February 2020 ❤️ San Valentino
Version: 1.0.1 - 1st April 2022 🐟
Author: mail [AT] meo.bogliolo.name