Changes (as compared to first 7.5 RC) include:

Features:
* Query Profiler .. Status Variables will now also display specific global variables. This is useful in particular for understanding InnoDB related issues. Note that if other clients than SQLyog use this server this information may not be useful (as it will be affected by what the other clients are doing).

Bug Fixes:
* Query Profiler sent redundant and unnecessary statements to the server. This has now been cleaned up.
* Fixed an issue where Blob Viewer was showing garbled characters for uft8 data (but in GRID text appeared properly). This was an issue with a WIN32 API function not returning a proper utf8 string. We do not use that function any more, but use our own code instead.
* Fixed a crash while cancelling Migration operation.

Miscellaneous:
* The display “total x of y rows” in status bar (introduced earlier in the 7.5 tree) has been removed/reverted. It affected performance too much with large InnoDB tables (where ‘rowcount’ can be very slow).

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(2)

Changes (as compared to 7.15) include:

Features:
* New major feature: Query Formatter. Any SELECT, UPDATE, INSERT or DELETE statement can be formatted with a single click. Various formatting options/styles are available in ‘preferences’.
* New major feature: Query Profiler. With this feature enabled every SELECT statement will trigger execution of EXPLAIN (EXTENDED) and SHOW PROFLE (if supported by server) for the query and will detect changed SESSION STATUS VARIABLES (with some additional explanation of the meaning of those) due to execution of the query. The feature is highly configurable. The information will display in an ‘Profiler’ tab opening in the DATA/RESULT area. With this new feature there is no longer an excuse not to profile queries continously in the application development process – simply because whether you do it or not the effort will be practically the same! Refer to documentation for full details and for limitations of current implementation. This beta contains first step (only) planned for this feature.
* New improved icon theme with larger icons (in progress). The old icon theme originated back from a time where monitor resolutions were lower than what is mostly the case today. Also added an option to for user to select various icon sizes in the icon toolbar.
* The ‘info-line’ displaying at the bottom of DATA, RESULT and PROFILER tabs can now be turned on/off as defined by user.
* Added an option to force LETTERCASE (Uppercase/Lowercase) for display of keywords and functions in the editor. Note that only the display in editor is affected. When copying or saving, the LETTERCASE will copied be as it was entered.
* A VIEW can now be generated directly from the Query Builder.
* Status bar will now display information like “showing x rows of total y”.
* Column width’s defined by user in Data GRID will now be preserved when refreshing, filtering, sorting and using previous/next buttons.
* Some minor GUI usability improvements and fixes in Data GRID and in Object Browser.

Bug Fixes:
* If BLOB-viewer was closed by clicking the upper-left corner ‘x’ symbol, changes were lost without warning.
* A SQL script with a user´defined DELIMITER using semicolon failed in editor as well as when importing an external script. Most important “DELIMITER ;;” (double semicolon) did not work – but other DELIMITER strings using semicolon (like triple semicolon etc.) did not either (however note that with HTTP tunnelling and when importing external files this is not yet completed)

Funtionality changed:
* The SQL_WHERE option in Data Sync is changed so that WHERE-condition is evaluated against <source> only (before it was both <source> and <target> (logically OR’ed)).

Miscellaneous:
* The ENTERPRISE uninstaller will now remove registration info from the system. This is a request by users who misspelled the registration name or by mistake registered to themselves as a person and not to their company/organisation. Note that as a consequence you now should have your registration details available if you uninstall and reinstall!

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(3)

Changes (as compared to 7.5 beta1) include:

Features:
* Added option for user to choose between different icon sizes in the icon toolbar.
* Added option for user to select/deselect the ‘info-line’ displaying at the bottom of DATA, RESULT and PROFILER tabs.

Bug Fixes:
* Fixed a crash with PROFILING in beta1.  Crash could occur even when executing rather simple queries.
* Fixed a crash with ALTER TABLE in beta1 when the contents of a cell in the ALTER TABLE GRID was deleted.
* Formatter failed with strings specified with  ”_charset” specifier and/or hexadecimal (‘x’) or binary (‘b’) modifier (like “_utf8 x’AAA00F99′” or “_latin1 b’01010111”’).  Also COLLATE clause for a literal string was not supported by Formatter.

Miscellaneous:
* The ENTERPRISE uninstaller will now remove registration info from the system. This is a request by users who misspelled the registration name or by mistake registered to themselves as a person and not to their company/organisation.  Note that as a consequence you now should have your registration details available if you uninstall and reinstall!

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Comments(1)

Changes (as compared to 3.0 beta 1 include):

Features: :
* Updated advisors.  This is a complete and major revamp of advisors in MONyog. 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 from connection details pages are exposed for customization of counters in Monitors/Advisors page. (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.

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.

Downloads: http://webyog.com/en/downloads.php :
Purchase: http://webyog.com/en/buy.php

Comments(2)

Changes (as compared to 7.15) include:

Features:
* New major feature: Query Formatter. Any SELECT, UPDATE, INSERT or DELETE statement can be formatted with a single click.  Various formatting options/styles are available in ‘preferences’.
* New major feature: Query Profiler.  With this feature enabled every SELECT statement will trigger execution of EXPLAIN (EXTENDED) and SHOW PROFLE (if supported by server) for the query and will detect changed SESSION STATUS VARIABLES (with some additional explanation of the meaning of those) due to execution of the query. The feature is highly configurable. The information will display in an ‘Analyzer’ tab opening in the DATA/RESULT area. With this new feature there is no longer an excuse not to profile queries continously in the application development process – simply because whether you do it or not the effort will be practically the same! Refer to documentation for full details and for limitations of current implementation. This beta contains first step (only) planned for this feature.
* New improved icon theme with larger icons (in progress).  The old icon theme originated back from a time where monitor resolutions were lower than what is mostly the case today.
* Added an option to force LETTERCASE (Uppercase/Lowercase) for display of keywords and functions in the editor. Note that only the display in editor is affected. When copying or saving, the LETTERCASE will be copied be as it was entered.
* A VIEW can now be generated directly from the Query Builder.
* Status bar will now display information like “showing x rows of total y”.
* Some minor GUI usability improvements and fixes in Data Grid and in Object Browser.

Bug Fixes:
* If BLOB-viewer was closed by clicking the upper-left corner ‘x’ symbol, changes were lost without warning.
* A SQL script with a user´defined DELIMITER using semicolon failed in editor as well as when importing an external script.  Most important  “DELIMITER ;;” (double semicolon) did not work – but other DELIMITER strings using semicolon (like triple semicolon etc.) did not either (however note that with HTTP tunnelling and when importing external files this is not yet completed ).

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

NOTE: We really would appreciate feedback on the new features added here! All the new major features are in continued development. The earlier prososals and comments come, the better we can consider those.   Please use the ‘SQLyog BETA Discussions’ category in our Forums!

Comments(0)

Changes (as compared to 7.14) include:

Features:
* Added an option to use Base64 encoding for communicating XML data stream with the HTTP tunneller. Using this option can be required to work around this XML-related bug in PHP.
* Improved editor performance with large scripts if Wordwrap was enabled.

Bug fixes:
* On Windows Vista Business edition, SQLyog could crash while closing down. No other Windows OS (and also not any other Vista edition) was affected.
*  Also a ‘hang’ could occur when closing down. It could happen with all systems, but Windows Vista was mostly affected.
* Schema Sync failed with identically named Foreign Key CONSTRAINTs on identically named colums of basically same type (that could still differ in LENGTH, SIGNED/UNSIGNED specification etc.)

Miscellaneous:
* When a PK is built on a string column using a case insensitive collation, SJA could try to insert a row where the PK was identical to an existing one as compared “COLLATION-wise” (ie. when only LETTERCASE differed). That would result in ‘duplicate key’ error and the sync job would abort. We have now reverted back to case insensitive comparison with string-based PK’s as before 7.0, but (to avoid data loss/overwriting) we will abort sync of tables when a string-based PK uses a binary or case sensitive collation.

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Also SJA for Linux was updated with the fix for ‘duplicate key’ error in Data Sync.

Finally note that due to the added base64-option it was necessary to change the tunneller script. To use this version of the program with HTTP-tunnelling the old tunneller script must be replaced with the version shipped with this build.

Comments(0)