MONyog full changelog

Features:
A Galera cluster can now be automatically registered specifying any single node in the cluster.
Optimized counter migration logic. This will reduce migration conflicts on upgrading Monyog tremendously. Post Monyog-8.6.0, a conflict will be raised on upgrade only if any counter definition is modified in the latest release and the user has also customized the same counter.
Added more columns for Slow Query log (for MariaDB and Percona Server) like full_scan, full_join etc. These values are written to Slow query log when ‘log_slow_verbosity’ is set to “Query_plan”.
Connection timeout (MySQL, SSH and SSH Tunnel) can now be set for servers individually. The default value is 30 seconds.
Bug Fixes:
Monyog logged an SQLite error “Udo.def: not an error” on fresh installation.
“Create User..” and “Create role..” queries were shown as a schema change in audit log.
Queries containing ‘<’ or ‘>’ were displayed with their HTML-entities ‘<’, ‘>’ in “Threads” page.

Features:
Monyog can now analyze MariaDB and MySQL enterprise Audit log.
Added support for LDAP with StartTLS and SSL.
The default path for MONyog.log can be changed using the parameter “MONyogLogPath” from the MONyog.ini file.

This maintenance release resolves an issue with access to log files on RDS. The issue occurred because the XML response from the RDS REST API has changed in some cases.
Bug Fix:
Resolved an issue regarding access to log files on RDS. The issue occurred because the XML response from the RDS REST API has recently changed in some cases. Our XML parsing was improved to handle this.

This release includes some GUI improvements and also fixes a few (also mostly GUI-related) bugs. Additionally, we have upgraded most libraries used internally to the current version. This – most significantly -includes OpenSSL.
Features:
Added option to have same Y-axis scaling for Dashboard charts across all servers.

Features:
MONyog API now supports LDAP users and groups.
Bug Fixes:
In rare cases MONyog failed to connect to SSH and returned the error “failed to connect to SFTP: SshConnect: Error while connecting to ssh server –kex error”.

Features:
Charts are now loading faster with large time range.
Added more pre-configured Galera charts and Performance_Schema Custom SQL Objects.
Improved the performance of SQL-query in CSO ‘Tables_Without_Constraints’.

Bug fixes:
When user logged in to MONyog with an account other than the built-in admin account, tabs were hidden.

Bug Fixes:
The “Explain Query” dialog box in Real Time and Query Analyzer returned the message “Extended is deprecated” for MySQL 5.7.3+ servers. Now (plain) “EXPLAIN” is used to fetch the value.
In rare cases some monitor groups were not getting Enabled/Disabled at “Manage Monitor groups” page when using Internet Explorer.
The fields “SeriesCaption” and “SeriesValues” in “Edit chart” page did not give any error on saving when having different number of arguments, but a console error showed up while loading the charts.

Bug Fixes:
MONyog.log file logged bogus SQLite errors like “not an error” if UDOs were enabled in MONyog in some cases.
The definition for the counter “Free disk space” in the “Linux” group was misleading as we were giving the free disk space of the volume where mysql binary resided given by “basedir”, instead of giving the free disk space on the volume where data directory resides given by “datadir”.
The column “Rows examined” in Performance_Schema based sniffer printed negative values, if the number of “Rows examined” exceeded the value 2G.

Bug Fixes:
“Count” column did show empty value in Processlist based Real-time.
Performance_Schema based Real Time failed if global sql_mode included “ONLY_FULL_GROUP_BY”.
Clicking on locked queries were not showing its corresponding locking query and vice versa for Performance_Schema based Real Time.