FromDual Performance Monitor 2.2.1 has been released

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

The FromDual Performance Monitor enables Database and System Administrators to monitor and understand what is going on inside their databases and on the machines where the databases reside.

More information you can find here: FromDual Performance Monitor.

Download

The new FromDual Performance Monitor can be downloaded from our Sofware Download page or you can use our repositories. How to install and use the FromDual Performance Monitor is documented in the Documentation.

In the inconceivable case that you find a bug in the FromDual Performance Monitor please report it to us by sending an email.

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

Monitoring as a Service (MaaS)

You do not want to set-up your database monitoring yourself? No problem: Choose our Monitoring as a Service (MaaS) to safe time and costs!

Installation of Performance Monitor 2.2.1

How to install the FromDual Performance Monitor you can find in the Installation Guide.

Upgrade of fpmmm tar ball from 1.x to 2.2.1

There are some changes in the configuration file (fpmmm.conf):

  • The access rights should be change as follows: chmod 600 /etc/fpmmm.conf
  • The key Methode was spelled wrong in the configuration file. It was renamed to Method.
  • The key PidFile is ambiguous which could lead to problems and bugs. Thus it was changed to either MyPidFile for fpmmm and DbPidFile for the database.

Upgrade with DEB/RPM packages should happen automatically. For tar balls follow this instruction:

$ cd /opt
$ tar xf /download/fpmmm-2.2.1.tar.gz
$ rm -f fpmmm
$ ln -s fpmmm-2.2.1 fpmmm

Changes in FromDual Performance Monitor 2.2.1

These release notes include both the changes that came with version 2.2.0 and version 2.2.1.

This release contains new features and various bug fixes.

You can verify your current FromDual Performance Monitor version with the following command:

$ /opt/fpmmm/bin/fpmmm --version

General

  • Updated to latest myEnv library.
  • PHP 8.5 incompatibilities fixed.
  • Typos fixed.
  • Error messages improved.
  • Function real_connect warnings send to console are suppressed now.
  • Connection problems timeout reduced so in case of troubles we should see more and earlier…
  • Other cosmetic errors and debugging information fixed.
  • Data are gathered and set to zero even thought database is not reachable.
  • Indention of logged messages fixed.
  • Function exit is logged now as well.
  • SSL connection handling added.
  • Fix of error: array_sum(): Addition is not supported on type string in warning after upgrade to Ubuntu 24.04/PHP 8.3.
  • Error log parsing had problems with huge error logs. Now we have added a size barrier.
  • Function getDistributions updated/cleaned-up.
  • Command lsb_release removed.
  • Documentation added.
  • Nagios: Tests fixed for MariaDB 11.8.

Templates

  • Server: Available I/O system information added to each I/O system on top, pages named.
  • InnoDB: Pages named, row write operations graph added.
  • MySQL: Some graphs and query dashboard made nicer.

Agent

  • none

Server

  • Items FromDual.MySQL.server.disk.avg_io_read_wait and FromDual.MySQL.server.disk.avg_io_write_wait removed because they are showing completely wrong values. Use FromDual.MySQL.server.disk.r_await and FromDual.MySQL.server.disk.w_await instead.
  • Workaround for missing cpuinfo old cachefile implemented.

Galera

  • Old style variable fixed which causes problems with newer version.
  • Default values on database stop added.
  • Workaround for cut wsrep_provider_options bug in MySQL Galera Cluster added.

InnoDB

  • Variable innodb_log_file_size made consistent for MariaDB and MySQL.
  • Deprecated and removed variable innodb_log_files_in_group removed.
  • Fix for innodb_log_file_size in MySQL 9.4.
  • Log occupancy graph added and graph added to dashboard.
  • Variable tx_isolation replaced by transaction isolation which is deprecated in MariaDB 11.2 and MySQL 5.7.

MySQL

  • Variable vendor_versions_behind special case caught.
  • Connection charset changed from utf8 to utf8mb4 due to errors in MariaDB 11.8.
  • Template pages named.

Process

  • none

Security

  • Module improved for new behaviour in MariaDB 11.8.

Master

  • Wrong version check for master fixed.

Slave

  • Slave lagging problem fixed.
  • Wrong version check for slave fixed.
  • MySQL 8.4 commands added for replication monitoring.

Backup

  • none

PostgreSQL

  • Rudimentary PostgreSQL monitoring added.

Packaging

  • RHEL 8 added again.
  • RPM spec adapted for RHEL 10.
  • SNMP library updated.
  • Debian 10 and RHEL 7 removed.
  • DEB sign stuff added.

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