Blog

SQLyog MySQL GUI 12.2.2 Released

  • peter_laursen
  • May 5th, 2016
  • Releases, SQLyog
  • Changes as compared to 12.2.1 include:

    Features:

    * The ‘date picker’ now has a GUI control to insert current date.
    * When running multiple statements in the editor and an error occured, SQLyog would continue to next statement.  There is now an option to ‘halt on error’ in such cases.

    Bug Fixes:

    * The `sys` database of MySQL 5.7 was erroneously backed up when choosing  ‘all databases’ in the Scheduled Backup tool.
    * Table-level comments were truncated at 490 characters.
    * The ‘date picker ‘ calender could display distorted in DATA tab in some cases.

    Miscellaneous:

    MySQL username max-length in SQLyog connection settings has been increased from 16 to 32 characters, as MySQL 5.7 now allows for.

    Downloads: https://www.webyog.com/product/downloads
    Purchase: https://www.webyog.com/shop

    MONyog MySQL Monitor 6.53 Has Been Released

  • peter_laursen
  • April 28th, 2016
  • MONyog, Releases
  • Changes (as compared to 6.52) include:

    Bug Fixes:

    * “Count” column did show empty value in Processlist based Real-time.
    * Performance_Schema based Real Time failed if global sql_mode included “ONLY_FULL_GROUP_BY”.
    * Clicking on locked queries were not showing its corresponding locking query and vice versa for Performance_Schema based Real Time.
    * The counter “General Log Enabled?” was showing incorrect value for MySQL 5.6.1+ versions.
    * In rare cases, MONyog would show only time with no date in x-axis if the chart was plotted for multiple days.
    * Editing LDAP group was not always working as expected.
    * With RDS servers MONyog could fail to detect log files and would display the error “log file not present”. It happened because of changes in the XML-response of Amazon’s REST API introduced since we started supporting logs with RDS.

    Miscellaneous:

    * The default filter for “show queries only” in processlist now includes ‘Command=Execute’. Also ‘Command=Execute’ is now included in processlist-based Real Time and Query Analyzer interfaces.

    Downloads: https://www.webyog.com/product/downloads
    Purchase: https://www.webyog.com/shop

    New Query Analysis Features in MONyog

  • Chetan
  • March 7th, 2016
  • MONyog, MySQL
  • While looking to optimize your MySQL, you are needing to spot slow/bad queries at a glance and get deep insights about them with ease.

    The latest update of MONyog brings new easier ways to find problem SQL in Real-Time, Wayback Machine and sniffer based Query Analyser using Performance Schema. Here is what’s new:

    Query Execution Status and Full Table Scan Count
    View success/failure status of every query executed and also the number of ‘full table scans’ for queries in a single glance.
    Query Execution Status and Full Table Scan Count

    The latest update also has an option to switch between Performance Schema and Processlist in Real-Time making it easy for you to enable/disable Performance Schema or Processlist.

    Get the latest update now to enjoy these features.Existing customers can download MONyog 6.52 from Customer Area. To evaluate MONyog 6.52, please download a 14-day trial.

    We’re excited about this update. We would love to know your feedback and thoughts. Drop a comment to share your feedback.

    MONyog MySQL Monitor 6.52 Has Been Released

  • peter_laursen
  • March 2nd, 2016
  • MONyog, Releases
  • Changes (as compared to 6.51) include:

    Features:

    * Added an option to choose data collection mode for Real-Time, Users can now choose between ‘Performance schema’ or ‘Processlist’. Old versions used ‘Processlist’ what we replaced with ‘Performance schema’ recently for servers running with needed P_S instruments enabled.  However due to the aggregation and truncation of queries recorded  in P_S we had several requests that both options should be there.
    * Information whether a query is performing a full table scan available in Query Analyzer, Wayback Machine and Real-time. This information will help to identify queries which are not using Indexes. Note: this is available only for Performance Schema mode.
    * Added a new monitor group ‘sys schema’. It contains various CSOs (Custom SQL Objects) utilizing the “sys schema” database introduced in MySQL 5.7.7.
    * Added an option to either have a fixed length height or dynamic (full screen) height for Processlist in MONyog GUI. We have been using each in earlier versions, but it seems impossible to make everyone happy with a single solution. Now user can choose what display/design that fits him best.

    Bug Fixes:

    * The MONyog API failed to set the error log path.
    * With MySQL 5.7+ Query Analyzer was displaying seemingly random values for the column “first seen” and “last seen” when using server logs (slow query log, general query log) as data source. This happened  because of change of Timestamp format in the logs in MySQL 5.7.
    * The filter “doesn’t contain” was not working properly in Real-time.
    * Fixed an issue where UDOs were displaying incorrect values after running for some time.
    * While editing the server using MONyog API, SSH settings were automatically set to disabled (even if it was enabled earlier).
    * For RDS/Aurora servers, “Apply the above settings to all the servers with same tags” (Edit server -> Advanced settings) was not working.
    * MONyog was giving the error “Log file not present” if either one of the slow query log or general query log was disabled for RDS servers.
    * Fixed Javascript errors and optimized the charts for Real-time page for IE8 browser.

    Miscellaneous:

    * The Y-axis in Charts had just “values” written, now it shows relevant units like percentage, seconds etc. and option is provided to customize the Y-axis value.

    Downloads: https://www.webyog.com/product/downloads
    Purchase: https://www.webyog.com/shop

    SQLyog MySQL GUI 12.2.1 Released

  • peter_laursen
  • February 25th, 2016
  • Releases, SQLyog
  • Changes as compared to 12.2.0 include:

    Bug Fixes:

    * Updates from RESULT tab could fail with MySQL 4.1 servers. The recent code changes in order to support MySQL 5.7 Virtual Columns overlooked that there is no Information_Schema database in MySQL 4.1 and a required condition could not be verifed due to this.
    * In rare cases “copy database to a different host” option could generate incorrect statements and copying would fail with a ‘columns count mismatch’ error. Also this was introduced with code changes in order to support Virtual Columns in MySQL. Virtual columns did not need to be present in source for the error to occur.
    * Fixed a crash when copying table data to clipboard.

    Miscellaneous:

    * Installer packages are now signed with a SHA2-hashed (and not SHA1 as before) certificate. Since recently Internet Explorer 11 has issued a security warning when installing from installer packages using a SHA1-hash with a build timestamp from Jan 1st 2016 or later. We were not aware of this policy-change by Microsoft when releasing SQLyog 11.1.9 and 12.2.0.

    Downloads: https://www.webyog.com/product/downloads
    Purchase: https://www.webyog.com/shop

    SQLyog MySQL GUI 12.2.0 Released

  • peter_laursen
  • February 12th, 2016
  • Releases, SQLyog
  • Changes as compared to 12.1.9 include:

    Bug Fixes:

    * Virtual Columns of MySQL 5.7 were not handled properly in ‘copy database to other host’.
    * 12.1.9 introduced a sluggishness when moving around the data GRID. In some cases it could be so bad that the program seemed to “hang” completely.

    Miscellaneous:

    * Fixed inconsistent versioning. Earlier we could sometimes use format like “11.19″ and sometimes “12.1.9″. We now consistently use the latter – like “12.2.0″ with this release.

    Downloads: https://www.webyog.com/product/downloads
    Purchase: https://www.webyog.com/shop

    SQLyog MySQL GUI 12.19 Released

  • peter_laursen
  • February 9th, 2016
  • Releases, SQLyog
  • Changes as compared to 12.18 include:

    Features:

    * Virtual Columns support for MySQL 5.7 onwards (Virtual Columns with MariaDB were already supported). Please see note below for details.
    * SSL and SSH-tunnel are now not mutually exclusive. A SSL connection may now be established through an SSH-tunnel.  This is in particular useful with various sorts of “private clouds” where connection to the cloud requires SSH and privacy of the cloud is enforced by using SSL for internal communication in the cloud.
    * Multiple files (.sql, .schemaxml, .queryxml) may now be opened in one operation in main editor window.

    Bug Fixes:

    * When importing from some (not commonly used) external data sources using a WHERE-clause a SPACE was missing before the “WHERE” keyword causing an error. This is actually an issue with ODBC-drivers affected, but this release has a workaround.
    * In CREATE/ALTER TABLE dialog a default value could be specified for BLOB/TEXT columns. The server does not permit this and doing so will result in a server error. Now the GUI prevents it.
    * Fixed minor bugs with the Virtual Columns support for MariaDB.

    Miscellaneous:

    * SQLite has been upgraded to version 3.10.0. This results in performance improvements (in autocomplete in particular).

    Downloads: https://www.webyog.com/product/downloads
    Purchase: https://www.webyog.com/shop

     

    An additional note about Virtual Columns support:

    There is a very important difference between Virtual Columns in MariaDB and MySQL 5.7 as described here. With the MySQL implementation from 5.7.8 both SQLyog backup/restore, Data Sync and ‘copy to other’ would fail with a server error if tables contained virtual Columns (it worked with MariaDB). The most serious issue was, of course, that backups from tables with Virtual Columns could not be restored – simply because when you found out, it may have been too late already.

    With this release all DML statements generated by SQLyog have been modified to consider Virtual Columns where needed – and also will consider the particularites of MariaDB and MySQL implementations.  However sync tools will not work with tables with Virtual Columns between MySQL and MariaDB as the syntax of the DDL differs.

    We believe that SQLyog - except for ‘mysqldump’ from 5.7.9 –  is the first tool/client that will work with Virtual Columns of both MariaDB and MySQL.

    SQLyog MySQL GUI 12.18 Released

  • peter_laursen
  • December 29th, 2015
  • Releases, SQLyog
  • SQLyog MySQL GUI 12.17 Released

  • peter_laursen
  • December 28th, 2015
  • Releases, SQLyog
  • Changes as compared to 12.16 include:

    Bug Fixes:

    * Fixed a memory leak as well as a crash in ‘session restore’ when writing a restore point. This  was reported by a number of users. We were never able to reproduce these issues ourselves but a number of affected users have tested and confirmed the fix.
    * The formatter could add trailing space after specific keywords occuring at the end of a line.
    * In CSV exports there was an additional comma after each row while exporting a table if the last column was not selected for export.

    Miscellaneous:

    While exporting a table having BLOB/TEXT type column(s) to ‘fixed length CSV’, a warning message is displayed that this may result in truncation of data and user is given the choice whether to continue or not.

    Downloads: https://www.webyog.com/product/downloads
    Purchase: https://www.webyog.com/shop

    MONyog MySQL Monitor 6.51 Has Been Released

  • peter_laursen
  • December 11th, 2015
  • MONyog, Releases
  • Changes (as compared to 6.5) include:

    Features:

    * RDS log monitoring feature can now be configured using the MONyog API.

    Bug Fixes:

    * The query SHOW ENGINE INNODB STATUS fails for MySQL version less than 4.1.2. and resulted in a MONyog crash. Even though we don’t recommend MySQL 4.1 (and not at all such early beta of it), we should not crash.
    * Fixed JavaScript errors for Query Analyzer and Real Time tab in Internet Explorer 8 (WinXP, Win2003).
    * With MariaDB 10.1.x MONyog erroneously listed all user accounts as having no password.
    * The curl library used could crash, and thus crash MONyog, when resolving too many hostnames at the same time.
    * Monyog failed to send ‘stable alert’ when both “notify till stable” and “notify when stable” options were enabled and if different values were set for the “send notification when alertable” and “remind me after every ..”.
    * Fixed the height of the Processlist display for each server. Each server’s processlist window is now displayed as scrollable window of fixed height. This is a regression fix and a revert of the page design to that of older versions. With recent versions it was necessary to scroll the browser window.

    Miscellaneous:

    * Upgraded SQLite library to v3.9.1. This results in ~25% performance improvement on most environments.
    * Renamed the “Row Access Statistics” counter to “Queries Executed” as it actually uses the ‘queries’ status variable. The old term confused some users.

    Downloads: https://www.webyog.com/product/downloads
    Purchase: https://www.webyog.com/shop

    Page 1 of 4812345...102030...Last »