FromDual Performance Monitor for MariaDB and MySQL 1.1.0 has been released

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

The FromDual Performance Monitor for MariaDB and MySQL (fpmmm) enables DBAs and System Administrators to monitor what is going on inside their MariaDB and MySQL databases and on their machines where the databases reside.

More detailed information your can find in the fpmmm Installation Guide.

Download

The new FromDual Performance Monitor for MariaDB and MySQL (fpmmm) can be downloaded from here. How to install and use fpmmm is documented in the fpmmm Installation Guide.

In case you find a bug in the FromDual Performance Monitor for MariaDB and MySQL please report it to the FromDual Bugtracker or just send us 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 MariaDB and MySQL Monitoring as a Service (Maas) program to safe time and costs!

Installation of Performance Monitor 1.1.0

A complete guide on how to install FromDual Performance Monitor you can find in the fpmmm Installation Guide.

Upgrade from 1.0.x to 1.1.0

shell> cd /opt
shell> tar xf /download/fpmmm-1.1.0.tar.gz
shell> rm -f fpmmm
shell> ln -s fpmmm-1.1.0 fpmmm

Changes in FromDual Performance Monitor for MariaDB and MySQL 1.1.0

This release contains various bug fixes.

You can verify your current FromDual Performance Monitor for MariaDB and MySQL version with the following command:

shell> fpmmm --version

General

• fpmmm is now available for Cent OS with RPM packages and for Ubuntu with DEB packages.
• MariaDB 10.4 seems to work and thus is officially declared as supported.
• TimeZone made configurable.
• Error printed to STDOUT changed to STDERR.
• Return codes made unique.
• De-support PHP versions older than 7.0.
• All old PHP 5.5 stuff removed, we need now at least PHP 7.0.
• Cosmetic fixes and error handling improved.

fpmmm agent

• Error message typo fixed.
• All mpm remainings removed.
• Upload: Error exit handling improved.

fpmmm Templates

• InnoDB Template: Links to mysql-forum replaced by links to fromdual.com.
• Templates: Zabbix 4.0 templates added and tpl directory restructured.

fpmmm Modules

• Backup: Backup hook added to templates as example.
• InnoDB: InnoDB buffer pool flushing data and graph added.
• InnoDB: innodb_metrics replacing mostly SHOW ENGINE INNODB STATUS.
• InnoDB: Started replacing SHOW ENGINE INNODB STATUS by I_S.innodb_metrics with Adaptive Hash Index (AHI).
• InnoDB: innodb_file_format removed.
• InnoDB: InnoDB files items and graph added.
• InnoDB: Negative values of innodb_buffer_pool_pages_misc_b fixed.
• InnoDB: Bug report of Wang Chao about InnoDB Adaptive Hash Index (AHI) size fixed.
• Memcached: Memcached module fixed.
• MySQL: MariaDB thread pool items and graph added.
• MySQL: Slow Queries item fixed and graph added.
• Server: Smartmon monitor added to monitor HDD/SSD.
• Server: Server module made more robust and numactl replaced by cpuinfo.
• Server: Server free function adapted according to Linux free command.
• Server: Function getFsStatsLinux added for global file descriptor limits.
• Aria: Aria cleaned-up, old mariadb_* variables removed, Aria transaction log graph added.
• Aria: Aria pagecache blocks converted to bytes.

fpmmm agent installer

• No changes.

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