Missing data, amount of missing data depending on selection time range

Grafana
1

Hi,

I am evaluating whether or not Grafana can help monitoring machinery.
We are using Grafana v7.5.5 (b5190ee547) on Ubuntu, using a MariaDB database.

(I know that MariaDB is not supported directly. We the MariaDB via MySQL data source. The basics are obviously working. If we decide for Grafana, we might have to switch to PostgreSQL)

The problem can be seen in the following screenshots.
The only thing that is changed from one picture to the next is the ‘Relative time range’, going from 24h, to 12h, to 6h and 1h. (edit: I am only allowed to upload to pictures per post. The other pictures will follow in a new post …)

24h
24h1920×1043 110 KB

12h
12h1920×1043 107 KB

A part of the data is not displayed. Obviously the data itself is present.
Especially problematic:
Most recent data is not displayed at all.

Any ideas what’s going wrong here / how to fix this?

Thanks and regards,
Martin

2

The other screenshots:

06h
06h1920×1043 95.4 KB

01h
01h1920×1043 65.1 KB

3

Bump

Any ideas, anyone …?

4

Hi @martinfleck

Grafana is used in edge scenarios, including manufacturing. There is a great video from GrafanaCON about a heat treating plant that is switch entirely to Grafana for their monitoring and alerting needs.

Also, in Grafana 8, streaming was introduced. You can now use a new endpoint to stream data in a stateless fashion at 60fps, or pass it through an mqtt broker at multiple frames per second in a more stateful way.

Also, to your problem: I don’t know what your query is, and yes, this might be a limitation with MariaDB, but your queries will work best when using global variables for setting time periods and intervals.

Here are some resources:

1 Like
5

This topic was automatically closed after 365 days. New replies are no longer allowed.