Page History
SQL Diagnostic Manager for MySQL provides the following new features and fixed issues:
8.
...
9.5 New
...
features
- SQL DM for MySQL now monitors Google Cloud SQL server Operating System metrics.This release includes Google Cloud SQL server SkySQL file based log monitoring for General query, Slow query, Error log and Error Audit log files.
Note | ||||||
---|---|---|---|---|---|---|
This release includes new registration keys. The new keys are available for registered users from our
|
8.8 Fixed Issues
- Regular Expression can now be used for the "Queries Starting with" filter for Processlist based Sniffer.
- The "Flush Status" query was renamed to "Flush Local Status" in the Monitors tab.
- SQL DM for MySQL is no longer displaying the warning message "User does not seem to have PROCESS privileges on this host. Only user's own processes will be displayed".
- The message "No data to display" in the history trend analysis graph for Monitor InnoDB cache>Free Memory is no longer prompting.
- SQL DM for MySQL is no longer displaying the "Undefined" message when hovering over the trend graph with a Monitor value of zero.
- The SQL Query for the CSO Tables_Without_Constraints was modified to excludes the views.
- SQL DM for MySQL now correctly raises SNMP traps/Syslog notifications when a monitor state changes from "Warning" to "Critical".
- The password field value is now correctly shown as a masked value.
- The RDS Log monitoring "Test reading the file" now correctly checks for "DownloadDBLogFilePortion" permissions.
Miscellaneous
The double quotes can now be used in the email subject format.
- The MOM variable MemAvailable was added. The Javascript function for the RAM Usage monitor is modified to display appropriate value depending on the kernel.
The MariaDB C/C connector was upgraded.
SQL DM for MySQL has included an option to show truncated query/full query in the Threads page.
All the SQL DM for MySQL passwords are stored encrypted in the SQLite database.
- 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
SQL DM for MySQL shows a notification in 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
- 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.5 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.
8.9.4 Fixed Issues
- SQL DM for MySQL now runs properly in Debian 10 and 11.
8.9.3 Fixed Issues
SQL DM for MySQL now connects to MySQL using SSL encryption with caching_sha2_password authentication plugin.
On Chrome browser, the data is automatically filled for server names, tags, and other filters if the Save Password is turned ON.
SQL DM for MySQL validates the email address properly, and it allows saving multiple emails using space and comma separator.
8.9.2 Fixed Issues
- Google Cloud Server logs are getting analyzed properly.
- Starting with version 8.9.2, modified UDOs will display as Resolved when there are no new changes in future upgrades.
- Query Analyzer, Realtime, and Dashboard statistics extracted files, now collect correct time/date.
- General Log Export as CSV does not show undefined and NAN in the CSV file anymore.
- MySQL Versions prior to 5.6.2, now display accurate disk space.
- Show/Hide literals in Long running query notifications, are now available for all notification channels.
- When the query contains special characters, the exported CSV file now is formatted properly.
- Resolving Conflicted CSO’s now works properly.
- SQL DM for MySQL now sends pagerduty notifications correctly when the length of the message is greater than 1024.
- Editing a LDAP Password now sets the new password accordingly.
- MariaDB roles are listed correctly.
- The values plotted in the Monitor trend charts, are now converted to bytes.
- The column QPS now sorts accurately.
- Total Time column in Query Analyzer page, now shows the value properly.
8.9.1 Fixed Issues
There are no Known Issues reported for this version.
8.9 Fixed Issues
- The Threads page now correctly displays queries that contains these “<” or “>” characters.
- The Event Details window now correctly displays the event values that contains special characters.
- The SSL settings now correctly save the changes after editing the servers.
- The client user filter option in the Sniffer settings now works correctly.
- The Locked and Locking Queries in Real-time are now available for MySQL 8.0+ servers.
- The Connection Type is no longer changing from SSL to Direct when editing a server using API.
- SQL DM for MySQL is no longer crashing when passing some arguments in the start command.
- SQL DM for MySQL now correctly exports CSV reports when applying filters in the Query Analyzer, Dashboard, and Real-time.
- All chart series are visible for MySQL 8.0+ version in the Dashboard and screens.
8.9.5 Miscellaneous
- The MySQL_HOST was added in the notification subject format.
8.9.3 Miscellaneous
- MariaDB Connector is upgraded to 3.1.11.
8.9.2 Miscellaneous
- JQuery library is upgraded to 3.5.0.
...