This page lists all the new features and fixed issues from previous releases for SQL Diagnostic Manager for MySQL.

8.6.0 Monyog (April 2018)

New Features:

• A Galera cluster can now be automatically registered specifying any single node in the cluster.
• Optimized counter migration logic. This will reduce migration conflicts on upgrading Monyog tremendously. Post Monyog-8.6.0, a conflict will be raised on upgrade only if any counter definition is modified in the latest release and the user has also customized the same counter.
• Added more columns for Slow Query log (for MariaDB and Percona Server) like full_scan, full_join etc. These values are written to Slow query log when ‘log_slow_verbosity’ is set to “Query_plan”.
• Connection timeout (MySQL, SSH and SSH Tunnel) can now be set for servers individually. The default value is 30 second

Fixed Issues:

• Monyog logged an SQLite error “Udo.def: not an error” on fresh installation.
• “Create User..” and “Create role..” queries were shown as a schema change in audit log.
• Queries containing ‘<’ or ‘>’ were displayed with their HTML-entities ‘&lt’, ‘&gt’ in “Threads” page.
• Monyog failed to read the MySQL log files when ‘log_output’ variable was set as both File and Table.
• Monyog failed to connect and displayed “Operations error” when using Active Directory External Authentication.
• In rare cases Monyog failed to raise alerts for the monitor “Recent entries of type [Error]”.

Miscellaneous:

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

8.5.0 Monyog (March 2018)

New Features:

• Monyog can now analyze MariaDB and MySQL enterprise Audit log.
• Added support for LDAP with StarTLS and SSL.
• The default path for MONyog.log can be changed using the parameter “MONyogLogPath” from the MONyog.ini file.

Fixed Issues:

• Monyog logged bogus SQLite errors on fresh installation.
• Monyog displayed console error if LDAP group name contained inverted comma.
• Changed alert condition for “Seconds behind master” monitor to consider “NULL” as an alertable condition. It considered the value “NULL” stable condition earlier.
• On upgrading, Monyog filled the mail alert field for sniffer with the bogus email id “admin@mydomain.com”.
• On selecting a tag in server selector GUI and then returning back to the main list, the default list of tags disappeared.

Miscellaneous:

• “MySQL server restarted” alert will now be 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.

8.4.1 Monyog (January 2018)

Fixed Issues:

• The Linux command ‘ps’ failed to identify Monyog process status. This was due to a packaging issue introduced in 8.4.0. Versions before that were not affected.
• The option “Notify when server config change detected” compared in a case-sensitive manner and thus raised false alerts when the value for the MySQL variables changed from lower to upper case and vice versa. This could happen when a MySQL server was upgraded.

8.4.0 Monyog (December 2017)

New Features:

• Added more notification channels (Slack and Pagerduty) for Monyog alerts.
• Option to write Monyog alerts in the Syslog (of the machine where Monyog is installed). This option is only available for Linux.
• Option to edit the subject line for Monyog alerts.
• Added MONyog API to disable notification for a monitor based on a server/tag.
• Complete re-design of the Settings page.

Fixed Issues:

• Export as CSV was downloading sorted based on “Average latency” column, even if sorted based on another column in Query Analyzer.
• Fixed a case where Monyog sent bogus alerts.
• Fixed a bug in reading RDS log files.
• The Query filter “Custom” did not work in “Threads” page.
• In rare cases, Monyog Disk space Monitoring alert gave false alerts.
• The “Table” column returned empty values under “Tables” filter in Real-time.
• SNMPv2 traps were having the same OID for two different objects what caused SNMP alerts failure with SNMPv2 services.

Miscellaneous:

• Increased the length of tag and server names to 2048 characters.

8.3.2 Monyog (November 2017)

Fixed Issues:

• Resolved an issue regarding access to log files on RDS. The issue occurred because the XML response from the RDS REST API has recently changed in some cases. Our XML parsing was improved to handle this.

Monyog 8.3.1 (November 2017)

Bug Fixes:

• When monitoring MariaDB servers from version 10.1, bogus alerts were raised for the ‘wsrep_ready’ global status variable, if the server was not a part of a Galera cluster. The wsrep API for Galera is loaded with those servers (with ‘wsrep_ready’ returning “OFF”) even though it is not used at all.
• Edit server MONyog API did not support data directory number of the registered servers for ‘_server’ parameter.

Monyog 8.3.0 (October 2017)

Features:

• 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 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 Monyog is installed: In case the free space on the system where Monyog is installed goes below the threshold value, Monyog will raise an alert.

• Filter to exclude unwanted long running queries in Sniffer:

• You can tell Monyog to ignore a particular type of query by specifying a regular expression. Monyog 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, Monyog will show 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.

Bug Fixes:

• Monyog was logging “UNIQUE constraint failed..” errors in MONyog.log

• System charts failed to show data for many data collections, when the system metrics was enabled from the Dashboard page.

• In some rare cases, real-time page hanged on switching between real-time sessions.

• Option to plot values based on data collection in History/Trend analysis(For uptime counters). Only Group by option was available for those counters.

• Monyog failed to recognise Aurora instances for OS monitoring. The four required fields for OS monitoring were not displayed.

• Email addresses with + in monitor level notification settings was not accepted.

• Added ‘DB’ as a column under ‘Manage Columns’ in Dashboard’s ‘show details’ page in ‘Processlist’ mode

• Monyog showed the total time and average latency as 0 when the execution time of the query was less than a second for table based slow query log.

• Fixed an issue with Custom SQL Object (CSO) - Monyog logged entries like “not an error” in MONyog.log.

Monyog 8.2.0 (August 2017)

Features:

• Added option to have same Y-axis scaling for Dashboard charts across all servers.

Bug Fixes:

• Query count could return negative value in Overview page due to integer overflow.
• The History/Trend analysis chart for the counter “Free disk space” was not rendering properly.
• The Monyog API for enabling System metrics for RDS instances was not working as expected.
• After zooming into the real-time chart, the Query column was not getting sorted.
• History/Trend could show wrong value for some counters – mainly string based counters.
• In case of RDS servers, rebuild of a server’s database, restarting Monyog or using “editserver” API could stop the collection for OS metrics.
• When using cname for RDS servers, Monyog failed to enable system metrics.

Miscellaneous:

• Redesigned Time-selector for all the features.
• Upgraded OpenSSL to current v1.0.2l. The version used before had a few non-critical security issues. Also quite a lot of libraries used internally were updated.

Monyog 8.1.1 (July 2017)

Bug Fixes:

• Regression bug introduced in Monyog-8.1.0: Monyog failed to install on Linux machines with no “kernel headers” installed

Monyog 8.1.0 (July 2017)

Features:

• 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 Monyog to be used with the Monyog API as an alternative to Monyog 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 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 Monyog, i.e: same servers across all pages or different across pages.

Bug Fixes:

• Seconds behind master could show wrong value in the chart.
• Export as CSV didn’t work for “Locked and Locking Queries” in Real-Time.
• On HDMI and higher resolution monitors, overview page could display distorted.
• Extra columns added from manage columns in Real-Time were getting reset to default set of columns on moving away from the page.
• In Dashboard the value of min/max/avg displayed as 0 if number of points was larger than 10,000, Also, if the chart was exploded, the chart would display empty.
• Some counters did not show values formatted properly.
• In mail alerts for counters in multi-replication monitor group a newline character in subject could cause the mail to display unformatted in some mail clients – including gmail web interface.
• In “long running query” alert there was a bare line feed character (\n) which could cause reading failures in some environments.
• History trend reports will show date as well in the timestamp if report spans more days.
• Collection and Purging interval was not setting properly while editing a UDO.

Miscellaneous:

• Redesigned the interface for adding new servers.
• It is now possible to display the “Replication Overview” page and set auto-refresh interval similar to Monyog before version 7.o. Different users have different preferences here.
• When installing Monyog on a Linux machine with kernel version less than 2.6.32, an error message will now inform that Monyog needs a kernel version or 2.6.32 higher.

Monyog 8.0.4 (Jun 2017)

Bug Fixes:

• In rare cases, Replication Overview page failed to load and a console error appeared.
• SQLite files used by Real-time were not always deleted when they should, resulting in unnecessary disk usage.
• Enabling the error log, slow query log and general query logs through the API for RDS server failed.
• Fixed a crash when connected to Azure MySQL-5.7 servers.
• Some columns were not getting sorted properly in Sniffer.

Miscellaneous:

• When stopping Monyog service, all running Real-time sessions will now be saved automatically.
• Upgraded LibSSH and LibCurl to the latest versions (0.7.5 and 7.54.0 respectively).
• Monyog will now only support Linux’es with kernel version equal to or higher than 2.6.32 . This is a consequence of an upgrade of our build environment necessary in order to support recent kernel versions and distributions.
• Upgraded the MariaDB Connector/C to 2.3.3. Due to this the MariaDB auth_gssapi (Kerberos) plugin is now supported.

Monyog 8.0.3 (May 2017)

Features:

• Option to export entire Dashboard charts.
• Option to search tags in Server selectors.
• Completely re-designed Servers page.

Bug Fixes:

• In monitors page, history chart did not plot for some counters.
• In Firefox browser, Servers page hanged with a large number of servers.
• Monyog failed to connect over SSH tunnel for Ubuntu-16.04.
• If ‘show_compatibility_56’ is off for MySQL-5.7 servers “Slave_running” counter gave a false alert. It will display “(n/a)” now.

Miscellaneous:

• API added to change the mode of Real-time Monitoring.
• Enhanced security measures to avoid vulnerabilities like clickjacking, phishing etc.

Monyog 8.0.2 (April 2017)

Features:

• Added Dashboard charts and monitors for the Aria storage engine.
• Performance schema can now be used with RDS Aurora (version 5.6.10).

Bug Fixes:

• Monyog failed to recognize replication topology in cases when “SHOW SLAVE STATUS” returned master host as an alias name while the master server was registered with an ip address in Monyog.
• Also Monyog could fail to recognize replication topology if SSH-tunnel was used to master.
• The replication monitors stopped updating values, when slaves stopped running as slaves.
• When logging in with LDAP group users, the onboarding tool-tips continued to display when no longer needed.
• Threads page stopped updating data once the custom query filter returned empty list.
• Monyog did not show queries starting with “SHOW..” in slow query log in Query Analyzer.
• “Lock time” column was not getting sorted properly for PS based real-time.
• Monyog returned console error for server name containing single quote(s).
• Deleting server registrations in Monyog could result in high CPU-load and IO. This is now reduced.
• Monyog RPM installer script failed to start Monyog in SUSE Linux Enterprise servers.

Monyog 8.0.1 (April 2017)

Bug Fixes:

• Servers below MySQL-5.1.15 were shown disconnected even when the servers were connected, due to the absence of information_schema.plugins table.
• In IE 11, servers page gave console error and became unresponsive.

Monyog 8.0.0 (March 2017)

Features:

• Added support for Multi-Source Replication.
• SNMP v2 is now supported.
• Added new Monitors for a number of plugins (Failed to load plugin list, Non mature plugin, Audit log enabled, Audit log load_option FORCE_PLUS_PERMANENT, Password verification enabled).

Bug Fixes:

• The Galera counter “Total number of bytes replicated to other nodes” now uses “wsrep_replicated_bytes” and not “wsrep_replicated” variable as before.
• The Logrotate script shipped with Monyog failed to rotate the Monyog log in some cases.
• In some cases Top-5 tables in Disk Info page were not showing tables sorted based on total size.

Miscellaneous:

• Overview will now show top 10 queries only for the selected servers and not for all the registered servers in Monyog.
• Overview, Dashboard, Monitors, Threads and Server Config (Compare Config) pages will have their own separate server selector.
• Now the maximum no of servers that can be selected in each page is limited. Default is 10, but the number can be configured in Monyog.ini.On most systems we don’t advise raising the value as it may increase the time for loading pages.

Monyog 7.0.5 (March 2017)

Bug Fixes:

• Fixed a crash occurring when upgrading Monyog from Ultimate/Trial to Enterprise/Professional.
• In rare cases dashboard failed to load charts.
• In some cases Monyog could fail to analyse the sniffer and returned error “Integer overflow” instead.
• Additional InnoDB deadlock information from SHOW ENGINE INNODB STATUS available in MySQL 5.6+ was not displayed in Monitors page.
• Fixed an issue where log analysis wasn’t working with Aurora instances.
• RDS servers were not being detected as RDS instances because of change in ‘basedir’ variable for RDS.
• In Monitors page, it could happen sometimes that some charts were not displayed in ‘history’ timeframe.
• The ‘Minimum time taken’ -setting for Processlist-based sniffer also affected Performance_Schema-based sniffer. This is wrong and has been corrected.
• In some cases the Overview page loaded slowly if the request for checking any unresolved counters, functions or UDOs responded late.
• Login to Monyog failed if the password had any of the characters “%”, “&”, “+” and “?”.
• A few UI/display fixes.

Monyog 7.0.4 (February 2017)

Bug Fixes:

• In rare cases Monyog would hang while editing a server.
• Enabling “Monitor locked queries” switched back to off state after editing settings for the actual MySQL server.
• Regression fix: Monyog-v7.x releases had a higher load average than 6.x predecessors.

Miscellaneous:

• When upgrading, migration will be much faster.
• Improved Dashboard charts loading speed.

Monyog 7.0.3 (February 2017)

Features:

• Dashboard charts now load faster.

Bug Fixes:

• When editing an existing LDAP group/user, changes were not getting saved in some cases.
• When using proxy-based Query Sniffer, it could happen that some queries were not displayed in the Query Analyzer.

Monyog 7.0.2 (January 2017)

Features:

• Added two new monitors for monitoring Binary Log volume in Linux monitor group. Please note that this will work only for MySQL 5.6.2 and above.

Bug Fixes:

• For RDS instances, the Error Log files were not getting fetched. This was introduced in 7.0.
• When upgrading from a pre-7 release, LDAP settings could be overwritten. Also this was introduced in 7.0.*
• Queries containing ‘<’ or ‘>’ were not displayed properly in Overview, Real-time and Query Analyzer pages. Instead the HTML-codes ‘&lt’, ‘&gt’ displayed. Also a 7.0 bug.
• When running 7.01 as a non-registered TRIAL some pages could ‘hang’ in rare cases. 7.0 was not affected.

Monyog 7.0.1 (January 2017)

Bug Fixes:

• In some cases overview page loaded slowly and would even sometimes seem to remain in “Fetching details” state forever.
• Security: Fixed an issue where a user could escalate his privileges by manipulating cookies. Though fixed already in 7.0, this is listed here for completeness.

Monyog 7.0 (January 2017)

Features:

• Overview page giving the top-level picture of all the servers running, down, critical alerts, warnings and the top 10 queries across all the servers registered with Monyog.
• Option to create customized dashboard with specific charts with the ability to explode a chart
• Search option for servers registered with Monyog.
• Query Analyzer will now show the top 5 queries based on execution time in a separate window.
• Replication overview page showing the replication hierarchy in a clean graphical way.
• Servers page providing an overview of all the servers registered and their status in one place.

Monyog 6.63 (October 2016)

Features:

• Monyog API now supports LDAP users and groups.

Bug Fixes:

• In rare cases Monyog failed to connect to SSH and returned the error “failed to connect to SFTP: SshConnect: Error while connecting to ssh server –kex error”.
• Monyog failed to authenticate as required when using the authentication mode “Comparison” for LDAP users and groups.
• Some galera charts were not loading due to the syntax error in the chart definition.
• Monyog was allowing users to add/edit the server using the API even if the user did not have privilege to add/edit the server.

Monyog 6.62 (September 2016)

Features:

• Charts are now loading faster with large time range.
• Added more pre-configured Galera charts and Performance_Schema Custom SQL Objects.
• Improved the performance of SQL-query in CSO ‘Tables_Without_Constraints’.
• Added a new API “_disabledmonitorgroups” for enabling and disabling Monitor Groups at server-level.

Bug Fixes:

• Support for the ‘clear-text plugin’ (used by Oracle/MySQL LDAP authentication) and the ‘dialog plugin’ (used for MariaDB PAM authentication) was broken.
• With RDS servers Monyog could fail to detect log file content and size and would display the error “No queries found” and “Unable to fetch file size”. It happened because of recent changes in the XML-response of Amazon’s REST API.
• Slow query log/General query log paths were not always setting properly when adding/editing a server using the Monyog API.
• MySQL InnoDB-related charts displayed empty with MySQL 5.6+. The reason was removal of the ‘have_innodb’ server variable in MySQL 5.6. Now these charts don’t depend on this variable.

Monyog 6.61 (September 2016)

Bug fixes:

• When user logged in to Monyog with an account other than the built-in admin account, tabs were hidden.

Monyog 6.6 (September 2016)

Features:

• Monyog user management was enhanced with a ‘roles’ feature.
• LDAP role based access: users can now map External LDAP roles to Monyog roles.
• Added option to restrict access to specific tabs for specific users.
• SNMP traps will now have “Tag” and the “MySQL hostname” in the message.
• Now Monyog will show the number of servers selected in the tag along with the total servers in that tag.
• Added a message in the charts page if system charts are enabled and SSH settings are not enabled.

Bug fixes:

• When adding a server through Monyog API, sniffer was not enabled by default.
• The setting for “Override send notification when alert-able?” was ignored if the value specified was greater than the setting for “Send notification when alertable”.
• In rare cases Real-Time failed to start a new session and showed a random number.

Monyog 6.55 (August 2016)

Bug Fixes:

• The “Explain Query” dialog box in Real Time and Query Analyzer returned the message “Extended is deprecated” for MySQL 5.7.3+ servers. Now (plain) “EXPLAIN” is used to fetch the value.
• In rare cases some monitor groups were not getting Enabled/Disabled at “Manage Monitor groups” page when using Internet Explorer.
• The fields “SeriesCaption” and “SeriesValues” in “Edit chart” page did not give any error on saving when having different number of arguments, but a console error showed up while loading the charts.
• Monyog was not able to connect to RDS instances using SSL encryption. Attempting to do so returned the error “Failed to connect to MySQL: SSL connection error: certificate verify failed”.

Miscellaneous:

• The option “Notify when server configuration changes” will be enabled by default when notification is enabled.
• Now counters may be customized from “Events” tab as well.

Monyog 6.54 (July 2016)

Bug Fixes:

• Monyog.log file logged bogus SQLite errors like “not an error” if UDOs were enabled in Monyog in some cases.
• The definition for the counter “Free disk space” in the “Linux” group was misleading as we were giving the free disk space of the volume where mysql binary resided given by “basedir”, instead of giving the free disk space on the volume where data directory resides given by “datadir”.
• The column “Rows examined” in Performance_Schema based sniffer printed negative values, if the number of “Rows examined” exceeded the value 2G.
• In Real-Time, charts for Tables tab were not displayed in some rare cases.
• We are now discarding GTID-related system variables that are changed by MySQL server itself from the “Track Config” tab. These system variables (gtid_executed, gtid_owned, gtid_purged etc.) change if a new transaction occurs in Master and considering them would raise bogus alerts that configuration was changed.

Miscellaneous:

• Monyog will now have sniffer enabled by default for newly registered MySQL servers. If Performance_Schema is enabled for the MySQL server then Performance_Schema mode will be used, else Processlist mode will.
• Improved the load time of Monitors page. It is noticable in particular when “History” timeframe is used with a large range (several hours or more).

Monyog 6.53 (April 2016)

Bug Fixes:

• “Count” column did show empty value in Processlist based Real-time.
• Performance_Schema based Real Time failed if global sql_mode included “ONLY_FULL_GROUP_BY”.
• Clicking on locked queries were not showing its corresponding locking query and vice versa for Performance_Schema based Real Time.
• The counter “General Log Enabled?” was showing incorrect value for MySQL 5.6.1+ versions.
• In rare cases, Monyog would show only time with no date in x-axis if the chart was plotted for multiple days.
• Editing LDAP group was not always working as expected.
• With RDS servers Monyog could fail to detect log files and would display the error “log file not present”. It happened because of changes in the XML-response of Amazon’s REST API introduced since we started supporting logs with RDS.

Miscellaneous:

• The default filter for “show queries only” in processlist now includes ‘Command=Execute’. Also ‘Command=Execute’ is now included in processlist-based Real Time and Query Analyzer interfaces.

Monyog 6.52 (March 2016)

Features:

• Added an option to choose data collection mode for Real-Time, Users can now choose between ‘Performance schema’ or ‘Processlist’. Old versions used ‘Processlist’ what we replaced with ‘Performance schema’ recently for servers running with needed P_S instruments enabled. However due to the aggregation and truncation of queries recorded in P_S we had several requests that both options should be there.
• Information whether a query is performing a full table scan available in Query Analyzer, Wayback Machine and Real-time.This information will help to identify queries which are not using Indexes. Note: this is available only for Performance Schema mode.
• Added a new monitor group ‘sys schema’. It contains various CSOs (Custom SQL Objects) utilizing the “sys schema” database introduced in MySQL 5.7.7.
• Added an option to either have a fixed length height or dynamic (full screen) height for Processlist in Monyog GUI. We have been using each in earlier versions, but it seems impossible to make everyone happy with a single solution. Now user can choose what display/design that fits him best.

Bug Fixes:

• The Monyog API failed to set the error log path.
• With MySQL 5.7+ Query Analyzer was displaying seemingly random values for the column “first seen” and “last seen” when using server logs (slow query log, general query log) as data source. This happened because of change of Timestamp format in the logs in MySQL 5.7 .
• The filter “doesn’t contain” was not working properly in Real-time.
• Fixed an issue where UDOs were displaying incorrect values after running for some time.
• While editing the server using Monyog API, SSH settings were automatically set to disabled (even if it was enabled earlier).
• For RDS/Aurora servers, “Apply the above settings to all the servers with same tags” (Edit server -> Advanced settings) was not working.
• Monyog was giving the error “Log file not present” if either one of the slow query log or general query log was disabled for RDS servers.
• Fixed Javascript errors and optimized the charts for Real-time page for IE8 browser.

Miscellaneous:

• The Y-axis in Charts had just “values” written, now it shows relevant units like percentage, seconds etc. and option is provided to customize the Y-axis value.

Monyog 6.51 (December 2015)

Features:

• RDS log monitoring feature can now be configured using the Monyog API.

Bug Fixes:

• The query SHOW ENGINE INNODB STATUS fails for MySQL version less than 4.1.2. and resulted in a Monyog crash. Even though we don’t recommend MySQL 4.1 (and not at all such early beta of it), we should not crash.
• Fixed JavaScript errors for Query Analyzer and Real Time tab in Internet Explorer 8 (WinXP, Win2003).
• With MariaDB 10.1.x Monyog erroneously listed all user accounts as having no password.
• The curl library used could crash, and thus crash Monyog, when resolving too many hostnames at the same time.
• Monyog failed to send 'stable alert' when both "notify till stable" and "notify when stable" options were enabled and if different values were set for the "send notification when alertable" and "remind me after every ..".
• Fixed the height of the Processlist display for each server. Each server’s processlist window is now displayed as scrollable window of fixed height. This is a regression fix and a revert of the page design to that of older versions. With recent versions it was necessary to scroll the browser window.

Miscellaneous:

• Upgraded SQLite library to v3.9.1. This results in ~25% performance improvement on most environments.
• Renamed the “Row Access Statistics” counter to “Queries Executed” as it actually uses the ‘queries’ status variable. The old term confused some users.

Monyog 6.5 (November 2015)

Features:

• On Amazon RDS and Aurora, MySQL log files (Slow Query Log, General Query Log and Error Log) can now be read by Monyog. So Error Log monitoring is now possible here, and the Query Analyzer does not require logging to tables anymore. For this the Amazon “REST” API (and not SFTP) is used. Client functionalities for this API have been integrated into Monyog.
• Added monitors for Galera: “Presence of non-InnoDB tables” and “Tables without a primary/unique key”.

Bug Fixes:

• Monitors and Real-time page failed to load on Internet Explorer 8 (highest IE option on WinXP) due to javascript errors.
• Fixed a rare crash when connected to MySQL 5.7.6+.
• Accessing Realtime interface could cause a crash if connection to the server was not available.

Monyog 6.4 (October 2015)

Features:

• Performance Schema is now available in Realtime. Monyog can now capture all queries and display it in realtime which was not possible earlier with SHOW FULL PROCESSLIST output. To view all queries in realtime, make sure Performance_schema and ‘statements_digest’ table is enabled. If not, Monyog will display the output of SHOW FULL PROCESSLIST in realtime. Note: Performance_schema is available with MySQL 5.6.14 and above.

Bug Fixes:

• Users with MySQL v5.6.3+ will now see explain plan for Insert, Update and Delete queries in Wayback Machine and Query analyzer.

Monyog 6.34 (September 2015)

Features:

• Added more monitors and charts for monitoring a galera cluster. By default, these monitors are hidden. To display these monitors in Monitors page you can enable “Galera” monitor group from Customize -> Manage Monitor Groups. Charts for these new monitors can be enabled from Customize – > Manage charts.
• Optimized system charts for faster loading.

Bug Fixes:

• EXPLAIN option was not available in Wayback Machine.
• In some rare cases, Monyog logged SQLite errors if deadlock details contained double quotes.
• In Wayback Machine interface, Monyog showed wrong time in queries tab when a point was selected in the chart.

Monyog 6.33 (July 2015)

Features:

• Added monitoring of the MySQL –tmpdir volume with the “Free Disk Space” Monitor for Linux (introduced in 6.32).
• Added an option to view X-Axis labels for large time based charts.
• The Performance_Schema -based “query sniffer” has been optimized.

Bug Fixes:

• Fixed a rare case, where “Charts” page was not loading properly.

Monyog 6.32 (July 2015)

Features:

• Added a “Free Disk Space” Monitor for Linux. This new feature will collect information directly from the file system (unlike the existing ‘Disk Info’ that uses MySQL “SHOW TABLE STATUS”). Information is collected from volumes storing both MySQL data directory and InnoDB data directory (if different), and user will be alerted if either crosses a specified threshold.
• In Charts page added an option to select a time interval for display by zooming a chart using mouse and similar input devices (touchpad etc.). Note that zooming one chart will change the timeframe of all the charts displayed.
• Added an option to view queries for a selected time range in time range based charts in Charts page.

Bug Fixes:

• In rare cases, Monitors page could show wrong data for Linux counters if the HISTORY timeframe was selected for the page. Other available timeframes were not affected.
• When monitoring a MariaDB server using a galera-based replication setup we will now execute SHOW ALL SLAVES STATUS rather than just SHOW SLAVE STATUS. Before this Monyog replication page showed an empty result and alerts were not sent. However due to limitations with current Monyog architecture we are only able to handle the first row of SHOW ALL SLAVES STATUS with this release, if more are returned, and only information from one slave node will be available.

Monyog 6.31 (June 2015)

Features:

• What is plotted in “Charts” (formerly “Dashboard”) page may now be specified as a time interval and not only as a number of latest sample points. This increases usability of the page.
• Long running query log now includes action (kill/notify/notify and kill) and the time of action.
• Locked and locking queries tab in Real-Time interface is optimized and loads faster.
• Added Wildcard filtering using the “*” character as wildcard for user and host in Query Analyzer for Slow Query Log.

Bug Fixes:

• Monyog failed to send notification for an InnoDB deadlock if deadlock details (as recorded by SHOW ENGINE INNODB STATUS) contained double quotes.

Monyog 6.3 (May 2015)

Features:

• A log of long running queries can now be generated and downloaded as CSV in Sniffer interface (applies only to Processlist mode of sniffer).
• Real-Time is optimized and loading a session is much faster now. Further it shows only data from top 200 open tables and databases.
• Wayback Machine now includes user and host information as well.
• Queries in Wayback Machine can now be exported as CSV.
• Monyog can now send long running query notification to specific selected users only.
• Wildcard filtering using the “*” character as wildcard for user and host is introduced in Sniffer (applies only to Processlist mode of sniffer).
• Same wildcard filtering implementation is also introduced for Ignore user and host in Long running query options in Sniffer (applies only to Processlist mode of sniffer).
• Monyog now logs what user killed a thread in Processlist tab.
• SQLite library bundled in Monyog is now upgraded to the latest version. This results in performance improvement for sniffer in particular where it can be up to ~50%.

Bug Fixes:

• In some cases, Monyog logged SQLite errors when CSOs (Custom SQL Objects) were enabled even when the CSO worked as expected
• Small UI fixes.

Monyog 6.27 (April 2015)

Bug fixes:

• Monyog no longer prompts the user to re-type the admin password while upgrading on Windows.
• In Edit Server page it was possible to retrieve the MySQL password by inspecting JSON with browser’s javascript debugging module/plugin.
• Monyog was not able to authenticate a user from LDAP group consisting of linked users (i.e. users with membership of more than one group).
• Monitors page failed to load in case an empty group (with no counters) existed.
• Replication tab failed to load after restart of a server when monitoring a master-master replication setup.

Monyog 6.26 (March 2015)

Bug fixes:

• When monitoring MySQL 5.6.3 and higher, Monyog reported false notification alert for ‘innodb_thread_sleep_delay’ when notifications for change in server configuration was enabled.
• Replication page failed to show data if SHOW SLAVE STATUS on one server was hanging.
• Server Config page was not always showing proper data when “show only changed values” is selected.
• In some rare cases Monitors page was not displaying data after editing SSH tunnel details.
• Monyog 32 bit build was not accepting port beyond 16-bit limit (> 2^16 – 1). This limit has been increased to handle full 32-bit range (up to 2^32 – 1).

Miscellaneous:

• Email Alerts in Monyog now contain Tag(s) and MySQL host of the corresponding server.

Monyog 6.25 (February 2015)

Features:

• Optimized Monitors page to populate faster. In particular in history/trends timeframe this is a dramatic performance improvement, as it will now populate 50 or more times faster than before with large data series.

Bug fixes:

• An incorrect (javascript) monitor definition could cause a yellow bar-shaped area to appear instead of a proper error in Monitors page for the affected counter.
• Setting ‘Notify Till Stable’ using the Monyog API was not working as expected.
• Fixed a rare crash with a large number servers monitored. It would require more than 300 servers registered for this crash to occur on an average system.
• Minor UI fixes.

Monyog 6.24 (February 2015)

Bug fixes:

• Monyog was resetting “Monitor long running queries” to NO after editing a server.
• Monyog failed to show servers in the UI after upgrading from a pre-5.57 version.
• “Critical”, “Warning” and “Stable” icons were not showing in Events tab when Monyog was running behind a proxy.
• Monyog sometimes logged an SQLite locking protocol error while opening internal database(s). But as this is handled it should not be logged as an error.
• Monyog allowed for saving of server registration details when “Long running query time” was specified smaller than “Minimum time taken” in sniffer settings. This makes no sense and will not save now.
• Monyog was not considering buffers and cached values from meminfo while calculating RAM usage. The formula for the same is updated now.

Miscellaneous:

• Charts are now enabled by default for all monitors which include MySQL status variables. For example: “Seconds behind master” in replication group.

Monyog 6.23 (January 2015)

Features:

• Added support for the ‘clear-text plugin’ (used by Oracle/MySQL LDAP authentication) and the ‘dialog plugin’ (used for MariaDB PAM authentication). There is no user setting for either. Monyog will transparently for user detect how to communicate with the server during authentication.

Bug fixes:

• When data collection was stopped for a server then, in some cases, user was not able to delete that server.
• In ‘Wayback Machine’ interface, the plotted values were sometimes not visible due to how axes were scaled in the chart displayed.
• If data collection for a server was stopped, then after restarting Monyog. and enabling data collection for that server, the values displayed in the Monitors tab were not getting updated in some cases.

Miscellaneous:

• UI changes for ‘long running queries’ and counters with CSO disabled to make it more intuitive how to fully enable those features.

• SMTP and SNMP alerts will now as default be sent first time an alertable counter has exceeded the ‘critical’ setting.

• Formula of a monitor will now be displayed in event detail dialog in Events tab.

Monyog 6.22 (December 2014)

Features:

• Monyog can now resend alert notifications till a counter becomes stable based on a reminder interval setting.

Bug fixes:

• 'Upgrade check' link in 6.21 informed that an "undefined" upgrade was available even though it was not the case.
• Performance-schema based sniffer failed if global sql_mode included "ONLY_FULL_GROUP_BY".

Monyog 6.21 (November 2014)

Bug fixes:

• In Monitors page, the small trend charts in current and delta timeframes were not displayed for some monitors.
• Charts were not displayed in Monitors page- History/Trend if data series contained "N/A" values.
• Monyog was not able to connect to MySQL server if password contained a leading or a trailing empty space.
• In rare cases, some server(s) could stop showing in the UI after Monyog restart.
• Fixed a rare irresponsiveness ("hang") occurring when starting data collection after editing server details.
• The option to stop the current running saved session was not available in Real-Time in some cases.
• A number of minor GUI fixes.

Monyog 6.2 (October 2014)

Features:

• The Real-Time interface in Monyog has been completey rewritten. In addition to a more consistent/intuitive GUI it is now able to collect data from multiple MySQL servers simultaneously ( one collection of Real-Time data per server). Once data collection for a server has been started it will continue until stopped by user, also if browser connection is closed in between. The sole exception is that Real-Time data collection for a server will stop after 3 days if no activity has happened inside the particular Real-Time session.
• Added an option to set line terminator for csv reports.

Bug fixes:

• Renaming a registered server to a new name already in use would not raise any error. Instead data for the affected server would not display anymore.
• In rare cases clicking 'test SSH settings'-button would not display any response.
• When registering a 'Postmaster Enterprise SMTP server' in Monyog, mail notifications failed to be sent.
• 'Diagnostics report' failed to download when Monyog was running behind a HTTP ('reverse') proxy server.
• Clicking on editing SMTP settings from server registration page did not redirect to tools page and thus editing was not possible from here. The problem was alone a problem with the particular hyperlink. From the tools page everyting worked as expected.
• The following gtid-related variables in MariaDB 10 could trigger false notifications: gtid_binlog_pos, gtid_binlog_state, gtid_current_pos, gtid_slave_pos and last_gtid.
• Monyog failed to establish SSH connection to Linux servers using the "OpenSSH-HPN" SSH implementation..
• When an identifier contained digits (such as 'abc12', 'ab12ab' etc.), the Query Analyzer, the WayBack Machine and Real-TIme interface would consider these digits literals, and they would be replaced with '?'.
• If Monyog did not have sufficient privileges to the MONyog/Data folder, adding a new server could crash Monyog.

Miscellaneous:

• Dashboard page was renamed to 'Charts'.
• The tab-order of Monyog's interface has been rearranged.
• Also note that 'WayBack machine' interface is still available (unlike what was the case with the 6.2 beta, where we experimentally removed it.

Monyog 6.1 (June 2014)

Features:

• Added more counters and advisors for MySQL 5.6 configuration.
• Added an extensive set of counters for monitoring the TokuDB storage engine. The monitor groups for this are not visible as default, but can be enabled from the 'Customize' interface

Bug fixes:

• Fixed a rare SQLite database corruption under very heavy load and with Custom SQL Objects enabled.
• Changing refresh interval setting for Processlist page was not possible for non-admin users.

Miscellaneous:

• Monyog installed on the Amazon Cloud from the Amazon Machine Image ("AMI") we provide as an option, will now start first time with the Amazon instance ID as the admin password and not an empty password as before. This change could take some days to propagate across the Amazon Cloud.

Monyog 6.02 (June 2014)

Bug fixes:

• CSV exports from Query Analyzer did not include the 'Db' (database) column when the Query Analyzer was used with Processlist-based sniffer or with slow log when stored in a table.

Monyog 6.01 (June 2014)

Miscellaneous:

• Cleaned up the User Interface in Real-Time page. This includes removing the option to restore saved sessions for 'all selected servers'. Saved sessions for individual servers can still be restored.
• OpenSSL is updated to version 1.0.1h in all packages distributed.

Monyog 6.0 (June 2014)

Features:

• The Monyog API is enhanced with more options to manage servers registered in Monyog. Options now include calls to add/edit/remove servers. Refer documentation for full details.
• Monyog now supports Query analysis using Performance Schema tables (events_statements_summary_by_digest and events_statements_history_long tables). This feature is supported only for MySQL 5.6.14 and MariaDB 10.0 and above.
• Explain plan is available in Query analyzer for Slow_log table based logging and Processlist sniffer.
• An example query is now shown in detailed query view in Query analyzer if queries replaced with literals is selected.
• Monyog now has a configurable option to define the max. query length displayed. Beyond this Monyog will truncate. The setting has effect for Query Analyzer, Real-time and Way Back Machine interfaces. Default is now 10000 characters and maximum setting is 64000 characters). However please note that this does not apply when Performance_Schema is used with the Query Analyzer as P_S itself truncates.

Bug fixes:

• Explain option was not available in locked and locking queries for Real-Time sessions.
• In some rare case Monyog logged SQLite errors while running Real-Time sessions.
• Monyog could crash when connecting using a 'Named Pipe' on Windows.
• When monitoring MySQL v5.6 with replication using GTIDs (global transaction IDs), Monyog reported false notification alert for the 'gtid_purged' variable, when notifications for change in server configuration was enabled. This particular variable was overlooked in 5.72 where there was a similar fix.
• Query literals with hex values were not replaced with '?' in Query analyzer.
• When using SSH-tunnel, connections created by the CSO (Custom SQL Object) feature were not always closed properly, and the MySQL error log as well as 'aborted_clients' status variable would record aborted connections.

Miscellaneous:

• When GTID's (Global Transaction ID's) were used with replication, Monyog's replication page would display a lot of information about changing GTIDs. This is now hidden in the primary interface, but can still be displayed in detailed view.
• Monyog now displays the binary version on commandline when the command switch -version (or -v) is used.

Monyog 5.72 (April 2014)

Bug fixes:

• In rare cases, Monyog could not close alerts from Monitors page.
• When monitoring MySQL v5.6 with replication using GTIDs (global transaction IDs), Monyog reported false notification alert for GTID counters when notifications for change in server configuration was enabled.

Miscellaneous:

• Upgraded libraries that theoretically could be vulnerable to the 'Heartbleed' OpenSSL bug.

Monyog 5.71 (March 2014)

Features:

• With only one MySQL server selected, Dashboard page will now display charts in such a way that whitespace and the need of scrolling are reduced. With more than 1 servers selected, the Dashboard charts are drawn using a vertical layout as before.
• Real-Time interface can now show the actual query in addition to replacing literals with the "?" wildcard.

Bug fixes:

• Using TAGS for registered servers in order to manage access for non-admin users did not always work as expected when multiple TAGS were used.
• Yet another fix for a LDAP group authentication issue.
• In Real-Time interface EXPLAIN option was not available if query length was greater than 5000.
• In Real-Time interface database and user@host were not available for aggregating queries. They are now.

Miscellaneous:

• MySQL availability and System availability charts in Dashboard are now disabled by default. Users who want them can enable from Dashboard Customize page. We removed them primarily as they consume space in the interface and have little information that is not obvious from other charts.

Monyog 5.7 (March 2014)

Bug fixes:

• 5.69 introduced an issue causing LDAP authentication to fail in some cases.

Miscellaneous:

• Code cleanups and internal optimizations. Users having a large number of MySQL servers registered will observe a lower system load with this version due to this.

Monyog 5.69 (February 2014)

Bug fixes:

• LDAP search for user in group authentication could fail with Active Directory.
• Real-time sessions could fail under rare circumstances when two or more sessions were started at the same time.
• Fixed a crash introduced in version 5.68.

Monyog 5.68 (February 2014)

Features:

• Sniffer now shows database name in long running query notification and also in Query Analyzer interface when Processlist based sniffer is selected. Please note that Processlist only exposes this information if a USE statement is associated with the query. If a 'fully qualified tablename' is used in the query this information will be empty.

Bug fixes:

• Monitor's trend charts and history report charts were not displayed. This was introduced in Monyog 5.67.
• Significantly improved the speed of replacing literals for queries with wildcards in Query Analyzer.
• Connection to MySQL via SSL encryption could fail with valid parameters. This bug was introduced in Monyog 5.61.

Monyog 5.67 (February 2014)

Bug fixes:

• Fixed a rare crash occurring in CSO's (Custom SQL Objects).
• Fixed a UI issue in Realtime's lower pane. Only Safari browsers were affected.
• Monyog did not retain LDAP group authentication details after restart.
• Monyog's interface for specifying LDAP groups did not allow for more than 64 characters.
• Query Analyzer did not show queries when time range was selected with slow log and general log tables (log files were not a problem) as the source for Query Analyzer.
• CSV-reports exported from Monitors page could show wrong values for a few monitors.

Miscellaneous:

• Monyog now loads list of servers interface faster.

Monyog 5.66 (November2013)

Features:

• Monyog can now authenticate users using LDAP user groups without the need to add them in Monyog.
• Explain plan for Insert, Update and Delete queries is now available in Monyog's Processlist page for MySQL 5.6+ servers.

Bug fixes:

• The fix for failing alerts for InnoDB deadlocks with MySQL 5.6 servers in 5.65 introduced a new issue where the time for the occurence of the deadlock reported was wrong.
• When monitoring a Galera cluster and when cluster nodes failed to connect to each others, the error sent by cluster nodes ("unknown command") could cause Monyog to crash.
• When a server was deleted from Monyog in rare cases the corresponding data directory was not removed.

Miscellaneous:

• Linux versions of Monyog now include a script that can be used for log rotation of the Monyog.log.

Monyog 5.65 (November2013)

Bug fixes:

• Parsing the output of SHOW ENGINE INNODB STATUS for InnoDB deadlocks if server was MySQL 5.6.x. For same reason alerting also failed.
• Some counters failed to report alert conditions. This bug was introduced in Monyog 5.62

Monyog 5.64 (October 2013)

Bug fixes:

• This release includes fixes for a rare crash when deleting servers and when trying to access a SQLite database that could not be accessed for some reason.

Monyog 5.63 (September 2013)

Bug fixes:

• If Monyog was not able to connect to a MySQL server, replication page would 'hang' and even crash in rare cases. This was introduced in 5.62.

Monyog 5.62 (September 2013)

Features:

• Removed a hardcoded limit (of 512) of the number of MySQL servers that could be registered with an 'unlimited server'-license. Now the restriction is solely with the implementation of the license in the license key.
• Added and updated a few counters in order to provide more specific support for MySQL 5.6 and MariaDB 10.

Bug fixes:

• Cleaned up javascript execution running in the background that was not needed. With a large number of servers registered (from around 150 on a typical system) this could result in some slugginess in interactive parts of Monyog due to CPU contention.
• Explain option was not present in processlist page for queries starting with comment.
• On Windows 'Real_time' monitoring did not work since 5.61.
• Rendering of replication page failed if GTID (Global Transaction ID) mode was enabled for MySQL Slaves.
• Resolving the ip from a host name happened multiple times during display of replication page what could slow down rendering of replication page noticably on some environments.
• Some Dashboard charts could show incorrect data.
• Dashboard failed to render charts when based on a counter saved without caption, series caption and series values.
• When restarting Monyog it would perform a SQLite Schema upgrade even if it was not required. Version 5.61 was affected.

Monyog 5.61 (August 2013)

Miscellaneous:

• MySQL 3.23 and 4.0 servers are no longer supported and an attempt to register such will be denied.

Monyog 5.6 (August 2013)

Features:

• Monyog supports LDAP authentication for login into Monyog interface. This is available only in Ultimate version of Monyog.
• Added a feature in Query Analyzer to include or exclude queries based on the search string / regular expression.

Bug fixes:

• Monitor trend charts were not updating in realtime.
• Tooltips were truncated in DiskInfo's table information.
• In Sniffer, "Queries starting with" option was not working properly if query started with comment.
• Queries starting with a comment did not show EXPLAIN option in the Real Time interface.
• Fixed a crash when viewing replication page if slave details were not properly specified (any detail NULL).

Monyog 5.58 (April 2013)

Features:

• Added a feature in realtime to include or exclude queries based on the search string / regular expression.

Bug fixes:

• Purging mechanism was not working properly (this bug was introduced in Monyog 5.57).
• Tag/Group names are in alphabetical order now.
• Monyog can now "Kill query" on Amazon RDS instances.
• The rendering of Dashboard page is further improved.

Monyog 5.57 (March 2013)

Bug fixes:

• The rendering of Monitors and Dashboard page was slow with large number of servers both registered and selected and when multiple users were connected simultaneously displaying the page. It could take one minute or more in some cases. It is now a matter of seconds.
• With a large number of servers registered, editing details for one was slow. Also this could take around 1 minute, and the improvement is in the same range as above.
• Event manager's database (Events.data) is now moved from global level to server level in order to prevent locking problems with a large number of servers. Monyog will migrate data first time it starts after the upgrade.
• Fixed a multi-threading issue that in rare cases could crash Monyog while registering more than one server at the same time.
• Fixed a rare crash in Monyog while viewing replication tab.
• Fixed a rare crash in Monyog while resolving CSOs ("Custom SQL Objects").
• Monyog could fail to send mail alerts if a single mail contained alerts for more than one monitor.
• Monyog was showing errors in Query Analyzer, Realtime and Processlist pages when a query contained characters used for specifying HTML tags.
• If a registered server was not a slave but marked as such in Advanced Settings .. Replication, Monyog was leaking connections every time it was collecting data and finally connections (from Monyog as well as other clients) could fail due to 'max_connections' setting being exceeded.
• For MySQL InnoDB-related monitors were showing "(n/a)". The reason was removal of the 'have_innodb' server variable in MySQL 5.6.

Monyog 5.56 (December 2012)

Bug fixes:

• Fixed a memory leak when reading MySQL server logs through SFTP.
• Fixed a multi-threading issue that in rare cases could crash Monyog running on Linux while reading the MySQL error log.
• "Apply settings to all the servers with same tags" was not working when data collection was disabled globally.
• The fix in 5.55 for indented display of a slave compared to its master was not complete. Proper indentation could still fail.

Monyog 5.55 (December 2012)

Bug fixes:

• In the replication page a slave was not displaying indented compared to its master as it should if slave and master were running on same host.
• Fixed a multi-threading issue that in rare cases could crash Monyog if the Monitors page was viewed simultaneously in multiple browsers.
• Stability fixes for issues found during internal stress-testing and code review. No crash, slowdown ('hang') or similar was reported due to any of those, but it could theoretically happen under specific and rare circumstances.

Monyog 5.54 (November 2012)

Bug fixes:

• Sometimes Monyog could hang while editing server's tag.
• Processlist did not show "view query" for prepared statements.

Monyog 5.53 (November 2012)

Features:

• Added monitors for monitoring a galera-based cluster. These monitors do not display as default but there is a 'Galera' monitor group that can be unhidden from Tools .. Manage Monitor Groups.

Bug fixes:

• Authentication to SMTP servers could fail with very long passwords. Also authentication with Amazon SES could fail.
• When saving a connection Monyog could apparently 'hang' for a while.
• With a large number of sample points displayed in Dashboard, loading of the page was slow. It could take up to around 1 minute in some cases. Now it is a few seconds.
• SSH keys could be 'forgotten' after a Monyog restart.
• Fixed a rare crash when editing server details.
• In the 'Real Time' interface the option to EXPLAIN queries did not display in Internet Explorer 8.
• For non-admin users, the replication tab was displaying all slave servers instead of showing only those servers which the user has access to.
• Internal optimizations, library upgrades etc.

Monyog 5.52 (October 2012)

Bug fixes:

• When upgrading to Monyog 5.51 admin rights for users with such failed to be migrated. This release fixes this for both users that have already upgraded to 5.51 and those that have not.

Monyog 5.51 (October 2012)

Features:

• Added a number of monitors and advisors - mostly based on metrics exposed by MySQL 5.5+.
• In the 'Real Time' interface user may now define the threshold for when a query should be considered slow. Lowest possible setting is 1 second.
• In the 'Real Time' interface queries are now truncated after 5000 characters. Before it was 1000.
• 'queries' and 'slow queries' can now be exported to CSV in the 'Real Time' interface.
• Original query formatting is now retained in 'Real-Time'.
• User Manager has added a privilege to allow (or not) to 'view literals' in Query Analyzer page for non-admin users. This can be used for blocking access to read sensitive data for such users and still giving them access to use the Query Analyzer.
• Multiple saved Real-Time sessions can now be viewed at a time.
• Added a 'thread count' showing number of currently running threads on 'Processlist' page.

Bug fixes:

• In the 'Real Time' interface displaying large BULK INSERTS was slow.
• Logging out from Monyog while 'Real Time' was populating could crash Monyog. Linux - and not Windows - was affected.
• In the replication overview page Monyog will now show 'binlog' file name and it's position wherever it applies (where binlogging is enabled). Before it was showing only for master servers.
• In the Monitors page the percentage of SELECTS did not display. This was unlike INSERTS, DELETES and UPDATES .
• A 'Long running query' email alert has added a note clarifying that when the alert was sent the query may still be running. Before it could be understood like the alert was sent after query had completed.

Monyog 5.5 (September 2012)

Features:

• Added a new major feature called ‘Real-Time’ to monitor MySQL. This feature details the top 200 queries, slow queries, locked queries, locking queries, tables, databases, users, hosts and query states in real time. Information is retrieved from MySQL every one second. Queries taking more than 10 seconds to execute are considered as slow queries. Note that Monyog depends on the ‘InnoDB Plugin’ (optional with recent MySQL 5.1 versions, standard with higher MySQL versions) to get information on locked and locking queries. Refer MySQL docs for more information on InnoDB plugin. Also note that constants listed here are currently 'hard-coded' but we plan to implement user settings. 'Real-Time' is an Enterprise and Ultimate feature.
• Optimized Monitors page to retrieve and display data approximately 10 times faster than before
• Added an option to choose verbosity of email notifications. 'lesser verbosity' is in particular relevant if you receive mails on a mobile phone or another small handheld device.
• Added 'Monitor level' email-address alert setting. If an email address is specified for a specific monitor, notification will be sent to that particular email-address when the monitor is alertable in addition to the email address specified globally for the server.
• In the MySQL query log settings page, the 'file path' field for general query as well as slow query log was disabled for MySQL versions lesser than 5.1.6.

Monyog 5.3 (July 2012)

Features:

• Introduced support for 'native' MySQL SSL-encryption with direct MySQL connections.
• Monyog now fully supports IPv6 (Internet Protocol Version 6).
• History-trends have been optimized to retrieve data faster than it was before. With large data sets this results in a speed improvement in the range of a factor ~25.
• Passwords for Monyog users are no longer stored in clear text. A hash is stored (for admin user in MONyog.ini - for other users in the embedded database). Also MySQL passwords as well as SSH/SSL keys, certificates and passphrases are now stored obfuscated. First time Monyog starts after upgrading from a version using clear text storage it will rewrite passwords etc. to the hashed/obfuscated representation.
• Added a Linux counter "Load Average" as exposed by the Linux kernel in /proc/loadavg.

Bug fixes:

• Fixed a memory leak with SSH key based authentication.
• If HTML tags were a part of long running query, the notification email format was getting distorted.
• MySQL connection through SSH tunnel never re-established connection in Sniffer module when the connection failed for the first time
• Filter settings in the sniffer defined on a (MySQL) user with a SPACE character in its name did not work as expected.
• UI fixes.

Monyog 5.21 (June 2012)

Features:

• The Monyog API was rewritten and enhanced with more options. Options now include calls to enable/disable data collection, sniffer, notifications etc. for servers by either specifying a server name or a server tag. The old API calls have been blocked.

Bug fixes:

• Notification emails were not being sent when the number of file descriptors used by Monyog exceeded a certain number.
• Fixed a bug with the Custom SQL monitor where no data was being displayed in the Monitors page when all the columns retrieved by the Custom SQL were specified as Key Columns.
• Increased readability by improving SNMP trap format.
• UI fixes and enhancements.

Miscellaneous:

• Testing slave connections has been moved to replication monitoring settings. Prior to this release it was in 'MySQL settings' tab making it necessary for users to switch between tabs for testing slave connections.

Monyog 5.2 (May 2012)

IMPORTANT note:

• This release requires a new registration code. Neither the 5.1x nor the pre-5.1x key will work with this. Registered customers will get the new code from our Customer Portal. Please have the new code available before installing. Until Monyog is registered with new keys, it will not be collecting data from your servers.

Features:

• Added filter for including or excluding specific hosts and(or) users in Slow log analysis.
• Added and modified a few Monitors related to Replication, InnoDB and Security. Most of this utilizes metrics exposed by MySQL from version 5.5 .
• Added a preconfigured Custom SQL Object (CSO) for Percona Servers exposing the most written and most read tables.
• There is now session-wide persistence while sorting columns in Query Analyzer.
• Improved error messages in Query Analyzer and Wayback machine.
• Usability enhancements, GUI fixes and internal optimizations.

Bug fixes:

• Monyog was not working while behind Apache configured as a reverse proxy. This bug was introduced in Monyog 5.0.

Monyog 5.12 (April 2012)

Bug fixes:

• Sometimes the default landing page failed to load after a log in. A refresh was necessary. This was introduced in Monyog 5.0.
• Closed alerts could reappear in the Monitors page after an unsuccessful data collection and MySQL restart.

Monyog 5.11 (April 2012)

IMPORTANT note:

• This release requires a new registration code. Registered customers will get the new code from our Customer Portal. Please have the new code available before installing. Until Monyog is registered with new keys, it will not be collecting data from your servers.

Features:

• Introduced tag level customization in Monyog Monitors. Monyog tags for servers are now available as Monyog Object Model variable (MONyog.Connections.TagName returns an array of tag names defined for a server). Documentation has examples on how to use it in scripting. Also see the note on 'Native Javascript properties' support in next point below.
• Native Javascript properties (like length, indexOf, splice etc) are now fully supported in Monitors and Dashboard. Note that 'indexOf' is required to check for individual tags from the array exposed by Monyog.Connections.TagName (see point above) in case there is more than one tag.
• Optimized Dashboard page to retrieve information faster.
• Auto-registered slaves will now have server names as their host names as default.
• Auto registering slaves will now assume the SSH host name of the slaves to be same as that of MySQL host. Before this the slaves' SSH hosts were assumed to be the same as that of the master.

Bug fixes:

• On Monyog restart, server edit, SQLite vacuum and Mysql restart there were 2 consecutive data collections with a short time interval. This could skew charts and MySQL metrics. Now Monyog collects data 2 consecutive times only when required - i.e during the first collection and after an unsuccessful data collection.
• Exporting charts as PNG exported as JPEG instead in Monitors page. This bug was introduced in Monyog 5.0.
• UI fixes.

Miscellaneous:

• Increased Monyog session timeout from 30 minutes to 8 hours (the MySQL default).

Monyog 5.1 (March 2012)

IMPORTANT note:

• This release requires a new registration code. Registered customers will get the new code from our Customer Portal. Please have the new code available before installing. Until Monyog is registered with new keys, it will not be collecting data from your servers.

Features:

• In the 'Disk Info' page, clicking on a donut chart in the Database level of a server will now drill down to table level.
• Query Analyzer' now has information on Average rows sent & examined while analyzing Slow Query Log. Those options has been hidden in version 5.0 and seen only in "Query details" pop up, now in v5.01 users can view those columns in QA output along with "Query details" pop up.
• Comparison of MySQL server configuration of multiple servers side by side is now faster in the 'Server Config' page.

Bug fixes:

• The 'login' page sometimes did not work in some 'minor' IE 8 builds (if not updated with latest patches from Microsoft). Same could happen with Google Chrome that were not up to date. This happened due to 'Google Gears' (that is no long part of Chrome). It now will work with all IE8 builds and Chrome from version 9.x (current is 17.x) - also with 'Gears'.
• MySQL server configuration could show incorrect values if MariaDB Servers were compared in the 'Server Config' page.
• A MySQL server that was a master and a slave at the same time was not showing the slave status in the 'Replication' tab even if it was marked as a slave in 'Register Server'.
• In the 'Replication' tab of Monyog the display of binlog_do_db and binlog_ignore_db settings were interchanged.
• On a fresh installation the default Monyog port was 8888. This was introduced in 5.0. Its now reverted back to 5555.
• Sometimes queries could fail to display in 'Wayback Machine' interface.
• In 'Monitors' page - History/Trend view charts did not plot if data series contained '(n/a)' value(s).

Miscellaneous:

• Internet Explorer 6.x and 7.x are no longer supported. And actually this should have been announced in 5.0 GA release notes, but it was missed (it was announced in 5.0 beta1 release notes however).

Monyog 5.0 (February 2012)

UI Enhancements:

• Introduced a left panel that contains the list of servers registered in Monyog, 'Tools' & 'Customize'. The 'List of servers' page has been removed. Users can now select/unselect servers from this panel.
• Previously available icons for Edit server/Duplicate server/Diagnostic reports etc now appear as a drop down menu next to each server.
• Previously the 'Customization' page appeared under 'Tools', now it appears as 'Customize' on the left panel.
• 'Manage changed Monitor/Advisors & Dashboard charts' are now available as 'Manage changes' under 'Customize'.
• 'Manage Custom SQL Objects' are now available under 'Manage changes'.
• The Global Notifications come on the top right hand corner before the help button.
• Pagination in Query Analyzer page. This removes the limitation of 200 queries in the result set.
• 'Monitors' is now the default landing page.

Features:

• Added an option to add users to admin group.
• Columns in the replication tab can now be sorted.
• Register/Edit server page now has tabbed interface which eases navigation.

Enhancement:

• Improved browser level caching.

Miscellaneous:

• The Monyog API responses are now in the following JSON format: {"STATUS": "SUCCESS/FAILURE", "RESPONSE" : ""}
• Query Analyzer will now display query text up to 5000 characters. (before it was 2000)

Monyog 4.81 (January 2012)

Bug fixes:

• Custom SQL Objects (CSO) with a large result set could fail to display content in Monitors/Advisors page.
• Specifying the "Key Column" field has now been made mandatory while adding a new CSO. If not specified the CSO will not save.
• Small UI fixes.

Monyog 4.8 (December 2011)

Features:

• This release adds a new major feature to Monyog: Custom SQL Counters and Custom SQL Objects. A Custom SQL Object is an object populated from a user-defined SQL-query returning a result set. It is exposed as a javascript array for defining counters (Custom SQL Counters) in Monyog.

Bug fixes:

• If a query contained the literal substring 'connect' Monyog could hang during general log analysis.
• Monyog returned a garbage string to the Linux 'ps' command.
• Drastically improved performance in log analysis if the option to 'replace literals' was selected.
• Some of the Monitors/Advisors were not updating in All Time/Current and Delta timeframe.

Monyog 4.72 (October 2011)

Bug fixes:

• When connected to Linux distributions with a 3.x kernel the information about Disk I/O could fail to display properly in Dashboard and Monitors/Advisors pages of Monyog.

Monyog 4.71 (October 2011)

Bug fixes:

• Accessing the replication tab could crash Monyog in rare cases with specific replication setups and where SHOW MASTER STATUS returned an empty result.
• Fixed an issue where user defined generic (javascript) functions added for use by customizations did not work as expected.
• Small UI fixes.

Monyog 4.7 (October 2011)

Features:

• Added a MySQL replication overview page. Here Monyog shows the replication topology of all registered MySQL servers, as well as SLAVE STATUS and MASTER STATUS where it applies. The display gets updated at user-specified interval. (Note: This is available only in Ultimate version of Monyog)
• Added a 'Wayback Machine'. In this interface a graph displaying - as per user's choice - either of the status variables 1) Threads connected or 2) # of slow queries. The graph displays aggregated values on years/months/days/hours/ minutes depending on the data. If sniffer was running during this interval, aggregated sniffer information will be displayed. Also you can see first and last value of (optionally) all or changed variables aggregated values. The graph is zoomable by selecting a sub-interval with the mouse along with aggregated sniffer and changed variables you can also get point-in-time information by clicking on a point on the graph. When user clicks on a row in the query list of the Wayback machine a pop-up opens with information about thread-id, user and host along with full query.The list of queries in Wayback Machine will not be rendered if there are more than 2000 queries in the time period. There is a user control that can be activated in such case. The reason is that every 1000 queries take around 1 seconds to render on an average desktop system. This also means that we can now display the list of queries before zooming (provided still that there not more than 2000 queries to display). When we do a point in time select of one of the points on the graph, we get a bar chart that displays number of queries.
• With this release the dependency on Flash has been removed. Charts are now rendered using a Javascript library. Accordingly Monyog can now be handled from a browser on a device not supporting Flash (such as Ipad). These charts can be exported like was the case with Flash-based charts of previous versions. Conversion to various formats uses a web service.

Bug fixes:

• Fixed an issue where Monyog did not logout user successfully.
• If the time is set to 12:XX:XX in Custom filter it resets to 00:XX:XX.

Miscellaneous:

• Instructions to setup MySQL Proxy was added to Monyog interface.

Monyog 4.62 (July 2011)

Bug fixes:

• The counter for 'thread cache hit rate' could display incorrect values.
• Authentication with the admin password could fail in some cases on Windows. This bug was introduced in 4.61.

Monyog 4.61 (July 2011)

Bug fixes:

• In Dashboard & Monitors/Advisors page, the Delta & All-time/Current charts were showing incorrect values when values were plotted per second. This was introduced in Monyog 4.51.
• While connecting using SSH with key based authentication in Windows, the temporary file which contains the SSH private key was not being deleted. Before this release, the temporary files could run out of names which made it impossible to create new temporary files and hence the SSH tunnel was not being created.
• Monyog now writes default data into MONyog.ini file on all platforms when Monyog starts for the first time. Before this release Monyog for Linux did not write default data into MONyog.ini file.
• Fixed a crash occurring when there was no data directory path mentioned in the MONyog.ini file.

Monyog 4.6 (June 2011)

Features:

• Monyog is now bundled with a bunch of useful dashboard charts which can be enabled/disabled from the 'manage dashboard charts' in the Dashboard page. These charts can even be re-orderd.
• Added an option to 'Alert on change in server configuration'. These alerts in the form of email's and/or SNMP traps are sent by Monyog whenever Monyog detects a change in the server variables using SET GLOBAL statements or in the MySQL configuration file.
• Added an option to copy/duplicate advisors. This is available when clicked on an advisor in the 'Monitors/Advisors' page.

Bug fixes:

• Export as CSV in the 'Monitors/Advisors' page was showing '0' for some of the advisors when the group to which they belong was disabled.
• GUI fixes, including an issue where clicking a 'next'-link in the 'register server' page did nothing.

Monyog 4.51 (May 2011)

Features:

• This release focuses on improving performance of the Monyog built-in HTTP daemon. You will find up to 10 times performance improvements for most Monyog pages. This has been achieved by internal code optimizations, use of compression (if browser supports) and minification/optimization of HTML, Javascript, CSS and graphics.

Bug fixes:

• Prepared statements were not handled properly by the Query Analyzer.
• Events (as introduced in 4.5) stored in the Monyog embedded database did not purge as specified in the 'retention time frame' setting.
• Charts could display decimal numbers with a large number of decimals that made no sense and made charts less readable. We now round to 3 decimals.

Monyog 4.5 (May 2011)

Features:

• Added an EVENTS overview. An EVENT happens when any counter is changing its status to (yellow) WARNING alert level or to (red) CRITICAL alert level. An 'alert condition' (WARNING or CRITICAL) can be temporarily disabled (and re-enabled) for a specific server from the new EVENTS overview page as well as the Monitors/Advisors page. This can be disabled for non-admin users.
• Replication slaves can now be automatically registered. Monyog will detect the host/IP of active slaves. MySQL (port,username & password) and the SSH details of the slaves are assumed to be the same as that of its master. Connection details of the slaves can be edited if different from master. A slave will indent with its master in a hierarchy while displaying in the list of servers page. Auto-registering of slaves is also extended to multiple levels. 'Test Connection' in the 'Register/Edit server page' will test the slave connection details of that server in recursion, when 'Auto-register all slaves' is checked.
• In the process-list based sniffer there is now an option to alert (using mail and/or SNMP) for long-lasting LOCKs.
• Monitors/advisors groups can now be enabled/disabled on a per server basis. Before this release it was only possible to have same setting for all servers registered in Monyog in this respect.
• Added monitors/advisors for innodb_force_recovery, log_warnings, log_output, expire_logs_days,

• max_binlog_size and flush_time variables.

• Query Analyzer can now filter slow logs based on host and user information.

• The standard Linux daemon PID file is now created for Monyog. (If tools like 'Monit' are being used, then the PID file of Monyog would be required.)

Bug fixes:

• Padding while exporting slow log as CSV was incorrect.
• Monyog could hang while parsing a log file with binary data.
• With Monyog running behind a Load Balancer and similar network management system, user login to Monyog could fail.
• Monyog could hang while downloading slow or general logs from a server if the server wrote new entries to the log at download-time.
• The emails sent by Monyog were missing the date header.
• Monitors/advisors page was displaying error for MySQL 5.5.x when Innodb engine was disabled.
• Fixed an UI issue with the Group level display of alerts (red/yellow) in monitors/advisors page.
• Fixed a bug with the system graphs in the 'dashboard' feature where the graphs were not plotting the current values.
• Lots of GUI fixes and small GUI enhancements.

Monyog 4.2 (January 2011)

Bug fixes:

• Monyog could crash while monitoring hundreds of servers through SSH tunneling with a small data collection interval. (1 or a few seconds)
• Charts in the I/O section under Monitor's/Advisors or Dashboard displayed wrong history. (last 14 seconds had the same values as the value in the 15th second)
• Sometimes, while analyzing the slow query log, some timestamps contained the default unix time stamp.
• If the name of a counter or caption of dashboard chart contained single quotes, the chart displayed "Invalid XML Data".
• Filtering while displaying the Sniffer output was not working when there was a change in the filter conditions.
• The Linux command 'Service MONyogd status'did not display the correct result.
• The 'Processlist page' in Monyog threw 'constraint failed' error when the process ID was a large number.
• At times, the 'Query Execution Time' of Query Analyzer displayed incorrect values for the milliseconds field.
• Monyog was not closing the file descriptors after reading from MySQL error log (introduced in 4.12) and sending SNMP traps.

Miscellaneous:

• Every time Monyog (re)starts it logs "MONyog has started" in MONyog.log.

Monyog 4.12 (December 2010)

Bug fixes:

• Monyog was leaking memory while connecting through SFTP to analyze Slow/General logs.
• Monyog also leaked memory when 'Processlist' page was open.
• Stopping of Data collection could crash Monyog.
• Sometimes Monyog service could not be stopped gracefully.
• Monyog was not able to read the Error log via SFTP for data collection interval less than 25 seconds.
• Max open .idb files counter under Innodb-Others group sent a false 'warning alert'. (Yellow light would turn on even though the value of innodb_open_files did not exceed the threshold)

Monyog 4.11 (November 2010)

Bug Fixes:

• Email alerts or SNMP traps related to counters were not sent. This was introduced in 4.1.
• Minor usability fixes.

Monyog 4.1 (November 2010)

Features:

• Implemented an easy-form based interface for customizing helper functions. Any customization of helper functions or user defined functions being used with earlier versions have to be migrated manually to this version. From this version and onwards a GUI-'conflict resolver' will guide the users very similar to how it works for customized counters.
• Monyog now has an option to apply a group of settings to all the servers with a specific tag. (Please note: New servers registered later with the same tag are not considered)
• Monyog logs from now on contain the server name along with error, making it easy to backtrack.
• We have automated deleting dump files of size zero.
• Earlier multiple alerts for same issue would be sent if the counter was alertable for more than the specified number of data collections. Now we only send once. Settings in register server page has been updated accordingly.
• Added an option to change the refresh interval from the processlist page.
• Processlist-based sniffer will no longer show the query 'SHOW FULL PROCESSLIST' executed by Monyog (Please note: This only applies to the processlist-based sniffer and not to the processlist page where user has configurable filtering options).

Bug fixes:

• Fixed a (SQLite) database lock resulting in failure to update Dashboards and Monitors/Advisors pages.
• When SFTP option was chosen to analyze 'MySQL general query log' and SSH was disabled, Monyog used SFTP to analyze the logs with out throwing any error.
• Small GUI enhancements.
• Resolved crashes found internally.

Monyog 4.02 (September 2010)

Bug fixes:

• Fixed a performance regression issue (introduced in 4.0) in HISTORY/TREND analysis.
• Fixed an issue where Dashboard charts were not always populated properly with 'old' data when the Dashboard page was opened. The chart itself and the data-series for the chart are independent data streams which were not always 'combined' correctly.
• The process-level Monyog stack size on Linux is now always expandable up to 10 MB (Linux kernel default) even if the user has defined another value. We had a report where Monyog would crash with a very low user setting (and this is basically an OS issue and not a Monyog issue).
• If a Monyog build with a 'lower' license than ULTIMATE was installed 'on top' of the TRIAL some ULTIMATE functionalities would still run in the background - but not controllable by user. MONyog continued to collect data internally for counters not applicable to ENT or PRO edition and the Monyog.log would log errors irrelevant for the license model

Monyog 4.01 (August 2010)

Bug fixes:

• Implemented code that makes OpenSSL (which is used by our SSH library) explicitly thread-safe, thus fixing an issue where specific cryptographic function calls under very heavy load could cause a crash.
• Fixed a SQLite corruption issue on Windows due to which Monyog service failed to stop.
• If both values for 'user' and 'host' were filtered in processlist-based sniffer the interface would display NULL for both.

Monyog 4.0 (August 2010)

Features:

• Compare Configuration: This feature enables the user to compare changes in configuration between two instances of MySQL. Through this feature, the user will gain a greater insight on why one server is performing better than the other as far as server configuration is concerned.
• Track Changes: This feature enables users to track changes to my.ini/my.cnf of a MySQL server over a period of time and compare changes between revisions.
• Added a new interface for customizing Monitors/Advisors and Dashboard charts requiring less knowledge of JavaScript than what was the case before.
• When upgrading an installation with customized Monitors/Advisors and Dashboard charts a 'conflict resolver' will now guide user to either migrate his old changes or discard them.
• All cache hit rate related monitors/advisors have been changed to display cache miss rate information as it more relevant when tuning databases. Also the advisor text for these monitors/advisors has been improved.

Bug fixes:

• Fixed some issues with specific counters including issues where 'undefined' or 'NaN' were returned incorrectly.
• Graphs in 'all time' and 'delta' timeframes for the counter 'Cache Misses' for as well InnoDB Cache, MyISAM key cache and Query cache groups were not displaying but threw the error "Invalid XML data" (these counters were added in beta 1).
• Previously accepted values for the "ChartValue" property in Dashboard charts were "Current" and "Latest". This has caused confusion since both terms mean the same thing in this context, although technically "Current" refers to the current value of the metric and "Latest" to the "Delta" value. Moreover, the documentation mentions "Actual" and "Delta" as accepted values. To eliminate this confusion, the "ChartValue" property now accepts the values "Current" and "Delta" - "Current" referring to the current value of the metric, and "Delta" to the difference in the metric between the previous two collections.
• Monitors/Advisors Customization: The Group Name of a Monitor/Advisor can now be changed only when a new, custom, counter is created; once set it cannot be changed. Changing Group Names of Monitors/Advisors shipped with Monyog is not allowed.
• All cache hit rate related monitors/advisors have been changed to display cache miss rate information as it more relevant when tuning databases. Also the advisor text for these monitors/advisors has been improved.

Miscellaneous:

• Windows 2000 is no longer supported.

Monyog 3.8 (August 2010)

Bug fixes:

• Monitors/Advisors on InnoDB Deadlocks were truncating the output message and hence in some cases, users were unable to view both queries involved in the deadlock. This has been changed such that the first 2048 characters of both queries are displayed.
• On Windows 7 systems changes to Monyog's .INI file from external programs had no effect upon restart (as Windows reverted the changes). Now throughout Monyog's lifetime the .INI file will be locked so that a user may only edit the file manually when Monyog is not running (but users can use the Monyog interface to change any setting while Monyog is running). Any changes made to the file when Monyog is not running will be reflected by it once it is restarted.
• If MySQL Error Log monitoring was enabled for a particular server, the first two data collections for that server would cause large network traffic to occur if the MySQL error log was very large. This was because the entire log fie is read in the first collection. Now only the last 1MB of the file is read.

Miscellaneous:

• All libraries have been upgraded to their latest versions. Although, from a user-perspective, the changes are minimal, this has alleviated several memory leaks and other performance issues.
• This release has been checked in depth with the best leak-detection tools available for both Linux and Windows. All discovered leaks have been fixed.
• The cache parameters for the SQLite library have been modified with this release to allow for registering more servers on the same system as before. Before Monyog's memory usage used to grow continually with time as each open SQLite handle has an associated cache which could grow to any size, irrespective of system capacity. The cache size per handle has been reduced and the total SQLite cache size will never exceed 1 GB with this build.

Monyog 3.77 (July 2010)

Bug fixes:

• Problem with SQLite where journal files were not being handled correctly leading to corruption of SQLite databases.

Monyog 3.76 (May 2010)

Miscellaneous:

• Added a ten server license.

Monyog 3.75 (April 2010)

Bug fixes:

• Failure to open the SQLite resource DB located in Monyog's installation directory could result in a crash. This crash has been fixed, but note however that Monyog is unable to function without this resource DB and will log an error message and perform a graceful exit.
• The Monitor/Advisor "Binary Log" --> "Transactions that got saved in temporary file" displayed "NaN" (JavaScript for Not-a-Number) for non-zero values of the associated MySQL counter.

Miscellaneous:

• Internet Explorer 6.2800 on Windows 2000 may hang when trying to display Monyog's interface. The behavior is not seen in the next iteration of IE6.

Monyog 3.74 (April 2010)

Bug fixes:

• Log analysis could use high CPU if the option to replace literals with a placeholder was not selected and the literal string ' "' (space + doublequote) occurred in the log file.
• CSV-export from Query Analyzer only exported 200 rows (the same number as displayed in the browser view). Now CSV-export will export all rows. Also the UI makes it now clear that the browser displays the 200 uppermost rows according to current sort criteria.
• An error message regarding an integer overflow could occur in Monitor/Advisors page for some values. The SQLite datatype used could be too short for some specific data.
• Login to Monyog could fail if Monyog was running behind a proxy.

Monyog 3.73 (March 2010)

Bug fixes:

• If SHOW ENGINE INNODB STATUS returned an error that was not privilege-related, Monyog reported MySQL as non-available. That could happen for instance if MySQL was started with --skip-innodb option. This bug was introduced in 3.71 with the support for InnoDB deadlock detection.
• A bug in the Monyog startup script could on Linux have the result that Monyog was still reported as running if it had been killed or had crashed.

Monyog 3.72 (February 2010)

Features:

• The number of builds for Linux has been increased to the double number of what it was before. In addition to the builds based on glibc version 2.3 we now distribute builds based on glibc 2.5. We had a few reports of random crashes (typically occurring up to a few times per week) occurring on recent 64 bit CentOS servers and in one case also a RHEL5. The glibc 2.5-based build fixes this. Although we only had such reports on 64 bit Linux of 'Red Hat Family' we also included 64 bit tar.gz for all Linux platforms and 32 bit RPM builds. The general advice on which build (glibc 2.3-based versus 2.5-based) should be used in every case would be that if glibc 2.5 or higher is available on the system you should use the 2.5-based build. Or simply use the one based on 2.5 if it installs and starts on your system. Upgrading users that are in doubt can continue with 2.3 - based builds if they have no stability issues.

Bug fixes:

• When Monyog encountered an SSH error while trying to read a file using SFTP it could crash. This has been fixed.
• Redundant "Server Restarted" alerts concerning monitored Linux systems could be sent by Monyog. Now Monyog will notify users only once when a system is restarted, and alert will be sent as soon as Monyog detects it.
• When restarting Monyog an error message could be written to the log indicating that an ALTER TABLE SQLite query failed to execute. Technically, it was an issue with a Schema version table in the Monyog database.

Monyog 3.71 (February 2010)

Features:

• Added a monitor for InnoDB deadlocks (as exposed by SHOW ENGINE INNODB STATUS - statement).
• In case of a program crash on Linux, Monyog will save a core dump like the Windows version already does. The dump is saved in .../MONyog/bin folder.

Bug fixes:

• EXPLAIN from Processlist page could fail with syntax error due to a missing SPACE character in the statement.

Monyog 3.7 (February 2010)

Features:

• The Monyog 'admin' user can now create other users having access to a subset of available servers only. For those non-admin users access to edit server settings, to KILL queries and to execute FLUSH STATUS is optional. Also note that only 'admin' is allowed to create/delete server and user registrations.
• Monitors/Advisors page can now be exported as CSV.

• Some counters in Monitors/Advisors page were rearranged. Details about this:

  1. "Security" and "Excessive Privileges" groups have been moved to the top.

  2. "Table Cache" and "Table Locks" have been merged to a single group "Table Cache & Locks".

  3. "Thread Cache" and "Slow Launch Threads" have been combined to a single group named "Threads".
  4. "Commands" and "Schema Changes" have been merged to a single group "Commands & Schema Changes".
  5. Counters in "Network Traffic" have been moved to "Connection History".
  6. Counters in "Sort Buffers" have been moved to "Misc.".

Bug fixes:

• FLUSH STATUS was not working for servers having space(s) in their names.
• Warning also displayed when global notifications are disabled.
• Duplicate 'Server restarted' messages were sometimes sent when Monyog is restarted.

Miscellaneous:

• Monyog is now available in three different editions: Professional, Enterprise and Ultimate (full-featured).

Monyog 3.65 (December 2009)

Features:

• You can now specify a comma-separated list of users to be ignored/excluded by notify and/or kill actions for long-running queries in 'query sniffer' interface.
• Added a 'diagnostic info' icon to servers in 'list of servers' page. Clicking this will generate a report in plain text with the most basic information about the server.
• Added an option to stop/start data collection for a server in 'list of servers' page (without opening the detailed pages for this server).
• Enabling/disabling data collection from and/or alerting about all servers can be done from tools .. preferences .. maintenance.
• Enabling/disabling data collection from and/or alerting about specific servers can be done by calling the Monyog URL with parameters. This can be scripted and scheduled using any standard method available with the OS. Please refer to documentation for details.
• Mail alerts will now have a direct link to open Monyog login page.
• Added an option to customize colors used in Dashboard.
• If global wait_timeout setting for a server is lower than the sample interval we will now increase session wait_timeout setting in order to avoid the MONyog.log to grow with a "MySQL server has gone away" message for each data retrieval.

Bug fixes:

• Fixed some issues with validation of user input. For specific data invalid and unusable input could be saved by Monyog. This includes 1) invalid separator between email addresses 2) Entering a decimal where an integer is required.
• SMTP return codes were neither logged nor were specific messages displayed to the user based on them.
• In history/trends an empty graph would display if server details were wrong. Now proper javascript errors are displayed.
• In connection details page for a server the previous/next links would hide with specific menu items selected.
• In History/Trends, warning message ("No data found in this range, try changing history range!") didn't show up for the time-frame in which server data collection was disabled.
• If Adobe Flash was not installed, the message to "install the latest Adobe Flash Player" was displayed more than once.
• Small GUI improvements and fixes.

Monyog 3.62 (December 2009)

Bug fix:

• When using the option (introduced in 3.6) to alert for long-running queries from the Query Sniffer interface, such long-running query could raise multiple alerts.

Miscellaneous:

• Added 'User and Host' information for long running query alert.

Monyog 3.61 (December 2009)

Bug fix:

• If notifications were enabled, program threads were not always closed properly what ultimately could lead to a program 'hang'. This bug was introduced in 3.6.

Monyog 3.6 (November 2009)

Features:

• Delayed alert notifications. It can now be defined that a problem must have existed for a number of sample intervals continuously ('in a row') for an alert to be sent. A global setting for each server is available from GUI. For individual counters the global setting can be overridden by defining the RetryOverride (like 'RetryOverride:3') property of the (javascript) counter definition in Tools... Customize interface.
• Added counters for monitoring I/O parameters on Linux systems (similar to 'iostat').
• Host and user information is added (optionally) to the Query Analyzer output. Note: This option is currently not available for proxy based sniffer.
• Duplicate/Clone Server functionality added to GUI.
• Added direct link to customize counters from the Monitors/Advisors page.
• Grouping of servers: one or more 'tags' can now be specified for a server. In 'register servers' page the list of servers are grouped as per tags. As more tags may be specified for a server, it may appear in more groups. A group established this way can be selected in one operation.
• Added an option to send alert if server was restarted between two data retrievals. With managed hosting the MySQL server may be restarted automatically as part of routine maintenance or after a server crash. Knowing when this has occurred can be useful.
• Process-list based sniffer now has an option to notify about and kill long running queries.
• New and updated counters/advisors.
• Added automatic and manual update check.

Bug fixes:

• Notifications did not take 'base time' setting and/or 'uptime_since_flush-status' status variable into account.
• If SSH setting for retrieving Linux system information were once selected and later deselected again, graphs without any information would appear in Dashboard and in MONyog.log errors were recorded.
• Now "busy" icon is displayed while saving/deleting a connection. When Monyog was controlled from a browser running on a remote machine the absence of this could cause confusion about if change had effect.
• A garbage string like "0NaN/0NaN/NaN 0NaN:0NaN:0NaN" could be displayed when editing log analyzer filter settings.
• With specific settings Dashboard graphs could hide other displayed dialogs.
• Notification mails now have information about the value that triggered the alert.
• In log analysis a divisor '1024' was use for calculation of 'kilo rows'. Now the divisor '1000' is used.
• Exporting charts as graphics did not use a consistent naming convention. Now files will be named 'MONyog_chart_ConnectionName_Chart_Title.file_extension'.
• For slave servers process-list options to "Kill", "Copy", "View Query" and "Explain" were not always accessible.
• GUI improvements, improved error messages etc.

Miscellaneous:

• Added a warning in Disk Info page that the calculation may be expensive. In particular with databases with thousands of objects the calculations may cause unacceptable load.
• Default data collection interval is 5 minutes.

Monyog 3.5 (October 2009)

Features:

• Alerts can now be sent as SNMP traps.
• Support for MySQL error log. An alert can be sent when the error log has an entry of type [ERROR] and the error log entry can be viewed in Monyog web interface as well.
• Query Analyzer data can now be exported as CSV.
• Updated and added advisors.
• EXPLAIN/View query from Processlist page will now open in a new browser tab.
• Alerts (mails or traps) will now list the IP of the machine running the Monyog instance (request from users who had more than one Monyog instance).
• Graphs/charts will now have new colors that make the graphs more readable.
• Added next/previous links in register/edit servers page.

Bug fixes:

• Lots of fixes for browser-specific issues.
• If identical queries were logged from more clients with same timestamp, Query Analyzer/slow query log would only count that query once.
• Long BULK INSERTS would not display properly in Query Analyzer if the option to 'replace literals' was selected.
• Deleting a server registered as number '0001' did not delete the sniffer.data file for that server.
• Windows Vista and higher could warn that Monyog was not properly installed due to lack of an Application Manifest. It was false alarm but now such Manifest is included with the installer.

Monyog 3.16 (September 2009)

Bug fixes:

• Some queries were not parsed correctly from server logs. Affected queries were queries enclosed in (brackets) and some queries with comments. Known issues still are: 1) queries starting with a conditional comment. 2) queries containing a 'quoted string' with a " ; " (semicolon) followed by a line-break.
• Query time could fail to be read correctly from logs.
• Fixed a memory issue when parsing logs.

Monyog 3.15 (August 2009)

Bug fixes:

• More CPU optimizations with processlist-based sniffer.
• When installing Windows version a js32.dll - error could stop installation (after waiting a few seconds and clicking 'retry' it installed successfully).
• Some counters of YES|NO type had an icon for displaying graph what made no sense.

Monyog 3.14 (August 2009)

Bug fixes:

• Significant CPU optimization with processlist-based sniffer.
• Saving mail settings with Linux version could cause a program 'hang'.

Monyog 3.13 (August 2009)

Bug fixes:

• Fixed a major memory leak issue in processlist based sniffer. Also some other small leaks were fixed.
• Using the option to 'show only changed values' in HISTORY/TRENDS would show an empty result for counters having non-integer values.
• On systems running Kaspersky security software 'test connection' could show an empty message box. Kapersky filtered. We have changed the text of the message so that it does not happen now.

Monyog 3.12 (July 2009)

Features:

• All charts displayed by Monyog can now be exported as PDF/JPG/PNG (from chart context menu).
• Query Analyzer will now sort in descending order as default first time (before it was ascending).

Bug fixes:

• Validation of connection details was not proper when saving.
• In Query Analyzer options that do not apply for sniffer and log files are now disabled where they do not apply.
• In Query Analyzer 'show details' did not preserve the original formatting of a query.
• Max column in sniffer output in Query Analyzer could show erroneous values in some cases.
• Mail alerts sent by Monyog displayed TRIAL at bottom even after registration of Monyog.
• Various errors like "ErrCode:-1 ErrMsg:PathMgr::GetExeName readlink failed" could occur in MONyog.log. In some cases the error would cause failure to register.
• Sniffer data are purged automatically as per the server 'retention timeframe' setting, but it could also happen that Sniffer data that were not old enough to qualify for purging were deleted automatically. This would result in some queries missing after analyzing.
• Wrong error was logged by sniffer if MONyog.lua version 3.0 was used with Monyog version 3.1. However in connection details section, on "Test Proxy", proper error was thrown.

Miscellaneous:

• Due to a bug in specific builds of the MySQL proxy version 0.72 (it returns incorrect version) Monyog Query Analyzer will not work with those builds affected. Affected builds include versions for Windows and OS-X (but not Linux where this Monyog release works fine with proxy 0.72). We hope that MySQL will fix this soon, but if not we will consider a patch in Monyog itself.
• With Internet Explorer versions 8.0.6001.18783 and higher (latest available for Vista and Win7) exporting graphics will not work. The 'Save' button (a FLASH object) does nothing in those browsers. We will release again as soon as a fix is possible.

Monyog 3.11 (June 2009)

Bug fixes:

• Fixed a bug when converting timestamp format (human readable timestamp, unix_timestamp) when reading server logs. The bug could result in time being displayed 1 hour wrong in Query Analyzer if server was in a timezone using 'daylight saving time'.
• A SQLite database LOCK could prevent access to the 'system' database. Linux Operating System counters would then not be available.
• Fixed a GUI issue with IE browser in licensing form page (command button behavior while a command was in process).
• Monyog could crash when user saved specific details (port and password) from 'preferences' .

Monyog 3.1 (June 2009)

Packaging:

• The same binary/installer is now used for any license model (whether TRIAL or whatever number of servers). A license key defines and controls how many servers can be registered. You may retrieve your license key from our Customer Portal. Before installation please ensure that you have registration details available and also soon after installation has completed please connect to Monyog from your browser and enter registration details. This change of packaging concept simplifies the release cycle for us, as there are now much fewer installers that will need to be built and tested.
• Also now all distributed builds will run as a TRIAL will run for a month (not till a fixed date) and in the TRIAL period an unlimited number of servers can be registered.
• Unfortunately and as a consequence of the changed packaging concept it is not possible to install a 3.1 RPM build on top of a previous version as the file name format (ie. version substring) will need to change to be functional by RPM installers ('rpm' console command and various distribution-specific commands and GUI tools). Previous RPM versions installed must be uninstalled this time before installing 3.1 (but note that previously collected data will still be preserved and available after this). For Windows .exe and Linux .tar.gz builds there is no such issue.

Features:

• Added option to purge all stored sniffer data. Also sniffer default settings were changed. Quite a lot of evaluating users experienced an empty report due to previous default settings.
• Added support for MySQL Proxy version 0.7.1. A new MONyog.lua script is shipped with this build. The old script must be replaced with this one if you use the proxy-based sniffer option. This new script also works with MySQL Proxy 0.61.
• Filtering options were re-arranged in Query Analyzer as per user requests.
• Lots of GUI fixes, clarifications, usability improvements etc.

Bug fixes:

• On RedHat type Linux 'service MONyogd start' command would sometimes not start Monyog in first attempt if Monyog process had been killed or had crashed.
• The mail header of Monyog mail alerts did not handle unicode. Now utf8 encoding is used everywhere.

Miscellaneous:

• Do not forget to replace the MONyog.lua script if you use the Query Analyzer with proxy-based sniffing!
• RPM users must uninstall previous versions before installing this one!

Monyog 3.09 (June 2009)

Bug fixes:

• If Monyog user for monitoring a replicating slave did not have 'replication client' privilege', MySQL availability would be shown as 'No' in Monitors/Advisors page (even though 'test connection' was successful).
• If mail alerts were enabled, a syntax error in customized javascript could cause a crash.
• Charts for a server in Dashboard page would not resume updating after a disconnect and reconnect to that server. A browser refresh was required.
• The chart 'popups' from Monitors/Advisors page would not populate with historical data from the Monyog database but only with fresh data sampled.
• After sorting in Query Analyzer the expand/collapse state was lost.

Monyog 3.08 (May 2009)

Bug fixes:

• Query Analyzer did not show correct output when displaying a sorted result. A wrong LIMIT clause was generated when querying the temporary database containing queries.
• Fixed a bug in checksum calculation on 64 bit builds. The checksum is used by Query Analyzer for indexing. On 64 bit wrong sort order could result from this.
• If SSH-tunneling to a MySQL server had been used and later the setting for 'Use SSH' was changed to "No", Monyog would continue to use SSH tunnel as long as valid tunneling details were available.

Monyog 3.07 (May 2009)

Bug fixes:

• With SMTP notifications turned "ON" various issues (connection failure, program crash) could occur if SMTP authentication was not used. This bug was introduced with SMTP authentication support in 3.05.
• Fixed a crash with SSH tunneling. Only 64 bit build for Linux was affected.
• Counters "cache hit rate", "pruned as percentage of inserts" and "queries not cached" reported wrong in 'History/trends' timeframe.

Monyog 3.06 (April 2009)

Bug fixes:

• Installation on Windows could fail with a js32.dll-related error. Waiting a few seconds and 'retry' would solve this but now the error does not come.
• Fixed a 'false alert' related to settings for temporary tables (the error occurred because of comparing an integer with a non-integer).
• With slow query logs generated from servers greater than 5.1 Query Analyzer "Max" column would show a value without decimal point if the query count was greater than 1.
• Chart pop ups from Monitors/Advisors page would sometimes only populate from next time data was sampled (it was a concurrency issue in code).
• 32 bit builds for Linux failed to populate the Monitors/Advisors page. This bug was introduced in 3.05.
• 3.05 TRIAL build for Windows would expire at a fixed date and not after one month as it should.

Monyog 3.05 (March 2009)

Features:

• SSL/TLS mail encryption is now supported for mail alerts.
• Added an option to rebuild Monyog databases. Using this option periodically may result in better performance - including shorter startup time when OS is rebooted. Basically using this option will defragment the database including indexes. It is not possible to provide an 'absolute' advice on how this option should be used. But the larger the databases and the shorter the sample interval the faster there is a chance of fragmentation occurring after a huge amount of INSERTs and DELETEs to the database (note that only with databases files of around 1 GB and larger we have seen the need for this. A 'general' advice could be to execute monthly with large database files).
• Improved error messages for Query Analyzer.

Bug fixes:

• When "Test Connection" or "Test Path" was clicked Monyog seemed inactive. Now the mouse cursor will change to an 'active state cursor' indicating that Monyog is performing the requested operation.
• With query sniffer enabled the 64 bit Linux build could crash. Reports about this include RedHat and Ubuntu Linux distributions with very recent Linux Kernels.

Monyog 3.04 (March 2009)

Features:

• In case of invalid javascript in a counter definition, Monyog will now tell details about this error.
• Optimizations in the handling of the Monyog embedded database. In particular users with a very large retention timeframe setting and rather short sample interval (resulting in large databases) will benefit from that.

Bug fix:

• The above will also fix an issue where Monyog seemed to 'hang' when saving connection details for a connection having large database files.

Monyog 3.02 (February 2009)

Bug fixes:

• The alerts and advisors for slave 'read-only' mode were in conflict. We will now advise for a slave (in production) that 'read-only' mode should be ON (only the replication thread can write) and alert accordingly.
• Add/Edit connection failed with connection names using SPACE character.
• Proxy connection was not established when proxy was started for a server present in a remote system.

Monyog 3.01 (February 2009)

Bug fix:

• For 5.1.x server Monyog was not fetching the log details like slow query log and general query log file path in Connection details section.

Monyog 3.0 (February 2009)

Features:

• The 'query sniffer' can now connect to and retrieve data from a running instance of the MySQL-proxy program used by one or more clients to connect to MySQL. A LUA script for controlling the proxy for use with is provided with this build. With this sniffer option the SHOW FULL PROCESSLIST statement will not be sent and thus use of 'query sniffer' will not put any load on MySQL.
• SSH connections will now attempt more authentication methods in case the first method attempted failed. This will solve problems reported with tunnneling to MySQL on FreeBSD that as per default does not support the full range of SSH authentication methods (and possible similar problems).
• Updated advisors. This is a complete and major revamp of advisors in . It is still in progress (around 80% is finished).
• Log Analyzer will expose call statements.
• In Log Analyzer ''Rows Sent' and 'Rows Examined' column will be displayed as KBs/MBs.
• Connection Details (Connection name, MySQL user, SSH user, SSH tunneling user which are saved in connection details are exposed for customization in Monitors/Advisors. (For instance 'connection name' can be accessed using MONyog.Connections.ConnectionName, 'MySQL user' as MONyog.connections.MySQLUser etc. Please refer documentation for more detailed list of all counters exposed.). Using this option counters can be made specific for specific Monyog connection details. For instance you can have two connections defined to the same server that will display each their set of counters.
• Monyog now has an ability to fully utilize the caching abilities of modern browsers. Now when refreshing a page where there is no change there will be almost no network traffic generated and the page will refresh almost instantaneously.
• Monyog is able to read microseconds from proxy and if available in slow query log and will (for readability) show in milliseconds.
• Sniffer output will now display MAX, first seen time, last seen time, query occurrence %. Also query occurrence % and Lock Time for a query was added to slow query log and query occurrence % for a query was added to general query log displays.
• Added an option to execute FLUSH STATUS from inside Monyog.

Bug fix:

• Once a connection in connection page was defined ssh = 'yes' for a Linux server and changed on 'no' then the GUI would not update with proper information.

Miscellaneous:

• Grouping of queries is now case insensitive for all forms of query analysis.
• The browser cache support added in beta2 has been temporary removed. There is a problem with Firefox3 with cache and AJAX (update requests were not sent from a cached page - only current cache content was reloaded). Note that FF3 users who had beta2 installed will need to clear the browser cache after installing this beta3.
• Note that the qd.lua script for PROXY-based sniffer has been updated and renamed to 'MONyog.lua'. For use with this Monyog version the old script must be replaced.
• Also note that Log Analyzer has been renamed to 'Query Analyzer'.

Monyog 2.9 (December 2008)

Features:

• This release adds a 'base time' setting in Monyog. This setting (if defined by user) will be used for calculation of uptime-based counters. The reason for this implementation is that if FLUSH STATUS is executed with a MySQL server, specific server status variables will be reset to the same value as would be after a server restart. However the 'uptime' status variable itself is not affected by FLUSH STATUS. And as uptime-based counters will relate the value of cumulative status variables with some initial time, using the 'uptime' variable as the initial time will result in calculation of misleading values if FLUSH STATUS was executed. So to get true uptime-based counters in Monyog with servers that do not support the 'uptime_since_flush_status' variable (and currently only 5.0 COMMUNITY servers from 5.0.37 do - not ENTERPRISE servers and not any other major branch than 5.0 and also not 5.0 before 5.0.37) you will need to define a 'base time' in Monyog greater than or equal to the time where FLUSH STATUS was executed last time. Also you can now discard data older than a specific time by using this setting. Refer to documentation for full details.
• Improved the purging logic with the Monyog embedded database. Now also system CPU load is considered and purging operations will be skipped if CPU is high. This is a further improvement to the change in purging logic introduced in version 2.5.
• Monyog can now be running behind an Apache server configured as 'reverse proxy'. Before this release Monyog java script was not accessed due to absolute paths, as a result Monyog pages were not displaying properly.

Bug fix:

• Fixed high CPU usage in the 'query sniffer' if sniffer "Minimum time taken" value was set to "0" (or left blank).

Monyog 2.83 (November 2008)

Bug fixes:

• SFTP log downloads used excessive memory on Linux.
• Version 2.82 introduced an unresolved dependency with a libcrypt library on some Linux distros (including some CentOS and OpenSuSE distros).
• Installation on Windows 2000 could fail due to a dependency on a .dll not standard on this Windows version. Also this was introduced in 2.82.
• The status indicator for log downloads could display wrong for large files (> 2 GB).

Monyog 2.82 (October 2008)

Bug fix:

• SFTP log downloads failed with the Bitvise 'WinSSHD' SSH implementation for Windows.

Monyog 2.81 (October 2008)

Bug fix:

• Fixed an issue where data collection would continue to fail with 'database locked' error message in the log. We now roll back the query generating the lock and collection can continue (this was reported happening by a single user (only) after Monyog upgrade).

Monyog 2.8 (September 2008)

Features:

• Added new monitoring module displaying disk usage information for databases and tables.
• Display of slow log data in Log Analyzer had added more information (about when query occurred, information about number of rows examined and sent).

Bug fixes:

• When a multibyte character was used in a connection name the display would garble and also the connection could not be deleted from GUI.
• When connection was not available the caption for counters should display "n/a". Since 2.71 it would instead display a string exposing an internal value (example: "NumCounterWithSeconds").

Monyog 2.72 (September 2008)

Bug fixes:

• On 64 bit Linux systems running Monyog 64 bit builds queries could be considered identical by Log Analyzer even if they were not.
• Authentication failed if the "#" character was used in password.

Monyog 2.71 (September 2008)

Bug fix:

• Fixed some issues with JSON strings that could prevent objects in the Monyog browser interface to populate with data. Most important 'Monitors/Advisors' page would fail to display if a username contained a doublequote character.

Monyog 2.7 (September 2008)

Features:

• CPU optimizations in both Monyog (server) process (in particular when 'Monitors/Advisors' page was being viewed) and browser processes (viewing Dashboard could cause high CPU usage in Firefox browser in particular).

Bug fix:

• Fixed a dependency with the SSH library that could cause failure to install in Win2K. This was an issue with the updated SSH library introduced with version 2.5.

Miscellaneous:

• The RPM installer scripts for Linux was updated in various ways. This solves issues on specific distributions including: 1) Uninstall with the SuSE/YaST 'software management' GUI was not possible. 2) It was not always possible to install on top of a running Monyog service - sometimes it was necessary to stop service manually before upgrading. Also note: when updating from trial to single/multi server or from single server to multi server it is still necessary to uninstall the old version first. And when installing this version any older version will have to be removed with the "rpm -e ..." command in advance (distribution-specific GUI tools may not work with versions before this one, so please use the RPM console command). We apologize for this but there is no other way.

Monyog 2.6 (August 2008)

Features:

• Log Analyzer code has been completely refactored resulting in better performance and stability and more maintainable code.
• The progress indicator for downloads in Log Analyzer page is now a true quantitative progress bar.
• Error messages in Log Analyzer were rewritten. Every single possible error is now differentiated by a specific message providing help for the situation.

Bug fixes:

• With SFTP connection to the log file selecting "ALL" for log size to be downloaded in Log Analyzer page could have the result that the log file download would last forever.
• Analyzing log chunks containing BULK INSERT statements could in special situations cause a program crash.
• "Group by" option in history/trends page could deliver incorrect results if MySQL and Monyog were using different timezones.
• Fixed a bug with resolvement of time in log analyzer that could result that no queries or less queries than what should be were returned. The most recent queries would sometimes not be shown. Issue was only if log was retrieved with SFTP.
• When retrieving logs stored in tables the substitution of literals would fail for binary data .
• Installing a RPM multi/single server builds on top of a trial build (and vice versa) resulted in that they were installed in parallel. Also on SUSE Monyog was not registered with the correct run level. The RPM has been updated to fix this.
• When downloading a log Monyog would continue to download in the background until end of file even after STOP button was clicked.
• In the display of queries from the Processlist page special characters could garble.
• Also in Log Analyzer page special characters would not always be identified correctly. This bug also affected records with binary data. Both display and grouping was affected (depending on where those occurred - in plain strings or in identifiers).
• Repeatedly switching between sorting and show details for a slow query log in Log Analyzer could in certain situations crash Monyog.

Miscellaneous:

• Display of servers is now sorted in the order of the server/connection name. Earlier the internal ID was used for sorting. Also note that now no Monyog restart is required for changing sort order. A connection rename alone will do.

Monyog 2.51 (July 2008)

Bug fix:

• Depending on the chosen installation environment and the Linux distro, the RPM build might not install 'on top' of a previous installation. Before installing a new version it was necessary to uninstall the previous version. This is a limitation with all RPM builds released till now. From this build and onwards it will always be possible to 'upgrade on top' of a previous version. Note: this was an issue with the RPM installer - not the program binary. There is no change in the binary as such and also no change in the Windows installer and the .gz build for Linux.

Monyog 2.5 (July 2008)

Features:

• MySQL Server Log Analysis: Monyog is now able to retrieve (completely or partially) the General Query Log and the Slow Query Log (whether stored as files or tables on the server) from the MySQL servers it connects to and analyze them.
• Query Sniffer: A 'query sniffer' is implemented that will record a 'pseudo log' on the client (Monyog) side. The sniffer is useful when 'real logs' are not available, but also the sniffer has various filtering options what will sometimes make it more useful than the 'real server logs' also when they are available.

The log analysis component will (whether operating on a 'real log' or a 'sniffer pseudo log') only display identical queries once but print a 'count' for every query. Important information (like execution time, number of instances for this query etc.) will be displayed in a sortable table view.

In the log analyzer 'Filter settings' (not to be confused the filter settings of the 'query sniffer') there further is an option to 'replace literals'. The purpose of this option is to eliminate small differences between 'almost identical' queries. Currently 'quoted strings' and numbers are replaced with the dummy string 'XXX' only. We may extend this feature to support more (like special keywords and functions (like NULL, now()), operators etc.) in the next releases. It will depend on the demand for this as compared to the demand for other features. Also note that the current implementation has the 'imperfection' that also numbers that are not values (like the '1' in identifiers like column1) will be replaced.

• More Linux system counters added: Counters related to Linux memory (including swap) usage added.
• RPM build now supports SuSE and Mandrake/Mandriva Linux distributions.

Bug fixes:

• Under specific circumstances the Monyog service would stop very slow.
• If network connection was temporarily unavailable the first CPU value after network came back told 100% CPU load.
• The temporary files for storing public/private keys are now being created with very restrictive file permission in Linux. So only the owner will be able to read/write these temporary files. Although these files would exist only for a fraction of second, in earlier versions of Monyog other users in the same Linux system could get access to them within that small timeslice.
• Fixed an issue with trending where graphs would not always display properly for uptime-based counters.
• MONyog.ini file and Monyog database files on Linux are now only readable for user who starts/installs (.gz and RPM build respectively) Monyog (and of course for any user too that was given access by a root user). Before the files were world-readable. This applies to fresh installations only - there is no change with existing installations.
• Solved an issue where slow startup could occur if lots of servers were registered (Technical: If Monyog had not been running for a while, large amounts of data could require deletion from the Monyog database. The queries used to identify those data would generate significant I/O at startup. The retention process is now 'smoothed over time' and indexes have been added for more efficient deletions).

Monyog 2.06 (June 2008)

Bug fix:

• Fixed: The new version 3 release of Mozilla Firefox (now in RC) has a flickering issue with Monyog and the login page did not load correctly in that browser version.

Monyog 2.05 (May 2008)

Bug fix:

• Fixed: OS monitoring issue in Fedora Core 6 Zod.

Monyog 2.04 (May 2008)

Performance improvement:

• Earlier Monyog was semaphore intensive. That could result in reaching the 'limit of semaphores that can be created by the kernel' in some systems. Monyog 2.04 will use less semaphores. Another symptom was that a large number of small and zero-size files could be left behind (in system TEMP folder on Windows and in MONyog/bin folder on Linux). This is also solved with this.

Monyog 2.03 (May 2008)

Bug fix:

• In some situations where SSH connections failed (including if Monyog was not able to connect to MySQL through tunnel, wrong SSH authentication details for tunneling etc.), sockets were not being closed and it could result in that many sockets were kept in CLOSE_WAIT state. (Note: Connections to MySQL not using SSH were not affected!)

Monyog 2.02 (April 2008)

Bug fix:

• In the 'delta' timeframe CPU load displayed was incorrrect.

Monyog 2.01 (April 2008)

Bug fix:

• Whenever Dashboard was drawn for the first time or redrawn with new configuration settings all nodes displaying CPU load were erroneously drawn with the latest available value. New values appearing after that were drawn correctly. Only CPU load counter was affected.

Monyog 2.0 (March 2008)

Features:

• SSH tunneling to MySQL servers.
• Analysis of historical data (trends).
• Dashboard graph size is now configurable.
• You can choose to display x-axis values or not in Dashboard (in 'large' display mode). Also remember that no matter if axis-values are displaying you can retrieve values by pointing the mouse to a node in the charts.
• The no. of samples displayed in dashboard is configurable.
• Above dashboard settings can be changed from the dashboard page itself.
• 64 bit binaries for Linux included.
• Option to display counters as 'value/sec'.
• Reorganized the connection page for better clarity.
• Performance improvements.
• JavaScript code was 'broken down' to smaller units for easier customization. Every counter group now has its own 'custom' script.
• The menu was reorganized and other GUI improvements for easier navigation between the different functionalities.
• The 'looks and feel' (of graphics in particular) has been vastly improved.
• Documentation/help was updated and reorganized with better structure, more hyperlinks - and also now much more better looking.

Bug fixes:

• Monyog would not install on some older Linux distro's (including RHEL3).
• In Linux it was possible to start more identically named Monyog instances. This is now prevented.
• When stopping Monyog service it could happen that the service was reported to be stopped before the task was complete. Starting service in this situation would return an error. Now it will report 'running' as long as it is not fully stopped.
• Fixed an issue with the shell script for non-RPM Linux where it could be reported that service had started when it had not.
• Fixed some calculation bugs (affected 'hit rate' and 'percentage of used blocks' counters).

Miscellaneous:

• Help/documentation page will open in a separate browser window or tab (depending on browser setting).
• 'Show All' page was renamed to 'Monitors/Advisors'.
• System counters have been renamed to 'Linux counters'.

More details on implementation of SSH-tunneling and History/Trends analysis:

• SSH-tunneling: The implementation does (unlike current SQLyog implementation) not start any external process and does not occupy a local port. The performance for this 'home grown' SSH-tunnel wrapper is very high (you may find it faster than direct connection to MySQL on a remote host)!
• History/Trends analysis: This is implemented in the 'Monitors/Advisors' page. You can select whatever time interval you want for the analysis. Counters that are UPTIME based (or if you like: CUMULATIVE counters as opposed to SNAPSHOT counters) can be aggregated using SUM function and common time intervals (HOUR, DAY, MONTH etc.). This is semantically similar to the query "SELECT SUM () ... GROUP BY " (but the real query behind this interface is much more complex of course!).

Monyog 1.52 (February 2008)

Bug fixes:

• Installing recent versions on top of 1.1 or earlier could disable connection to the OS (not to MySQL) of servers already registered (this bug was introduced when we started supporting key authentication with 1.5).
• Alert icons (red and yellow circles) were disappearing from the group in 'Show All' interface if the user clicked the next group.

Monyog 1.51 (January 2008)

Bug fixes:

• Adding a server with notification enabled was storing wrong information in the 'connection.data' configuration file. After a restart of the Monyog service the wrong information that was read from that file would cause notifications to stop working. Note that if a connection was configured in 'two steps' where notification settings were added to an existing connection there was no error.
• Fixed a memory leak occurring with public/private key authentication when connection was unsuccessful (server not available, invalid key pair etc.).
• The shortcuts installed by Monyog installers now point directly to '127.0.0.1' (and not 'localhost'). This solves an issue with firefox on Windows Vista where resolution of the URL 'localhost' was very slow.

Monyog 1.51 (January 2008)

Bug fixes:

• Adding a server with notification enabled was storing wrong information in the 'connection.data' configuration file. After a restart of the Monyog service the wrong information that was read from that file would cause notifications to stop working. Note that if a connection was configured in 'two steps' where notification settings were added to an existing connection there was no error.
• Fixed a memory leak occurring with public/private key authentication when connection was unsuccessful (server not available, invalid key pair etc.).
• The shortcuts installed by Monyog installers now point directly to '127.0.0.1' (and not 'localhost'). This solves an issue with firefox on Windows Vista where resolution of the URL 'localhost' was very slow.

Monyog 1.5 (December 2007)

Features:

• Major speed improvements (in both data collection and as regards browser responsiveness).
• Private/Public key authentication is now supported with SSH connection to remote hosts. Key format must be OpenSSH standard key format - special formats (like the one used by the 'Putty' program) are not supported.
• Added security-related counters and advisors.
• Added counters and advisors for schema and table operations.
• PROCESSLIST display will not by default 'filter out'. A button has been added in the 'Change Filter' dialog to switch between a non-filtered result and the (old) filtered result for the PROCESSLIST page.
• PROCESSLIST can be paused/resumed.
• Default SSH timeout (3 minutes) was replaced with 30 seconds.

Bug fixes:

• Fixed some small memory leaks.
• Deleting a connection did not remove all the files belonging to that connection.
• Fixed a rare issue where browser could report that the page cannot be displayed while saving/editing server details or connection (IE issue only).
• Fixed an issue with system counters where 100% CPU usage erroneously could be reported when Monyog started.

Monyog 1.11 (October 2007)

Bug fix:

• HTML formatting of queries in the PROCESSLIST tab was not correct. As a result display of queries could be truncated.

Monyog 1.1 (October 2007)

Features:

• Support for SHOW FULL PROCESSLIST - Monyog monitor processes on the servers in real time. Various filtering options for PROCESSLIST are available. Further displays, copy and EXPLAIN (EXTENDED) a running query from inside Monyog.
• Documentation was updated - including information about the PROCESSLIST feature, up-to-date screenshots etc.
• Counters and Advisors - Small adjustments!
• Debug DUMP facility - Monyog (Windows version) has an ability to store crash-dumps fit for debugging similar to SQLyog as explained here: Debug facility
• Menu rearrangement etc. - or clarity we have decreased the number of menus displaying. Those that 'went away' are available as links or submenus.

Monyog 1.04 (August 2007)

Features:

• Improved counters and advisors.
• Customize page now will show the .js-components that user changed with a red * (star). Note that existing .js-components will be overwritten when you upgrade. The red star will help you to see what you need to back up before upgrading.
• Default port is now 5555. With certain names used for the connections there was a conflict with a standard 'rule' of Norton Internet Security when port 9999 was used.
• The option to display graphs from the 'monitors/advisors... custom timeframe' interface was temporarily removed.

Bug fixes:

• Fixed a crashing bug in mailing section if a .js-component was corrupted.
• Adding the option to send mail after registering a server required Monyog service to be restarted.

Monyog 1.03 (August 2007)

Features:

• A BELL icon displays in the 'Monitors/Advisors' page for alertable counters.
• Various small GUI improvements.
• Documentation updated with details about system Objects + various small corrections.

Bug fixes:

• %age of queries doing full table scan metric was incorrect.
• With very small mail interval setting it could occur that selected servers became deselected.
• Fixed a bug in the calculation of full table scans.

Monyog 1.02 (August 2007)

Bug fix:

• Fixes an issue in previous 1.x releases that may result in too early expiry of the TRIAL.

Monyog 1.01 (August 2007)

Bug fix:

• Replication counters did not display in LINUX builds (both .rpm and .tar.gz).

Additional note on file storage positions and upgrading:

Version 1.0 RC changed the storage position for various files used by Monyog. This release is in this respect identical to 1.0 RC and 1.0.

By default the embedded database is now stored:

• Windows 2K/XP/2003: {System_drive}:\Documents and Settings\All Users\ApplicationData\Webyog\MONyog\Data
• Windows Vista:{System_drive}:\ProgramData\Webyog\MONyog\Data

... but user can specify another location if for instance she does not want to store on the system disk/partition at all.

Also the monyog.ini file and the log file is now no longer stored in 'program files' file tree (or whatever localized name it has). The storage position is:

• Windows 2K/XP/2003: {System_drive}:\Documents and Settings\All Users\ApplicationData\Webyog\MONyog
• Windows Vista:{System_drive}:\ProgramData\Webyog\MONyog

Users upgrading from 0.9 who want to use existing data must after installing this version:

1. Stop Monyog service.
2. Copy the folders containing databases named with a number like "0001" or "0002".
3. Start Monyog service.

No such intervention is required when upgrading from version 1.0 RC or 1.0 (unless storage position is changed again, of course!).

Upgrading from versions before 0.9 is not possible. These versions must be uninstalled and installation folder deleted or this version must be installed to another folder.

Monyog 1.0 (August 2007)

Features:

• Installs and runs on Windows 2000.
• Every counter is available in every timeframe.
• User can specify where the embedded database is stored.

Bug fixes:

• Retrieval of memory information from Linux servers was broken in 1.0 RC.
• Windows version: Solved an issue with a dependency on a .dll file that was reported missing on some systems.

Additional note on file storage positions:

Version 1.0 RC changed the storage position for various files used by Monyog. This release is in this respect identical to 1.0 RC.

By default the embedded database is now stored:

• Windows 2K/XP/2003: {System_drive}:\Documents and Settings\All Users\ApplicationData\Webyog\MONyog\Data
• Windows Vista:{System_drive}:\ProgramData\Webyog\MONyog\Data

... but user can specify another location if for instance she does not want to store on the system disk/partition at all.

Also the monyog.ini file and the log file is now no longer stored in 'program files' file tree (or whatever localized name it has). The storage position is:

• Windows 2K/XP/2003: {System_drive}:\Documents and Settings\All Users\ApplicationData\Webyog\MONyog
• Windows Vista:{System_drive}:\ProgramData\Webyog\MONyog

Users upgrading from 0.9 who want to use existing data must after installing this version.

1. Stop Monyog service.
2. Copy the folders containing databases named with a number like "0001" or "0002".
3. Start Monyog service.

No such intervention is required when upgrading from version 1.0 RC (unless storage position is changed again, of course!).

Upgrading from versions before 0.9 is not possible. These versions must be uninstalled and installation folder deleted or this version must be installed to another folder.

Monyog 0.9 Beta1 (July 2007)

Note that this release is a TRIAL build. It has the restrictions that,

1. Maximum 2 servers can be registered.
2. It will expire on August 15th 2007.

Before expiry of this beta we plan to release version 1.0 FINAL and publish purchasing and licensing terms.

Also notice that the schema of the embedded database has changed compared to previous versions. With this beta we will not provide a database upgrade script. If you have a previous version installed you must either,

• install to another folder.
• or uninstall the old version.

Features:

• Authentication is in place. Monyog pages can be watched from another machine where Monyog service is running. Monyog pages can be watched from another machine where Monyog service is running.
• Two-level alerts (WARNING/CRITICAL).
• Mail alerts.
• Various timeframes available for display of data in 'Monitors/Advisors'.
• Replication counters.
• Documentation (1st version) included.
• And lots of minor improvements.

Known issues:

• Installation on Windows 2000 is (still) not possible (due to a dependency in the SSH library that we use). We hope to fix this soon.
• We are aware of some (rare) problems that can occur on Windows Vista including:
  1. Graphs will not populate with old (stored) data.
  2. Pages will not update properly.

Monyog 0.20 (May 2007)

Bug fixes:

• Fixed a crashing issue while installing the Monyog over existing Monyog installation.
• Introduced locks to make thread safe.
• Fixed a leak of GDI's (Graphics Device Interfaces). Number of open GDI's would increase and when Monyog was running for very long time, Monyog service could ultimately crash.
• Fixed few JavaScript issues.

Monyog 0.16 (March 2007)

Bug fixes:

• AJAX is now fully implemented in the Monyog main screen.
• Improved advisors - in particular regarding the Query Cache.
• Fixed all reported (and some non-reported) GUI issues.
• Lots of code changes for better structure, performance and maintainability.