FromDual Performance Monitor for MySQL and MariaDB 0.10.5 has been released

FromDual has the pleasure to announce the release of the new version 0.10.5 of its popular Database Performance Monitor for MySQL, MariaDB, Galera Cluster and Percona Server fpmmm.

You can download fpmmm from here.

In the inconceivable case that you find a bug in fpmmm please report it to our Bug-tracker.

Any feedback, statements and testimonials are welcome as well! Please send them to feedback@fromdual.com.

This release contains various bug fixes and improvements. The previous release had some major bugs so we recommend to upgrade...

New installation of fpmmm v0.10.5

Please follow our fpmmm installation guide. A specific fpmmm installation guide will follow with the next version.

Prerequisites

CentOS 6

# yum install php-cli php-process php-mysqli

# cat << _EOF >/etc/php.d/fpmmm.ini
variables_order = "EGPCS"
date.timezone = 'Europe/Zurich'
_EOF

rpm -Uvh http://repo.zabbix.com/zabbix/2.2/rhel/6/x86_64/zabbix-release-2.2-1.el6.noarch.rpm
yum update
yum install zabbix-sender

CentOS 7

# yum install php-cli php-process php-mysqli

# cat << _EOF >/etc/php.d/fpmmm.ini
variables_order = "EGPCS"
date.timezone = 'Europe/Zurich'
_EOF

rpm -Uvh http://repo.zabbix.com/zabbix/2.2/rhel/7/x86_64/zabbix-release-2.2-1.el7.noarch.rpm
yum update
yum install zabbix-sender

Ubuntu 14.04

# apt-get install php5-cli php5-mysqlnd php5-curl

# cat << _EOF >/etc/php5/cli/conf.d/fpmmm.ini
variables_order = "EGPCS"
date.timezone = 'Europe/Zurich'
_EOF

apt-get install zabbix-agent

OpenSuSE 13.1

# zypper install php5 php5-posix php5-mysql php5-pcntl php5-curl

#cat << _EOF >/etc/php5/conf.d/fpmmm.ini
variables_order = "EGPCS"
date.timezone = 'Europe/Zurich'
_EOF

zypper addrepo http://download.opensuse.org/repositories/server:/monitoring/openSUSE_13.1 server_monitoring
zypper update
zypper install zabbix-agent

Upgrade from fpmmm 0.10.x to fpmmm 0.10.5

# cd /opt
# tar xf /download/fpmmm-0.10.5.tar.gz
# rm -f fpmmm
# ln -s fpmmm-0.10.5 fpmmm

The following templates in your Zabbix monitor should be replaced. Before you replace the templates it is a good idea to first delete all triggers...

• tpl/Template_FromDual.MySQL.fpmmm.xml
• tpl/Template_FromDual.MySQL.innodb.xml
• tpl/Template_FromDual.MySQL.master.xml
• tpl/Template_FromDual.MySQL.myisam.xml
• tpl/Template_FromDual.MySQL.mysql.xml
• tpl/Template_FromDual.MySQL.server.xml
• tpl/Template_FromDual.MySQL.slave.xml

Changes in fpmmm v0.10.5

fpmmm agent

• Better and more verbose error handling in various modules.
• Directory for log file is created automatically if it does not exist yet.
• All broken SQL queries (from 0.10.4) fixed again.
• Add delay for not so frequent changing data.
• Several triggers which complained after restart are fixed now.
• Connections to database were now reduced to the minimum.
• Links for templates fixed.
• Innodb_flush_log_at_trx_commit, log_queries_not_using_indexes and character_set_server triggers disabled by default.
• Also sendCachedData is now checked for too big cache file. Bug from swd.

Slave module

• Slave error messages are caught and sent to the monitor.
• Warning is written to the log file if slave module is configured without being a slave.
• New slave status is reported correctly now.
• Seconds_behind_master is now only sent when running.

Master module

• New trigger for binlog_format = MIXED and replication filtering added.
• Severity increased on STATEMENT based filtering added.
• Regexp bug fixed.
• Master without binary log fixed.

MySQL module

• Old broken triggers fixed.

Server module

• IOPS graph added.
• Device sda5 removed.
• I/O statistics calculation improved.
• I/O r/w wait experimental items implemented.
• CPU count added.
• NUMA and virtualization information added.

InnoDB module

• innodb_flush_method item added.
• Trigger for innodb_flush_method added.
• innodb_force_recovery trigger severity increased.
• innodb_log_files_in_group item added for log traffic threshold.
• InnoDB transaction log traffic trigger and graph added.

For subscriptions of commercial use of fpmmm please get in contact with us.