Page History

SQL Diagnostic Manager for MySQL 8.9.5 provides the following new features and fixed issues:

...

New features

• SQL DM for MySQL now monitors SkySQL file based log monitoring for Slow query, Error log and Audit log files. This release includes operating system metrics monitoring, with the exception of CPU monitoring.
• Users can now specify the long running query time inside the query by adding a comment like {Monyogslowquerytime=[TimeInSeconds]} in the respective query. This overrides the "LONG RUNNING QUERY TIME" specified in the Edit Server -> Processlist -> Long running query monitoring.
• It is now possible to monitor logs and get OS metrics from Amazon Aurora serverless.
• An admin can now change the user settings without entering/changing the password.

8.9.4 New features

There are no New Features reported for this version.

8.9.3 New features

Fixed Issues

• SQL DM for MySQL shows a notification in now does not crash with weird entries in the logs when the UI when it is unable to send an Alert message due to wrong settings.

8.9.2 New Features

• SQL DM for MySQL can now analyze audit logging in Aurora Server.

8.9 New Features

• is opened.
• SQL DM now successfully monitors logs in Amazon Aurora.
• Now, when changing the SQL DM port from Web UI, SQL DM does not change the MONyog.log path.
• SQL DM now does not report incorrect values for the Monitor percentage of free disk space.
• SQL DM now appends the data dir path to the Pid file if the value of the variable pid_file is a filename (not an absolute path name).
• The DB Column is now shown in the Performance Schema based Sniffer analysis.
• In a long running query slack alert, the queries were not displayed properly due to the special characters. Those characters are now escaped.
• Slave running monitor now does not give a false alert for MySQL 8+ servers.
• The InnoDB history list length does not increase on the Aurora server anymore.
• SQL DM now does not return a client disconnected error when a data collection takes more time.

Miscellaneous

• The MySQL_HOST was added in the notification subject
• SQL DM for MySQL includes a query load profiling to Query Analysis along with a new interface for Query Details to make it easier to analyze query performance over time.
• Introduced new APIs for updating user passwords and LDAP bind user password.
• This version includes several Enterprise security improvements:
  
• Restrict access to individual custom dashboards and the ability to create new dashboards to newly created users.
• Capability to hide literals in SQL statements,
• Ability to remove default admin user, and rename the default Admin name.
• Improved audit log filtering, adding and excluding filter.
Configurable SNMP trap format.