I have got large Grafana dashboard with load of panels.
Each panel executes query. And simulateneous queries make my victoria metrcis backend feel sick.
How can i configure grafana to load panels(execute queries) sequentially ?
Try setting “max_open_conn=1” in the Database section of grafana.ini
I’m not certain this will do what you need, but it looks encouraging.
Antony.
Panels that start out collapsed under a row wont execute their query until you expand them out, so that might be on one way to control the querying, but realistically you need to address this with your data source. Another approach is if several of the panels on the screen are using the same underlying data you can use one panel as the source for another panel which might reduce hits on the back end, assuming they both pull similar data.
Are you setting up your dashboard for querying a very high number of series or pulling a lot of history? At the end of the day you need to constrain the queries to not break your back end, or you need to scale up your back end to support the kind of queries you want to run in your dashboard. The viz layer is not going to be able to do some magic that allows you to exceed the capacity of whatever your are querying from.