Update in: 5 March 2024
Important Notice: This plugin is no longer actively maintained or updated. We strongly advise you to explore alternative plugins available in our library for the latest features and support.
This plugin uses mysql to fetch the performance metrics from a mysql server.
To install it:
- Verify that your system has mysql installed: $ mysql -V
- Download the file “mysql_plugin”.
- Copy it to your agent plugins directory. F.ex. on my system in “/etc/pandora/plugins”.
- Make it executable: $ chmod +x /etc/pandora/plugins/mysql_plugin
To use it you need a mysql user, for that I create a user with only select privileges:
mysql> GRANT SELECT ON *.* to (user)@localhost identified by '(password)';
NOTE: Maybe less privileges are needed, but NEVER user the mysql root account.
Then just call it from the config file of your agent with the following line:
"module_plugin memory_plugin (user) (password)"
For more plugin options or change warning and critical levels see its code.
Module data
Depends on: mysql