We have been sing Gafana since last month for plotting some metric into the dashboard,
Interestingly, When our data set starts to grow the performance of dashboard decreases drastically.
- Panels used:- 8
- database :- Mysql
- Time taken by the query to run from sql client :- < 500 ms
- Dashboard load Time if i select time duration as 30 days > 10 sec and at many times one or more panels keeps on loading.
- Total Number of rows in DB >2.2 million records
- Records returned in response 15k in 1 panel
- Grafana version 5.2.1
- OS Ubuntu
Can you please guide us how to tune Grafana to avoid such issues?