MONyog

What's new in MONyog 5.5.6

• 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.5.5 for indented display of a slave compared to its master was not complete. Proper indentation could still fail

What's new in MONyog 5.5.3

• 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.

What's new in MONyog 5.5.1

• 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.

What's new in MONyog 5.5

Features:

• Added '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
• 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 particularly relevant if you receive mails on a mobile phone or other small handheld device
• Added ’Monitor level’ email-address alert setting

What's new in MONyog 5.3

Features:

• Support for 'native' MySQL SSL-encryption with direct MySQL connections
• Fully supports IPv6 (Internet Protocol Version 6)
• History-trends have been optimized to retrieve data faster than it was before
• Passwords for MONyog users are stored as a hash and obfuscated
• Added a Linux counter "Load Average" as  exposed by the Linux kernel in /proc/loadavg

What's new inMONyog 5.21

• Enhanced API with more options: Calls to enable/disable data collection, sniffer, notifications etc. for servers by either specifying a server name or a server tag

What's new in MONyog 5.2

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
• Added a preconfigured Custom SQL Object (CSO) for Percona Servers exposing the most written and most read tables
• 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

What's new in MONyog 5.11

Features:

• Introduced tag level customization in MONyog Monitors
• Native Javascript properties (like length, indexOf, splice etc) are now fully supported in Monitors and Dashboard
• 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 the same as that of MySQL host

What's new in MONyog 5.1

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
• Comparison of MySQL server configuration of multiple servers side by side is now faster in the 'Server Config' page

What's new in MONyog 5.0

UI Enhancements:

• Introduced a left panel that contains the list of servers registered in MONyog
• 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
• Query Analyzer will now display query text up to 5000 characters. (before it was 2000)

What is MONyog - MySQL Monitor and Advisor?
MONyog MySQL Monitor and Advisor is a "MySQL DBA in a box'' that helps MySQL DBAs manage more MySQL servers, tune their current MySQL servers and find and fix problems with their MySQL database applications before they can become serious problems or costly outages.

MONyog pro-actively monitors enterprise database environments and provides expert advice on how even those new to MySQL can tighten security, optimize performance and reduce downtime of their MySQL powered systems.

Get information before the server runs out of resources.
As a MONyog user you will know in advance if server resources will soon be running short. You can plan a hardware replacement or upgrade well in advance of time and not when it is almost too late or just too late. The metrics about the server that MONyog gives you will also help you to decide what to upgrade: Faster CPU, More RAM, Faster disc systems - or maybe only remove another program from the computer where the MySQL server is running.

Identify the SQL statements that run slow.
MONyog provides a log analysis module, a 'query sniffer' and a 'processlist watcher' that makes it easy to identify the statements and applications that run slowly on the server. This includes various filtering and EXPLAIN options for an efficient workflow when you want to optimize your applications.

Monitor the MySQL Error log.
Monitoring the MySQL error log is absolutely critical for any MySQL DBA. MONyog is one of the first MySQL Monitoring Tools to monitor the MySQL Error logs and optionally notify you of changes to it.

Monitor queries in real-time and snipe long running queries.
MONyog provides a set of tools for finding problem SQL (Slow Query Log, SHOW PROCESSLIST snapshots, MySQL Proxy, etc). These tools are great if you want to find problem SQL in an application and tune those queries. However, using these tools to find problems is almost always a post-mortem exercise. In certain situations you may want real-time notifications for long running queries; MONyog gives you exactly that. MONyog can continuosly monitor queries in real-time and send notifications for queries that take more than a specified amount of time to execute. You can also specify an option to kill such queries.

Get alerts for what you want and when you want.
MONyog can send you alerts over mail or SNMP. Some features of the alerting system are:

• It uses the concept of "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 the GUI. For individual counters the global setting can be overridden by defining the RetryOverride (like 'RetryOverride:3') property of the (JavaScript) counter definition.
• You can also choose to be notified when MONyog detects that a problem, which existed previously, has been resolved.

Compare between the editions of MONyog MySQL Monitor and Advisor
The following table shows the features included in the different editions of MONyog.

1 Year Premium Support (Optional)

• All issues addressed directly by developers
• Unlimited ticket based priority support
• Response within 1 business day
• Issue escalation to product development team
• Hotfixes / emergency patches in the event of bugs
• Remote troubleshooting