Check_mysql_perf is a Nagios plugin used for monitoring MySQL database performance. It provides the ability to track various performance metrics.
One of the best things about check_mysql_perf is that it is incredibly easy to install and get started with. All you need is MySQL 5.0.x and Nagios (which is recommended but not required). Once you have downloaded and unpacked the archive, you simply need to call ./configure to get started. You also have the option to modify default settings using the --help command.
During installation, there are several options you can adjust to fit your specific needs. For example, you can specify the directory where you want to install check_mysql_perf using the --prefix=BASEDIRECTORY command. You can also specify the user and group that will own the script using the --with-nagios-user=SOMEUSER and --with-nagios-group=SOMEGROUP commands, respectively.
Another important option is the --with-mysql=DIR command, which allows you to specify the path to your MySQL installation. If this command is not used, check_mysql_perf will look for DIR/bin/mysql_config by default.
Finally, if you have unpacked and configured the "official" Nagios-Plugins, you can use the --with-officialplugins=DIR command to specify the directory where they are located. This is necessary because check_mysql_perf uses libraries provided by the nagios-plugins distribution.
Once you have finished with the installation process, you can start using check_mysql_perf to monitor your MySQL database. Some of the latest features of the tool include slow-queries, qcache-lowmem-prunes, bufferpool-wait-free, log-waits, -i, and -a.
Overall, check_mysql_perf is an excellent choice for anyone who needs to monitor the performance of their MySQL database. Thanks to its ease of use and rich feature set, it is a must-have tool for any system administrator or developer who works with MySQL on a regular basis.
Version 1.0: N/A