Streaking in Time Series Data

Grafana MySQL
1

Hello all,

I am trying to resolve an issue in which data appears to be streaking erroneously across dashboard panels in my time series data plots. I have attempted reordering the data in the MySQL database table which feeds data into Grafana, but this has been unsuccessful in changing the panel’s appearance. When I limit the MySQL query in a given panel to include only the most recent 10,000 records, for instance, this issue resolves itself, but I want to be able to display all the historical data from my MySQL database. Has anyone seen an issue like this before, and if so how might I be able to resolve it? I should note that this streaking appears to most commonly begin at discontinuities in my data where the script I have running on a minutely basis to update the referenced table has failed to execute for one reason or another.

For context, I am running Grafana v10.2.2 on a Linux machine. I have attached a screenshot of the issue for reference. Thank you all for your consideration, and please let me know if there is any additional information I can provide to identify the issue + a potential solution.

Screenshot 2025-03-17 at 3.40.44 PM
Screenshot 2025-03-17 at 3.40.44 PM772×294 45.4 KB

2

BTW: it doesn’t make sense to visualize 10k data points on the physical display, which has less than 10k pixels (“high end” display have 4k pixels usually).

1 Like
3

I am receiving data on a minute-by-minute basis, so when I say “limit… to include only the most recent 10,000 records,” I mean that I’m limiting the historical scope of the data that people can navigate through to the previous ~1 week, which I do not want to do.

4

What does your query look like

5

Here is the query from the dashboard panel pictured above:
SELECT
time, SPN_GHI_Avg, PSP_GHI_Avg, CV_GHI_Avg
FROM
datalogger.Seventh_CR1000_Data

6

So you need to trim the result set to just what you want to see by using a where clause for your query.

SELECT
time, SPN_GHI_Avg, PSP_GHI_Avg, CV_GHI_Avg
FROM
datalogger.Seventh_CR1000_Data
WHERE time between x and y

Currently your query brings everything back since creation.
not sure what you mean by

I mean that I’m limiting the historical scope of the data that people can navigate through to the previous ~1 week, which I do not want to do.

if you do not want previous ~1 week, how much data do you want to go back to?

7

What I meant is that I want my query to bring everything back since creation, as you said.