Live data from Hacker News

Grafana 7.0

grafana.com

41–50 of 101 posts

Re: Grafana 7.0

#41
post #23

It would be nice to have yearly, monthly, weekly and other recurring graph, I tried to hack it with sql window function, but it gives lot of problems. https://community.grafana.com/t/yearly-monthly-weekly-and-ot...

There is the timeshift function in the query editor but that is per panel and not per query. So you would have to have a panel per year.

It should be possible with SQL but it is trickier. TSDB's like Prometheus, Graphite and Influxdb (Flux) have the timeshift function built into their query languages. (https://community.grafana.com/t/advanced-graphing-part2-visu...)

Re: Grafana 7.0

#42
post #23

It would be nice to have yearly, monthly, weekly and other recurring graph, I tried to hack it with sql window function, but it gives lot of problems. https://community.grafana.com/t/yearly-monthly-weekly-and-ot...

There is the timeshift function in the query editor but that is per panel and not per query. So you would have to have a panel per year. It should be possible with SQL but it is trickier. TSDB's like Prometheus, Graphite and Influxdb (Flux) have the timeshift function built into their query languages. ( https://community.grafana.com/t/advanced-graphing-part2-visu... )

We are also working on an expression language to backfill other data sources. You can see the frontend version of this - transformations in 7.0. The backend version which will support functions like timeshift is in alpha for now. Hopefully it will be officially released in the near future.

Re: Grafana 7.0

#44
post #37
post #2

Hi, my name is Torkel Ödegaard. Grafana project creator & lead. Here to answer any questions.

Is it now possible to create a horizontal lined based on a single value (either a fixed or a computed number)? For example when I'm tracking the power grid frequency, I would like to add two lines at 50.05 and 49.95 Hz, as well as one at 50 Hz (with different color). Others have voiced their desire to display a horizontal line at the 95th percentile in a bandwidth usage graph.

Maybe the thresholds feature in Grafana would work for you?

Otherwise depending on the database, they have functions for drawing lines or you can do a hack like this one for Prometheus:

https://play.grafana.org/d/h1lglb7ik/threshold-hack?editPane...

Re: Grafana 7.0

#46
post #12
post #2

Hi, my name is Torkel Ödegaard. Grafana project creator & lead. Here to answer any questions.

Hi, I used Grafana in my last company and absolutely loved it. How do I convince my current company to get the hell off Datadog?

The cost aspect is one thing. Vendor lock-in another. Probably need to have a team that can lead the transition towards Grafana, educate and speak for it. Grafana has an enterprise plugin for datadog that potentially could ease the migration

Re: Grafana 7.0

#47
post #26
post #2

Hi, my name is Torkel Ödegaard. Grafana project creator & lead. Here to answer any questions.

At work we have to compile everything from source because compliance, and Grafana is one of the harder ones to get right. There used to be good documentation for it a few versions back but I can't seem to find it lately. Is there any good documentation on how to get Grafana compiled from source?

Please let us know and/or open an GitHub issue describing if there are any certain part/step making it hard to build from source. Thanks

Re: Grafana 7.0

#48

Earlier quoted context omitted.

Are we any closer to having some kind of anomaly detection in grafana (when using prometheus)?

Just curious: what kind of anomaly detection are you looking for? Can you describe the kind of thing you'd want this system to detect?

We have all sorts of data flowing into Prometheus and charted in Grafana. Grafana lets me alert based on thresholds and that works fine for many things.

EXAMPLE 1:

Imagine a service. Load avg of 2 is unacceptable and means things will be slowing down. However, a heavy job runs every night and pushes load averages between 1.5 and 2.5 during a 30 minute window.. I wanted to set a load avg alert threshold @ 2.0 but can't since it would fire false alarms too often. So i end up setting it at 3, and end up getting a late alert when things get really bad.

Instead, an anomaly detection would look for a number of standard deviations away from a mean, and ideally account for seasonality (i.e. compare the data with same data last few weeks). Now, things will behave better. If loads hit 2 during the day, it'll fire. But during that 30 minute window at night, loads would need to exceed 3 before it fires.

EXAMPLE 2:

Let's say I'm tracking 30 metrics for a service. I understand the service well enough to set thresholds in 5 metrics. However, I'm sure a failure won't happen alone and the other 25 metrics may show some oddities and give me an early warning of "something wrong happening" .. Here, some kind of loose "anomaly alerts" could help as an early warning. If a certain metric throws too many false alerts, we find a better way to monitor it.

EXAMPLE 3:

Lets say you have a service that auto scales. There's no limit to how many requests the service handles. So I can't really thresholds on requests/5min. Here, some kind of "anomaly alert" would be useful to let the team know that something is going on that's causing a high level of requests. Again, accounting for seasonality because things tend to change on weekends.

At the end of the day, an anomaly alert is not some "magic solution" but just and extra tool in the toolkit to use when it makes sense. Datadog and AWS both have built in easy to use anomaly alerting. Would be nice for grafana/prometheus to have something similar.

Re: Grafana 7.0

#49

Earlier quoted context omitted.

Are we any closer to having some kind of anomaly detection in grafana (when using prometheus)?

Have you seen this talk/blog from last year's Monitorama about anomaly detection with Prometheus: https://about.gitlab.com/blog/2019/07/23/anomaly-detection-u...

Yes, I saw this last year. Complicated and requires a lot of effort on the user's part compared to let's say CloudWatch anomaly alerting: https://docs.aws.amazon.com/AmazonCloudWatch/latest/monitori...

Re: Grafana 7.0

#50
post #43

I like grafana for graphing but it still lacks essential features for alerting. Most important would be per-series state tracking ( https://github.com/grafana/grafana/issues/6041 ) - the issue is open since 2016 and it does not look like it will ever be fixed :-(

What datasource are you using? I've only used Grafana as a visualizer and use other alerting/monitoring against that datasources. At my current employer, Prometheus is the data source and we use Alert Manager which allows us to write alerts in PromQL which is very flexible.
Post reply on HN