Page tree

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

8.9.2 New Features

  • SQL DM for MySQL now can 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.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 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.2 Miscellaneous

  • JQuery library is upgraded to 3.5.0.



IDERA ProductsPurchase | Support | Community | Resources | About Us | Legal