[21 total ]
Posted
2 days
ago
Website was unavailable for a few hours for a large %tage of our users. This was a mistake in DNS configuration. We apologize for this. It has been corrected and correct DNS settings are propagating across the Internet now.
Posted
5 days
ago
SQLyog 6.55 has been released.
Changes (as compared to 6.54) include:
Bug fixes:
* With specific export settings, CSV-export could add an erroneous NULL byte (hexadecimal 00) before the field seperator (if no escape character
... [More]
was specifed and if string data contained the chosen seperator character).
* With specific content of an editor tab, SQLyog could enter an infinite loop and become irresponsible. It was a bug in the code for column alias'es with Autocomplete introduced in 6.52.
* When SQLyog was closed from a secondary monitor and started again when secondary monitor was not attached, SQLyog program window would not open on the primary monitor.
* With specific multimonitor configuration context menu of the Processlist dialogue would open on primary monitor also when program was running on secondary monitor.
* After stopping a running query, SQLyog could fail to initialize sql_mode for the new connection created.
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php [Less]
Posted
11 days
ago
SQLyog 6.55 RC2 has been released.
Changes (as compared to first RC) include:
Bug fixes:
* By mistake RC1 was released with some experimental code in Structure Sync that could cause a crash.
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php
Posted
12 days
ago
SQLyog 6.55 RC has been released.
Changes (as compared to 6.54) include:
Bug fixes:
* With specific export settings. CSV-export could add an erroneous NULL byte (hexadecimal 00) before the field seperator (if no escape character
... [More]
was specifed and if string data contained the chosen seperator character).
* With specific content of an editor tab, SQLyog could enter an infinite loop and become irresponsible. It was a bug in the code for column alias'es with Autocomplete introduced in 6.52.
* When SQLyog was closed from a secondary monitor and started again when secondary monitor was not attached, SQLyog program window would not open on the primary monitor.
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php [Less]
Posted
20 days
ago
SQLyog 6.54 has been released.
Changes (as compared to 6.53) include:
Bug fixes:
* When executing Structure Sync between a 5.1.x server and an earlier version, Structure Sync could try to access a non-existing
... [More]
Information_Schema.Events table, what returned an error (it depended on the exact 5.1 version).
SQLyog 6.53 was released earlier today with changes (as compared to 6.52) including:
Bug fixes:
* When defining parameters for export, database selection had no effect if the database was selected after the output file was specified. This bug was introduced in 6.5.
* SQL-dumps created with SQLyog 'export' and 'scheduled backup' did not specify default charset and collation in CREATE DATABASE statement when dumping from MySQL versions where it applies (MySQL >= 4.1).
* The size of the SQLyog program window would grow a little everytime it was opened. This is due to a change introduced in 6.5. This has been reverted.
* The various fixes for BIGINT PK's in Data Sync in the 6.1x tree had slowed down data sync with BIGINT PK's.
* Alias support in Auto-Complete could fail if there were comments close to the actual statement. This bug was introduced in 6.52 (with the support for column alias'es introduced here).
* In RESULTS tab in text-mode the string "(NULL)" could be truncated to "(NUL".
We apologize that we forgot to include a single patch in 6.53 that made it necessary to release 6.54 shortly after.
Also SJA for Linux was updated to version 6.54 (the fix in 6.53/6.54 for BIGINT PK's in Data Sync also applies here).
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php [Less]
Posted
20 days
ago
SQLyog 6.53 has been released.
Changes (as compared to 6.52) include:
Bug fixes:
* When defining parameters for export, database selection had no effect if the database was selected after the output file was specified. This bug
... [More]
was introduced in 6.5.
* SQL-dumps created with SQLyog 'export' and 'scheduled backup' did not specify default charset and collation in CREATE DATABASE statement when dumping from MySQL versions where it applies (MySQL >= 4.1).
* The size of the SQLyog program window would grow a little everytime it was opened. This is due to a change introduced in 6.5. This has been reverted.
* The various fixes for BIGINT PK's in Data Sync in the 6.1x tree had slowed down data sync with BIGINT PK's.
* Alias support in Auto-Complete could fail if there were comments close to the actual statement. This bug was introduced in 6.52 (with the support for column alias'es introduced here).
* In RESULTS tab in text-mode the string "(NULL)" could be truncated to "(NUL".
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php [Less]
Posted
24 days
ago
SQLyog 6.53RC2 has been released.
Changes (as compared to first 6.53 RC) include:
Bug fixes:
* The various fixes for BIGINT PK's in data sync in the 6.1x tree had slowed down data sync with BIGINT PK's.
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php
Posted
27 days
ago
SQLyog 6.53RC has been released.
Changes (as compared to 6.52) include:
Bug fixes:
* When defining parameters for export, database selection had no effect if the database was selected after the output file was specified. This
... [More]
bug was introduced in 6.5.
* SQL-dumps created with SQLyog 'export' and 'scheduled backup' did not specify default charset and collation in CREATE DATABASE statement when dumping from MySQL versions where it applies (MySQL >= 4.1).
* The size of the SQLyog program window would grow a little everytime it was opened. This is due to a change introduced in 6.5. This has been reverted.
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php [Less]
Posted
about 1 month
ago
SQLyog 6.52 has been released.
Changes (as compared to 6.51) include:
Features:
* Data Sync now has SMTP (mail) functionalities similar to other SJA modules.
* Autocomplete now supports column alias'es.
* Zooming in
... [More]
Schema Designer can be done with 'Ctrl ' and 'Ctrl -'.
* Added an option to specify (in preferences .. powertools) storage position for TAGS files (used by Autocomplete). On networks where 'roaming profiles' are stored on a domain server specifying a local folder will reduce network traffic and save storage on the server.
Bug fixes:
* ALTER TRIGGER template did not display DEFINER.
* Create/Alter table .. advanced properties generated the string '[default]' where it should be 'default' only.
* Fixed an issue with 'abort on error' in Scheduled Backup. The job was always aborted on error. Now if set to NO it will proceed to next statement.
* Notifications Service could crash if query was not SELECT. In particular HTTP tunnelled connections were affected by this.
* Migration from an Access database could leave a .ldb file behind (that should be deleted after the migration process was over).
* On Vista a graphical artifact could occur on right side of screen when program was maximized.
* Some other small GUI fixes.
Also SJA for Linux was updated to version 6.52.
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php [Less]
Posted
about 1 month
ago
MONyog 2.02 Has Been Released.
Bug fixes:
* The display of CPU load in the 'delta' timeframe was incorrect.
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php
Posted
about 1 month
ago
SQLyog 6.52 beta1 has been released.
Changes (as compared to 6.51) include:
Features:
* Data Sync now has SMTP (mail) functionalities similar to other SJA modules.
* Autocomplete now supports column alias'es.
* Zooming
... [More]
in Schema Designer can be done with 'Ctrl ' and 'Ctrl -'.
* Added an option to specify (in preferences .. powertools) storage position for TAGS files (used by Autocomplete). On networks where 'roaming profiles' are stored on a domain server specifying a local folder will reduce network traffic and save storage on the server.
Bug fixes:
* ALTER TRIGGER template did not display DEFINER.
* Create/Alter table .. advanced properties generated the string '[default]' where it should be 'default' only.
* Fixed an issue with 'abort on error' in Scheduled Backup. The job was always aborted on error. Now if set to NO it will proceed to next statement.
* Some other small GUI fixes.
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php [Less]
Posted
about 1 month
ago
SQLyog 6.51 has been released.
Changes (as compared to 6.5) include:
Bug fixes:
* The template for ALTER TRIGGER mismatched the trigger name and the database name.
* The OBJECTS tab displayed incomplete information for the
... [More]
server/connection. This only affected COMMUNITY edition.
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php
Important note for ENTERPRISE users: Before installing please have your registration details available. This 6.51 build will prompt for registration details. Details are the same as for earlier 6.x versions. Please also note (if you never used this before) that we have 'polite self service' here - just in case you cannot find the details and need help to retrieve it. In case just go to http://www.webyog.com/CustomerArea. [Less]
Posted
about 1 month
ago
MONyog 2.01 has been released.
Bug fixes:
* Whenever Dashboard was drawn for the first time or redrawn with new configuration settings all nodes displaying CPU load were erroneously drawn with the latest available value. New values
... [More]
appearing after that were drawn correctly. Only CPU load counter was affected.
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php [Less]
Posted
about 1 month
ago
SQLyog 6.5 has been released.
Changes (as compared to 6.16) include:
Features:
* Export and copy dialogues were re-designed. Individual Stored Procedures, Views etc. can now be selected.
* Added a ZOOM option for a Schema
... [More]
Designer LAYOUT. The ZOOM setting is stored in the LAYOUT itself. Note: Zooming is possible using Ctrl mouse scroll button (may not be functional on Laptop touchpads and other non-mouse pointing devices).
* A Schema Designer LAYOUT can now be saved as graphics (currently .bmp format is supported).
* A Schema Designer LAYOUT can now be printed. For saving graphics from Schema Designer to formats not supported consider printing to a 'virtual printer'. Such software exist with support for .pdf, .xps, .png and more. There is a preview option to see how the print will split into more pages (using the settings of current default printer).
* Transactions are now supported for copy operations (but of course the Storage Engine must support too!). This is configurable from 'preferences'. Data Sync and Migration will use transactions if ENGINE supports it.
* Query Builder can now use a VIEW for generating queries.
* Transactions are now supported for copy operations (but of course the Storage Engine must support too!). This is configurable from 'preferences'. Data Sync and Migration will use transactions if ENGINE supports it.
* Copy operations can use BULK inserts (optionally). This can increase speed of those operation up to ~10 times. Migration and Data Sync will now also use BULK inserts if is empty.
* Full support for MySQL EVENTS (in GUI, exports, copy, structure sync) with MySQL >= 5.1.
* Added an option to export 'all databases' and 'all user data' with 'scheduled backup'. Note the difference: 1st option will export `mysql` database - 2nd will not. None of them will export Information_Schema (it cannot be restored as I_S is a readonly database). However you can select I_S individually for export.
* Support for alias in autocomplete. This is in continued development. Currently table alias's are supported (not column alias'es).
* Tables are now organized in a folder in the Object Browser.
* OBJECTS tab now populate with data for the connection/server, VIEWs and 'stored programs'.
* With SSH tunnel reconnection is now functional for the complete connection chain: SQLyog<>PLINK<>SSHD<>MySQL.
* For HTTP-tunnel added an option to specify 'urlencode' HTTP header format on a per-connection basis (default is 'text/xml' header format). Using this option can be required if Apache 'mod_security' (as well as some largely undocumented filters and 'hacks') is enabled.
* Context help added. Every dialogue of the program has been associated with a page in the help file (CHM), that will open when pressing .
* MESSAGES tab will now report warnings for queries executed from the SQL editor.
* Lots of small requests and issues fixed.
Miscellaneous:
* Note that the SJA jobfile format has needed to be changed/expanded due to some of the changes above. The GUI wizards will generate a version string like 'version="6.5"' in the tag . But old (version="4.2") format can still be executed. If there is no version string in the tag (as was the case up to 4.1), 'version="4.2"' will be assumed implicitly.
* Note that for copy operations reconnect will be disabled if you use transactions. This is required for data security. If a reconnect took place when still non-committed statements had been executed they would not be committed ever (because with a new connection the transaction log for the old connection is not available) and user would not be aware of this. For Data Sync and Migration transactions are always enabled if ENGINE supports it, because this does not result in any conflict as SJA does not reconnect automatically'
Bug fixes:
* Opening a .schemaxml file (to Schema Designer) failed if path contained unicode characters (save not affected and no other save/open operations of the program either).
* It could occur that a connection thread started for the purpose of export did not correctly use the same connection parameters as the 'parent thread'. That might result in a 'Error 0' (actually this includes two different fixes).
Also SJA for Linux was updated to version 6.5.
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php [Less]
Posted
about 1 month
ago
SQLyog 6.5 RC2 has been released.
Changes (as compared to first RC) include:
Bug fixes:
* It could occur that a connection thread started for the purpose of export did not correctly use the same connection parameters as the
... [More]
'parent thread'. That might result in a 'Error 0' (actually this includes two different fixes).
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php [Less]
Posted
about 1 month
ago
MONyog 2.0 has been released.
Changes (as compared to 1.52) include:
Features:
* SSH tunneling to MySQL servers.
* Analysis of historical data (trends).
* Dashboard graph size is now configurable.
* You can
... [More]
choose to display x-axis values or not in Dashboard (in 'large' display mode). Also remember that no matter if axis-values are displaying you can retrieve values by pointing the mouse to a node in the charts.
* The no. of samples displayed in Dashboard is configurable.
* Above dashboard settings can be changed from the dashboard page itself.
* 64 bit binaries for Linux included.
* Option to display counters as 'value/sec'.
* Reorganized the connection page for better clarity.
* Performance improvements.
* Javascript code was 'broken down' to smaller units for easier customization. Every counter group now has its own 'custom' script.
* The menu was reorganized and other GUI improvements for easier navigation between the different functionalities.
* The 'looks and feel' (of graphics in particular) has been vastly improved.
* Documentation/help was updated and reorganized with better structure, more hyperlinks - and also now much more better looking.
Bug fixes:
* MONyog would not install on some older Linux distro's (including RHEL3).
* In Linux it was possible to start more identically named MONyog instances. This is now prevented.
* When stopping MONyog service it could happen that the service was reported to be stopped before the task was complete. Starting service in this situation would return an error. Now it will report 'running' as long as it is not fully stopped.
* Fixed an issue with the shell script for non-RPM Linux where it could be reported that service had started when it had not.
* Fixed some calculation bugs (affected 'hit rate' and 'percentage of used blocks' counters).
Miscellaneous:
* Help/documentation page will open in a separate browser window or tab (depending on browser setting).
* 'Show All' page was renamed to 'Monitors/Advisors'.
* System counters have been renamed to 'Linux counters'.
More details on implementation of SSH-tunnelling and History/Trends analysis:
SSH-tunneling:
The implementation does (unlike current SQLyog implementation) not start any external process. The performance for this 'home grown' SSH-tunnel wrapper is very high (you may find it faster than direct connection to MySQL on a remote host)!
History/Trends analysis:
This is implemented in the 'Monitors/Advisors' page. You can select whatever time interval you want for the analysis. Counters that are UPTIME
based (or if you like: CUMULATIVE counters as opposed to SNAPSHOT counters) can be aggregated using SUM function and common time ntervals (HOUR, DAY, MONTH etc.). This is semantically similar to the query "SELECT SUM () ... GROUP BY " (but the real query behind this interface is much more complex of course!).
Note that if you want to use (or test) this feature you would probably change the server registrations to use a rather long 'retention timeframe'. Also note that as it is now possible to select any time interval at the client side, the 'default timeframe' and 'user timeframe' settings have been removed from the program.
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php [Less]
Posted
about 1 month
ago
MONyog 2.0 RC2 has been released.
Changes (as compared to first RC) include:
Features:
* Performance improvements.
* Javascript code was 'broken down' to smaller units for easier customisation. Every counter group now has
... [More]
its own 'custom' script.
* GUI improvements for easier navigation between the different functionalities.
Bug fixes:
* Fixed an issue with the shell script for non-RPM Linux where it could be reported that service had started when it had not.
* Fixed a bug with 'hit rate' calculation.
This 2.0 RC2 release is a TRIAL. It will expire April 15th. An unlimited no. of servers can be registered.
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php
SQLyog 6.5 RC has been released.
Changes (as compared to beta2) include:
Features:
* Copy and Export dialogues redesigned to get a larger user area for objects selection.
Bug fixes:
* Opening a .schemaxml file (to Schema Designer) failed if path contained unicode characters (save not affected and no other save/open operations of the program either).
* Small fixes, mostly GUI fixes related to the Schema Designer interface.
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php [Less]
Posted
about 1 month
ago
MONyog 2.0 RC has been released.
Bug fixes: (as compared to beta4)
* Fixed issues with CPU-counters (1: CPU would sometimes fail to display in Dashboard. 2: 'delta' timeframe reported 100% CPU load (a formula bug)).
* Further
... [More]
improved the 'register server' interface.
* Some other small GUI fixes.
This 2.0 RC release is a TRIAL. It will expire April 15st. An unlimited no. of servers can be registered.
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php [Less]
Posted
about 1 month
ago
MONyog 2.0 beta 4 has been released.
Bug fixes:
* Fixed a javascript issue that could result in javascript error messages occurring (instead of counters displaying) for Linux counters in Monitors/Advisors interface.
* 'Register
... [More]
Server' page did not refresh correctly in Opera.
This 2.0 beta 4 release is a TRIAL. It will expire March 31st. An unlimited no. of servers can be registered.
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php [Less]
Posted
about 1 month
ago
MONyog 2.0 beta3 has been released.
Changes (as compared to 2.0 beta2) include:
features:
* The no. of samples displayed in dashboard is configurable.
* Dashboard settings can be changed from the dashboard page itself.
... [More]
Accordingly they were removed from tools..preferences.
* Now non-UPTIME-based counters can be GROUPED in 'history/trends'. Implementation details: new attribute introduced named "GroupFunction" (affecting Monitors/Advisors) which is used for generating trending. The default value is "Sum". "Average","Count","Min","Max" also supported.
* Reorganised the connection page for better clarity.
bug fixes:
* MONyog would not install on some older Linux distro's (including RHEL3).
* In Linux it was possible to start more identically named MONyog instances. This is now prevented.
* When stopping MONyog service it could happen that the service was reported to be stopped before it was completely. Starting service in this situation would return an error. Now it will report 'running' as long as it is not fully stopped.
* Some typical 'beta bugs' fixed.
This 2.0 beta3 release is a TRIAL. It will expire March 31st. An unlimited no. of servers can be registered.
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php
SQLyog 6.5 beta2 has been released.
Changes (as compared to 6.5 beta1) include:
Features:
* Query Builder can now use a VIEW for generating queries.
Bug fixes:
* Fixed around 15 typical 'beta bugs' from beta1.
* Fixed some small older issues (mostly GUI issues) as well
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php [Less]
Posted
2 months
ago
SQLyog 6.5 beta1 has been released.
Features:
* Export and copy dialogues were re-designed. Individual Stored Procedures, Views etc. can now be selected.
* Added a ZOOM option for a Schema Designer LAYOUT. The ZOOM setting is stored
... [More]
in the LAYOUT itself. Note: Zooming is possible using Ctrl mouse scroll button (may not be functional on Laptop touchpads and other non-mouse pointing devices).
* A Schema Designer LAYOUT can now be saved as graphics (currently .bmp format is supported)
* A Schema Designer LAYOUT can now be printed. For saving graphics from Schema Designer to formats not supported consider printing to a 'virtual printer'. Such software exist with support for .pdf, .xps, .png and more. There is a preview option to see how the print will split into more pages (using the settings of current default printer).
* Transactions are now supported for copy operations (but of course the Storage Engine must support too!). This is configurable from 'preferences'. Data Sync and Migration will use transactions if ENGINE supports it.
* Copy operations can use BULK inserts (optionally). This can increase speed of those operation up to ~10 times. Migration and Data Sync will now also use BULK inserts if is empty.
* Full support for MySQL EVENTS (in GUI, exports, copy, structure sync) with MySQL >= 5.1.
* Added an option to export 'all databases' and 'all user data' with 'scheduled backup'. Note the difference: 1st option will export `mysql` database - 2nd will not. None of them will export Information_Schema (it cannot be restored as I_S is a readonly database). However you can select I_S individually for export .
* Support for alias in autocomplete. This is in continued development. Currently table alias's are supported (not column alias'es).
* Tables are now organized in a folder in the Object Browser
* OBJECTS tab now populate with data for the connection/server, VIEWs and 'stored programs'.
* With SSH tunnel reconnection is now functional for the complete connection chain: SQLyog<>PLINK<>SSHD<>MySQL
* For HTTP-tunnel added an option to specify 'urlencode' HTTP header format on a per-connection basis (default is 'text/xml' header format). Using this option can be required if Apache 'mod_security' (as well as some largely undocumented filters and 'hacks') is enabled.
* Context help added. Every dialogue of the program has been associated with a page in the help file (CHM), that will open when pressing .
* MESSAGES tab will now report warnings for queries executed from the SQL editor.
* Lots of small requests and issues fixed
Miscellaneous:
* Note that the SJA jobfile format has needed to be changed/expanded due to some of the changes above. The GUI wizards will generate a version string like 'version="6.5"' in the tag . But old (version="4.2") format can still be executed. If there is no version string in the tag (as was the case up to 4.1), 'version="4.2"' will be assumed implicitly.
* Note that for copy operations reconnect will be disabled if you use transactions. This is required for data security. If a reconnect took place when still non-committed statements had been executed they would not be committed ever (because with a new connection the transaction log for the old connection is not available) and user would not be aware of this. For Data Sync and Migration transactions are always enabled if ENGINE supports it, because this does not result in any conflict as SJA does not reconnect automatically.
Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php [Less]