Service - MySQL Metrics

Dashboard

This dashboard provides basic performance metrics for mysql/mariadb.
Last updated: 6 months ago

Downloads: 266

  • MySQL Metrics (Collectd) for InfluxDB - 002.png
    MySQL Metrics (Collectd) for InfluxDB - 002.png
  • MySQL Metrics (Collectd) for InfluxDB - 003.png
    MySQL Metrics (Collectd) for InfluxDB - 003.png
  1. install mysql support for python
  2. download mysql.py from https://github.com/chrisboulton/collectd-python-mysql/blob/master/mysql.py
  3. install & enable python plugin for collectd (see collectd config)
  4. some performance metrics are missing in the downloaded python script, you need to add them back manually by modifying the script.

Collector Configuration Details

<LoadPlugin python>

Globals true

</LoadPlugin>

<Plugin python>

ModulePath "/usr/lib64/python2.7"

</Plugin>

<Plugin python>

Import mysql

<Module mysql>

Host "localhost"

Port 3306

User "user"

Password "pass"

Verbose false

</Module>

</Plugin>

Download Dashboard
Dependencies: