Grafana panel refresh interval for DB queries

Grafana
,
1

Hello,

I was reading this section of the Grafana documentation - Use dashboards | Grafana documentation

I tried to imagine the following scenario. We have a set of panels that display data from DB queries. The dashboard default refresh is set to 5s. If we have 100 users viewing this dashboard at the same time does this mean that Grafana will trigger the queries on refresh for every single user? Is it possible to overload a database with such a setup?

2

Yes and yes. Caching may reduce the load on the DB (it depends on used queries): Reduce costs and increase performance with query caching in Grafana Cloud | Grafana Labs

1 Like
3

another thing you can look into is separating your oltp db and olap db

also using good indices, using stored procedures etc