search

mlabouardy / grafana-dashboards

List of Grafana Dashboards 📺
137 stars 117 forks source link

MySQL dashboard has a couple hardcoded servers in the queries #2

Closed joelsdc closed 6 years ago

joelsdc commented 6 years ago

Hi,

Nice job with this dashboard! I had to do some changes to make it work with my setup but it looks awesome... Just wanted to let you know you have hardcoded the 10.100.248.44:3306 server in a couple queries.

Offtopic, have you found a way for Telegraf pulling metrics from MySQL not messing up the graphs?

For example, I have to new servers installed that are not in production yet, just basic OS installacion + MySQL. I gather metrics every 10s, so with 0 prod traffic this is my current graph:

image

Any suggestion in how to handle those spikes every time Telegraf pulls data from MySQL?

Thanks! Joel.

mlabouardy commented 6 years ago

thanks ! fixed :) By default telegraf will gather all metrics, events & statistics, you can reduce number of requests by using the _intervalslow attribute - check https://github.com/influxdata/telegraf/tree/master/plugins/inputs/mysql