Page History
SQL Diagnostic Manager for MySQL 8.9.5 provides the following new features and fixed issues:
...
New
...
features
- 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.
8.9 Fixed Issues
...
The Threads page now correctly displays queries that contains these “<” or “>” characters.
...
- 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.
Fixed Issues
- SQL DM for MySQL now does not crash with weird entries in the logs when the UI 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 format
...
- .
...