mysql - Munin MySQL插件的未知图形错误

Question

我安装了munin-node在 CentOS 7 上。监控系统资源的默认插件工作正常。我按照在线步骤启用 mysql_插入。但是，我遇到以下错误:

> sudo munin-run --debug mysql_
# Skipping systemd properties simulation due to lack of permissions.
# Processing plugin configuration from /etc/munin/plugin-conf.d/00-default
# Processing plugin configuration from /etc/munin/plugin-conf.d/munin-node
# Processing plugin configuration from /etc/munin/plugin-conf.d/mysql
# Setting /rgid/ruid/ to /4257/498/
# Setting /egid/euid/ to /4257 4257/498/
# Setting up environment
# Environment mysqlpassword = password
# Environment mysqlconnection = DBI:mysql:information_schema;mysql_read_default_file=/etc/my.cnf
# Environment mysqluser = munin
# Environment mysqladmin = /usr/bin/mysqladmin
# About to run '/etc/munin/plugins/mysql_'
Unknown graph  at /etc/munin/plugins/mysql_ line 1805.

这似乎是插件代码本身的问题。有没有其他人遇到过类似的问题和/或有修复？
设置步骤

$ sudo yum install munin-node

$ sudo ln -s /usr/share/munin/plugins/mysql_ /etc/munin/plugins/mysql_

创建 /etc/munin.plugin-conf.d/mysql与:

[mysql*]
env.mysqlconnection DBI:mysql:information_schema;mysql_read_default_file=/etc/my.cnf
env.mysqluser munin
env.mysqlpassword munin

在 MySQL 中创建 munin 用户:

CREATE USER 'munin'@'localhost' IDENTIFIED BY 'munin';
GRANT PROCESS, SUPER ON *.* TO 'munin'@'localhost';
GRANT SELECT ON mysql.* TO 'munin'@'localhost';
FLUSH PRIVILEGES;

$ sudo systemctl restart munin-node

Answer 1

munin-node 附带的默认 MySQL 插件安装对我们不起作用(原始帖子中提到的错误)。
相反，我们发现了这个对我们有用的替代插件:
https://github.com/kjellm/munin-mysql
由于 CentOS 7 使用 systemd，您必须更改 Makefile 中的行 $(MUNIN_NODE) restart至systemctl restart munin-node .
希望这可以帮助其他可能遇到与我们相同的问题的人。