matejzero/grafana-dashboards

Grafana dashboards

Grafana dashboards

In this repo you will find Grafana dashboards, that can be imported into Grafana >3.1 which has support for generic templates.

Inside each folder there is a README file describing the dashboards and additional configuration that needs to be done for dashboards to work.

##Thanks to:

• Chris Boulton (https://github.com/chrisboulton) for writing the MySQL Python plugin

License

MIT (http://www.opensource.org/licenses/mit-license.php)

grafana-dashboards's Issues

Import of carbon c relay dashboard has broken wallTime graphs

Thanks for this dashboard. I found an issue with how the wallTime graphs have set the units to "µs" instead of "µs". I have proposed PR#3 to resolve this.

Error updating options: invalid parameter "match[]": 1:8: parse error: unexpected character: '.'

I downloaded your Service - MySQL Overview.json at
https://github.com/matejzero/grafana-dashboards/blob/master/mysql/Service%20-%20MySQL%20Overview.json
but removed any ref to graphite and replaced it with Prometheus
When I go to dashboard I get

Error updating options: invalid parameter "match[]": 1:8: parse error: unexpected character: '.'

Thanks for your help

collect data error

exception like blow:
Unhandled python exception in read callback: ValueError: invalid literal for int() with base 10: 'log'
Nov 21 21:40:53 tw07149 collectd[22868]: Traceback (most recent call last):
Nov 21 21:40:53 tw07149 collectd[22868]: File "/usr/lib/collectd/python/collectd-mysql.py", line 544, in read_callback#012 innodb_status = fetch_innodb_stats(conn)
Nov 21 21:40:53 tw07149 collectd[22868]: File "/usr/lib/collectd/python/collectd-mysql.py", line 465, in fetch_innodb_stats#012 stats[key] = int(row[value])
Nov 21 21:40:53 tw07149 collectd[22868]: ValueError: invalid literal for int() with base 10: 'log'
Nov 21 21:40:53 tw07149 collectd[22868]: read-function of plugin `python.collectd-mysql' failed. Will suspend it for 20.000 seconds.
Nov 21 21:41:01 tw07149 collectd[18164]:

Parse error of `SHOW ENGINE INNODB STATUS`

Not sure why I got this, but I have this line which cannot be parsed:

 ibuf aio reads:, log i/o's:, sync i/o's:

There are no digits.

Added this for now:

@@ -436,6 +436,8 @@

     for line in status.split("\n"):
         line = line.strip()
+        if line.find("ibuf aio reads:,") != -1:
+            line  = re.sub(r':', ': 0', line)
         row  = re.split(r' +', re.sub(r'[,;] ', ' ', line))
         if line == '': continue