Welcome to the Pandora FMS Module Library

 
This is a library with modules, documentation and tools for Pandora FMS users, both public Open Source and Enterprise. Please use your support credentials (same as used to enter support/ticketing system) in the menu to your right. You will be granted access to a resourceful module library, such as Oracle, VMware, JBoss and others, ready to be used in production enviroments, with official professional support from Artica. If you do not own an enterprise account, you still can browse and download lots of modules, you can even register a free account and contribute with your own modules/tools for other public users.

Home > Application monitoring > Databases

MySQL performance plugin

Author: magulinb Create in: 03/19/2013 Update in: 03/19/2013
Rating:
Module type : Agent plugin


This plugin uses mysql to fetch the performance metrics from a mysql server.

To install it:
1. Verify that your system has mysql installed: $ mysql -V
2. Download the file "mysql_plugin".
3. Copy it to your agent plugins directory. F.ex. on my system in "/etc/pandora/plugins".
4. 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

Included files

  •  
    File: mysql_plugin Size: 42KiB
    Uploaded in: 03/01/2017
    Description: MySQL monitorization agent plugin