Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • If the server’s log query path variable returns a relative path, then SQL DM for MySQL will generate MySQL generates the absolute path – required by MONyog – automatically.
  • Added the monitor “Most Advanced Node” in the Galera group.

...

  • “MySQL server restarted” alert will now be shown are shown in table format.
  • Added option to view locked and locking queries when hovering over the queries in the Real Time
  • Upgraded SQLite library to v3.21.0.

...

  • Option to set a distinct email distribution list for warning and critical alerts: Now you can define a proper demarcation between the users who will receive receives a particular alert based on the alert status. For instance, if you want only your on-call DBAs to receive critical alerts 24/7, this feature handles that easily.

  • Graph Analysis: You can group one single metric (which you find most important) from different servers into one unified chart. This allows You can group one single metric (which you find most important) from different servers into one unified chart. This allows you to visually analyse a metric across servers at various points in time.

  • Disk monitoring of the system where SQL DM for MySQL is installed: In case the free space on the system where SQL DM for MySQL is installed goes below the threshold value, SQL DM for MySQL will raise MySQL raises an alert.

  • Filter to exclude unwanted long running queries in Sniffer:

  • You can tell SQL DM for MySQL to ignore a particular type of query by specifying a regular expression. SQL DM for MySQL neither would kill nor send an alert for such long-running queries.

  • Option to filter queries based on poor indexes, missing indexes, errors and warnings. This feature is available for PERFORMANCE SCHEMA based sniffer in Query Analyzer and "Show details" page in Dashboard. When you choose a filter, SQL DM for MySQL will show shows queries based on the criterias set.

  • Redesigned Server selector

  • Redesigned Query Analyzer: a more intuitive view of the top 5 queries based on total time.

  • Added proper Y-axis unit for charts, along with the option to define the units and unit-factors.

...

  • It is now possible to get OS metrics from Amazon RDS/Aurora (but not Azure, where interface for same is disabled).
  • Added an option to generate a token in SQL DM for MySQL to be used with the Monyog API as an alternative to SQL DM for MySQL user and password.
  • Added an option to define a “seconds_behind_master” setting in Replication page determining if the slave should be considered in sync or not. On some environments, slave will rarely be is rarely fully in sync and in such cases, the alerting was not really useful before.
  • MONyog-bin.pid location on Linux can now be changed from Monyog.ini file.
  • Reintroduced the tabular view for Replication overview page. Now, the user can choose between tabular and graphical view.
  • Added an option to select the way the server selector should work in SQL DM for MySQL, i.e: same servers across all pages or different across pages.

...