Hi,

SQLyog 8.4 happens to be a fairly major release with good number of features & enhancements. Listed below are some worth noting.

• May it be Query Profiler or Datatype Optimizer, SQLyog has grown beyond the definition of a GUI with these features with intelligence. One such feature that is being unveiled with this release is an option to find redundant indexes. You can find the redundant indexes in a Table with just a click of a button. If found, a ready query is generated to drop the redundant indexes. As you know eliminating redundant indexes improves INSERTs & UPDATEs and also saves hard-disk space.
• Scheduled Backups can be compressed.
• If you are one of those users who deal with databases having thousands of objects (tables, columns etc.) this release will definitely add to your productivity as auto-complete has been drastically improved for such databases.
• You can sort the data of Result set. The sorting is very fast as it is done at the client side unlike Table Data where a query is fired to server for every sort action.

Redundant Index Finder

This release also contains following enhancements:

• A file can be loaded to the tab from context menu.
• Added menu items (for exports and ‘copy to other..’) at table-level in Object Browser.
• Save dialog when closing a connection now has ’Yes to All’ and ‘No to All’ options.
• Added an option to send a mail alert if an error occurs while executing a ‘maintenance query’ from Notifications Services.

SQLyog customers can download the latest installer from Webyog’s Customer Portal.
To evaluate SQLyog, please download the 30-day trial.

We are very excited about this release, and hope that you will like it. We would love to hear from you.

Cheers,
Team SQLyog

PS: Redundant Index Finder is a feature of SQLyog Ultimate only.

Comments(2)

Bug Fixes:
* On un-checking ‘save password’ option in connection window, SQLyog was not deleting password in ini file.
*  Schema Designer was prompting table out-of sync if there was a difference in table’s AUTO_INCREMENT ‘value’ or if extra spaces were present between identifiers.
* On executing SELECT statements having clauses like PROCEDURE, INTO FILE, FOR UPDATE, etc,  was adding LIMIT clause if result tab paging option is enabled.
* Program now has common option in preferences to “Prompt if a tab with unsaved changes is closed”. Earlier it was separate for query editor, Schema Designer and Query Builder tabs.

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

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

Comments(0)

Changes (as compared to 3.74) include the 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. This behavior is not seen in the next iteration of IE6.

Comments(0)

Changes (as compared to 8.4 beta3) include:

Features:
* Drastically improved the speed of the auto-complete option to show suggestion while typing.
* Save dialog when closing a connection now has  ’yes to all’ and ‘no to all’ options.

Bug Fixes:
* Very long strings containing the ‘_’ or the ‘\’ character could cause a buffer overrun when looking up a match in the auto-complete database. Windows would then terminate SQLyog.
* Fixed a rare issue where access to a port (to be used for a SSH tunnel) was erroneously blocked by SQLyog before it was reserved. Even SQLyog itself could then not use it and connection would fail.
* Selecting from the connections dropdown in connection manager using keyboard was not functional.
* The MySQL keywords PROFILE and PROFILES were not considered as keywords by the SQLyog editor and auto-complete.
* New row(s) added in GRID in DATA tab did not display when shifting to TEXT-mode. A refresh was necessary.
* Also sorting in GRID in RESULT tab (as introduced in 8.4 beta 1) did not have effect for TEXT-mode immediately.

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

Comments(0)

Changes (as compared to 8.4 beta2) include:

Features:
* Added an option to find redundant indexes. The control and the information is available from INFO tab/html view. Please refer documentation for details. This is an ULTIMATE feature.

Bug Fixes:
* Stabilized new features added in previous 8.4 betas.
* Fixed a crash (reported internally) that could happen when sorting on multiple columns in DATA tab. Also an invalid query could be generated under same conditions.
* Notifications services would not execute queries after a query returning an error if connection was over a HTTP-tunnel even if user had selected not to abort on error.

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

Comments(0)

Changes (as compared to 3.73) include the 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) occured 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.

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

Comments(0)

Changes (as compared to 8.4 beta1) include:

Features:
* The file menu has been reorganized to comply with standards. Note that to insert from a file into an open editor tab you must now use the context menu item from the editor. Such menu item in the context menu was also added with this release.
* Added menu items (for exports and ‘copy to other..’) to table-level in Object Browser.

Bug Fixes:
* Schema Optimizer did not handle the auto_increment flag. Underlying reason was that MySQL ‘Procedure Analyse()’ does not. We now retrieve this information otherwise.
* Sorting in RESULT tab did not handle BIT types properly. Now such type is sorted as an integer. Also we fixed a few more minor bugs with sorting in RESULT tab.
* When the database context was changed by user between execution of same SELECT-query by clicking ‘refresh’ an empty RESULT tab displayed, what was confusing. Also it was possible to crash SQLyog from this empty RESULT tab. Now we print an error in MESSAGES tab in such case and no RESULT tab displays.
* GUI fixes.

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

Comments(0)