This build only has bug fixes of small bugs affecting new features and interfaces added in 10.0 (all reported internally), internal optimizations and code cleanup as compared to beta 1. There are no new features or changed functionalities.
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php
Circus Oraclimus is back in town. It was last time only four weeks ago and a few months before that as well, and while it the first few times was quite funny to watch the clowns, it does not remain funny to see the same absurd tricks over and over again.
I am referring to this: http://bugs.mysql.com/bug.php?id=56889.
If you have both MySQL 5.5 and 5.6 installed on the same Windows system using the .msi installer you cannot upgrade 5.5. The 5.5 installer refuses to run claiming that a ‘newer version’ [of 5.5.x] is installed. It never was – and still is not – a problem upgrading 5.1. with 5.5 (and 5.6) installed. So this is a bug and it is verified. And it was actually fixed by Vladislav Vaintrub before he left Oracle for Monty Program 1½ years ago. For some reason the fix failed to be committed and never was included with the installers distributed. I did several attempts to wake up the people at Oracle asking them to find that patch and commit it to where it should be. It never did lead anywhere. Not even to a reply.
Needless to say the MariaDB .msi installers for Windows do not suffer from this. You can upgrade any MariaDb version with a higher version installed. But .msi installers for MariaDB are also maintained by Vladislav Vaintrub!
So what you need to do is before upgrading your Oracle/MySQL 5.5 instance if you also have 5.6 installed is to uninstall 5.6, upgrade 5.5 and install 5.6 again (I am not running the configuration wizard as I want to keep the 5.5 and 5.6 configurations I have). A little annoying, but no data or configuration is lost and after all it takes only 10 minutes. So not a big deal. Untill the situation worsended significantly recently (after 5.5.20).
We continue here: http://bugs.mysql.com/bug.php?id=64909
The above uninstall-upgrade-install procedure stopped working for me when upgrading to 5.5.22 and .23. Both my 5.5 and 5.6 instances become non-functional. On 5,5 the `mysql` database lost some tables and on 5.6 the service was removed from the system.
It is 4 weeks ago I upgraded to 5.5.23 (that is what I refer to as last visit from Circus Oraclimus) and now I see 5.5.24 is available on mirrors. Welcome back, Circus Oraclimus! I hope you bring some artists this time and not just the clowns!
( I know perfectly well that that I can install the service very simple for instance with the “mysqld install servicename” -command and don’t need to use the installers. However like most Windows users I like a unified and consolidated view of what is installed on the system – in case in “Control Panel .. Programs” – just like most users of ‘Red Hat type’ Linux prefer to install using the RPM for exactly the same reason)
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.
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php
Changes (as compared to 9.63) include:
Features:
* The DATA tab is now moved to the upper pane. This completes the GUI redesign we started with version 9.5 (but we will continue after 10.0 release to provide optionality for this). A DATA tab will now open from table menu/context menu, keyboard shortcut F11 or from the “+” icon to the right of open query etc. tabs. Also if not the option to ‘paste object name to editor on double-click ‘ is selected in ‘preferences’ it will open on double-click on the table in Object Browser.
* Added an option to open a DATA tab in ‘sticky’/persistent mode. A DATA tab opened like this will remain open until closed manually by user. If a DATA tab is opened in ‘non-sticky’/non-persistent mode it will be replaced when opening another table in ‘non-sticky’/non-persistent mode.
* Redesigned the menu bar in DATA and RESULT tab including new icons.
* SQLyog now opens as default with a blue-colored interface. The old non-colored interface can be selected from preferences .. ‘others’ tab .. ‘theme’ (the 10.0 blue default theme is named ‘twilight’). Currently ‘themes’ apply to the main program dialog only and not popup dialogs. It is actually possible for user to modify a ‘theme’ or to create his own ‘theme’. Information about this will appear after GA release.
* Several improvements to Schema Sync performance: 1) before an ALTER TABLE statement would be generated for every schema change. Now in most cases they are aggregated to a single ALTER TABLE statement. 2) Optimized queries and internal processing.
* The current row in DATA and RESULT grid can now be selected using Ctrl+SPACE .
* Added multi-column filter and sort option in Table data tab.
* Added a control for select all/deselect all rows in DATA and RESULT grid.
* Ctrl+Alt+V will now rotate between GRID, TEXT and FORM display modes for DATA and RESULT tab .
* SQLyog installers are now digitally signed. When downloading with IE9 a false warning appeared due to lack of certificate and also UAC (‘User Account Control’ of Vista+ Windows) would warn that the program was from an ‘unknown publisher’.
* When upgrading, the installer will now remember what shortcuts were created previously.
Bug fixes:
* Quite a lot of GUI fixes.
Miscellaneous :
* The shortcut to ‘execute all queries’ has been changed from SHIFT+F9 to CTRL+F9 . This is changed because SHIFT+F9 on some keyboards (including most English keyboards) could easily be mistyped if user wanted to type a bracket ( “(” or “)”).
Finally please note that documentation is in progress but not completed with this beta.
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php
IMPORTANT note:
* This release requires a new registration code if you are upgrading from a version before 5.1. 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.
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..
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php
IMPORTANT note:
* This release requires a new registration code if you are upgrading from a version before 5.1. 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.
Additional note added on April 6th 2012: We have replaced the binary downloads on our server. The previous Windows binary identified itself as version 5.1 even if it is was 5.11. If you have already installed 5.11 you can ignore any upgrade notification as long as 5.11 is the latest GA version and if you don’t bother about the wrong version identification. As there are no other changes we did not find it justified to do a formal release of a new version.
Changes (as compared to 5.1) include:
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 extract 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).
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php
Changes (as compared to 9.62) include:
Features:
* Added an option to specify the font used in the Object Browser.
* Schema Sync now has an option to add SET FOREIGN_KEY_CHECKS = 0 to the script generated.
* Added an option to specify INIT_COMMAND(s) for a connection. INIT_COMMAND(s) are executed when SQLyog connects and reconnects. The primary purpose is to override settings specified with ‘init_connect’ setting in server configuration for the SQLyog session. For instance if ‘init_connect’ server setting specifies “SET AUTOCOMMIT = 0″ you may enter “SET AUTOCOMMIT = 1″ in the SQLyog connection manager if you want a non-transactional behavior for the SQLyog session.
Bug fixes:
* If both a column default and a column comment was specified in CREATE/ALTER TABLE a SPACE-character was missing in the generated statement causing invalid syntax error. This bug was introduced in 9.5.
* Fixed a crash (reported internally) in the ‘Indexes’ tab of the CREATE/ALTER TABLE interface.
* Schema Sync did not handle BIT-column defaults properly. A redundant apostrophe caused the statement generated to be invalid.
* Also if Schema Sync operated on a table where only column-level comments differed on source and target an invalid statement would be generated.
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php
Changes (as compared to 5.0) include:
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. It is 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).
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php
Hi,
Webyog and Percona are giving away free tickets to the Percona Live MySQL Conference and Expo, and you can win them! We’re also giving away copies of High Performance MySQL, 3rd Edition!
This year’s event is the best ever, with a better lineup of talks and speakers than ever before. It’s the one event you should not miss if you’re at all interested in MySQL. We really want you to be there — and that’s why we’re joining with Percona to give away free tickets! It’s easy to enter:
To Tweet, “like,” or +1 a session, just browse to the session and use the social sharing buttons on it.
It is OK to enter multiple times — each time you enter increases your chances of winning. The contest runs for a week, so you can enter on multiple days and increase your odds further.
The official contest rules, including more ways to enter the contest, are on Percona’s blog post. Good luck!
Cheers,
Chirag
Team Webyog
Changes (as compared to 9.61) include:
Features:
* A Korean translation is now included.
Miscellaneous:
* The localization tools have been updated. The compiler for building localizations is now up to 100 times faster than before. Also the XML has now been properly versioned. Refer this blog on how to download the localization kit.
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php
Comments(1)