Continuously read a mySQL table every 5 minutes

Grafana Dashboards
1

  • What Grafana version and what operating system are you using?
    8.5.2
    My Grafana is on site (NOT cloud)

  • What are you trying to achieve?
    I have mySQL table like this:
    CREATE TABLE System_Status (
    StatusDate datetime,
    DisplayName VarChar(40),
    status VarChar(10)
    );
    This table is to monitor whether a process on a number of given servers is running or not
    So the status field is “UP” or “Down”
    This table is updated every 5 minutes.

  • How are you trying to achieve it?
    I have created a dashboard for tabulated data in Grafana using this table as datasource. However I want Grafana to reload the table every 5 minutes to get the latest figures automatically.
    How do I do this?

  • What happened?
    However it only updates when I hit the ‘refresh’ button on the dashboard.

  • What did you expect to happen?
    I want the dashboard to be updated every 5 minutes from the lastest figures in the DB

Any help gratefully appreciated.

2

Have you read these docs on dashboard refreshing?

Refresh dashboard

Click the Refresh dashboard icon to immediately run every query on the dashboard and refresh the visualizations. Grafana cancels any pending requests when a new refresh is triggered.

By default, Grafana does not automatically refresh the dashboard. Queries run on their own schedule according to the panel settings. However, if you want to regularly refresh the dashboard, then click the down arrow next to the Refresh dashboard icon and then select a refresh interval.

3

Thanks to all.
Yes I’ve fixed the problem - you need to set the refresh rate in the top right hand corner of the dashboard