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
Methodewas spelled wrong in the configuration file. It was renamed toMethod. - The key
PidFileis ambiguous which could lead to problems and bugs. Thus it was changed to eitherMyPidFilefor fpmmm andDbPidFilefor 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_connectwarnings 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
getDistributionsupdated/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_waitandFromDual.MySQL.server.disk.avg_io_write_waitremoved because they are showing completely wrong values. UseFromDual.MySQL.server.disk.r_awaitandFromDual.MySQL.server.disk.w_awaitinstead. - 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_optionsbug in MySQL Galera Cluster added.
InnoDB
- Variable
innodb_log_file_sizemade consistent for MariaDB and MySQL. - Deprecated and removed variable
innodb_log_files_in_groupremoved. - Fix for
innodb_log_file_sizein MySQL 9.4. - Log occupancy graph added and graph added to dashboard.
- Variable
tx_isolationreplaced by transaction isolation which is deprecated in MariaDB 11.2 and MySQL 5.7.
MySQL
- Variable
vendor_versions_behindspecial case caught. - Connection charset changed from
utf8toutf8mb4due 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.

