FromDual Performance Monitor for MySQL 1.2.0 has been released

FromDual has the pleasure to announce the release of the new version 1.2.0 of its popular Database Performance Monitor for MySQL fpmmm.

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

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

Download

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

In the inconceivable case that you find a bug in the FromDual Performance Monitor for MySQL please report it to the FromDual Bug-tracker 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 MySQL Monitoring as a Service (Maas) program to safe time and costs!

Installation of Performance Monitor 1.2.0

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

Upgrade of fpmmm tarball from 1.0.x to 1.2.0

Upgrade with DEB/RPM packages should happen automatically. For tarballs follow this:

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

Changes in FromDual Performance Monitor for MySQL 1.2.0

This release contains new features and various bug fixes.

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

shell> fpmmm --version

General

• MySQL 8.0 problems fixed. Fpmmm supports MySQL 8.0 now!
• Naming convention for Type changed from host to machine and mysqld to instance, including downwards compatibility.
• New host screens added.
• All Screens removed because they are customer specific, we have host screens now.
• Zabbix templates adapted to the more flexible trigger URL.
• Renamed all files to make it more agnostic.

Server

• Code made more robust for cloud databases.
• Free file descriptors removed because it is always zero, trigger added for 80% file descriptors used.
• Cache file base bug in getIostat fixed.
• Server graph for file descriptors improved
• I/O queue ymin set to 0.
• Server template optimized.
• Iostat graphs added to server template.
• Integrated iostat data into fpmmm.
• All registered devices and bug on svctm fixed.
• More info added when server module is called with --debug option.
• Disk status items cleaned-up and filesystem names added for creating new items.
• Interface eth1 removed but list of all interfaces added.
• NUMA trigger added.
• Macros for network interfaces added.

Data

• Data module added to measure schema and instance size.
• Code made ready for cloud databases.

User

• Module for per user data added.
• Dirty code fixed, found on cloud databases.
• User info for transactions added.
• Tmp disk tables and sort merge passes per user information added.

Agent

• MySQL 8.0 compatibility issue fixed with user privileges.
• Output format zabbix, icinga, nagios and centreon should be supported now.
• Error messages for connect improved.
• Option --debug added, one message was not handled correctly in verbosity level.
• Parameters in function goThroughAllSections cleaned-up.
• Option -h added, info more clear when wrong options were used.
• URLs added to fpmmm template.
• fpmmm check and trigger improved.
• Made error handling better after test of 1.1.0 on CentOS 7.
• fpmmm trigger error message improved.

InnoDB

• NUMA information and warning trigger added to InnoDB module.
• Trigger for innodb_force_recovery made repeatable.
• Alert level for innodb_force_recovery increased, InnoDB non default page size alert added.
• InnoDB deadlock detection is alarmed, when disabled.
• innodb_metrics only works with SUPER privilege, fixed.
• InnoDB Log Buffer much to small trigger added on Innodb_log_waits item.
• Items and graphs for InnoDB temporary tables added.

MySQL

• Metadata Lock (MDL) error message improved.
• Metadata Lock (MDL) naming improved.
• Metadata Lock (MDL) counters, checks, graphs, triggers and Metadata Lock itself added.
• Connection graphs yellow made a bit darker.

MyISAM

• Items and graphs for MyISAM temporary tables added.

Aria

• Items and graphs for Aria temporary tables added.

Security

• Expired user added for MySQL including alert.

Slave

• URL added and two triggers made repeatable.

Backup

• Backup will report EVERY failure and URL is now useful!

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