Monyog MySQL Monitor 6.0 beta 1 Has Been Released

by May 9, 2014

Changes (as compared Monyog MySQL Monitor  to 5.72) include:

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

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. Actually we never promised support for Named Pipes.  But we should not crash, of course, and it works with Named Pipes now.
* 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.

* Documentaion for the new features is in progress, but not completed with this beta release.

An additional comment on using the Query Analyzer with P_S:
* Note that Performance_Schema truncates queries after 1024 characters and always replaces literals with a wildcard (in other words: P_S contains a summary/an aggregation only). So query listing not replacing literals is not possible with this option. And finally also observe that no other tool (or user) should be writing (including deleting or truncating) to events_statements_summary_by_digest and events_statements_history_long tables if this option is used as there is only one of each table for all users (it is not a temporary table or a materialized view or similar private for the user). This is a design limitation with the tables in P_S as such and not a Monyog issue. Monyog itself may (optionally) truncate the P_S tables when they reach 80% of their capacity (and thus Monyog could have impact on other tools or users using the same tables). This truncation is disabled as default, but you may need to enable it if the capacity of the tables is set too low to record all queries occuring.