Hi,

SQLyog 8.0 is a major new version of SQLyog introducing major features like Query Profiler, SQL Formatter and vastly improved look and feel.

Query Profiler:

MySQL has always lacked the sophisticated profiling tools shipped with proprietary databases like SQL Server, etc. MySQL developers have largely depended on EXPLAIN for tuning queries. The SHOW PROFILE patch by Jeremy Cole was introduced in the MySQL Community version 5.0.37 and it provided much more insight into where the query spends its time. However, to take advantage of this feature, MySQL developers were supposed to switch on profiling, run their queries and then filter the profiling data from a table that contained the profiling

  [Read more...]

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

  [Read more...]

Features:
* The ‘query sniffer’ can now connect to and retrieve data from a running instance of the MySQL-proxy program used by one or more clients to connect to MySQL.  A LUA script for controlling the proxy for use with MONyog is provided with this build.  With this sniffer option the SHOW FULL PROCESSLIST statement will not be sent and thus use of ‘query sniffer’ will not put any load on MySQL.
* SSH connections will now attempt more authentication methods in case the first method attempted failed.  This will solve problems reported with tunneling to MySQL on FreeBSD that as per default does not support the full range of SSH authentication methods (and possible similar problems).

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

  [Read more...]

Changes (as compared to 2.83) includes:

Features:

* This release adds a ‘base time’ setting in MONyog. This setting (if defined by user) will be used for calculation of uptime-based counters. The reason for this implementation is that if FLUSH STATUS is executed with a MySQL server, specific server status variables will be reset to the same value as would be after a server restart. However the ‘uptime’ status variable itself is not affected by FLUSH STATUS. And as uptime-based counters will relate the value of cumultive status variables with some intial time, using the ‘uptime’ variable as the initial time will result in calculation of misleading values if FLUSH STATUS was executed. So to get true uptime-based counters in MONyog with servers that do not support the

  [Read more...]

OurDelta build for MySQL 5.0.67 with patchset d7 is now available, in source (new!) and packaged binaries for RHEL/CentOS 4 and 5, Debian 4.0 Etch, Ubuntu 8.04 LTS (Hardy) and (new!) Ubuntu 8.10 (Intrepid).

If you already installed the OurDelta repository information, yum update or apt-get upgrade will install the updated packages for you. Please do review the special notes on backward compatibility below.

Fixes & Additions:

• Fixed up all backward compatibility and reserved keyword issues. You can now drop in an OurDelta build to replace a stock version. Generally

  [Read more...]

Build for Debian Etch done and available, simply click to the new Debian page for the info to set up your repo. Thanks to Peter Lieverdink (cafuego on the #ourdelta IRC channel) for the fast work!

Your interest (from 53 different countries according to Google Analytics!) and response has been great! Among the feedback, saw a few bug reports on minor issues in the packaging, most of which have already been addressed for the next build (bug handling progress is all visible on Launchpad). And discussion about various patches that are “around”; some mails came to people directly but we try to encourage using the oursql-developers team mailing list.

We are pleased to announce the release 1.0.14 of HoneyMonitor, our GUI for MySQL™ administration and monitoring.

With this release, available for immediate download, all HoneyMonitor’s Editions:

• Lite Free
• Standard
• Enterprise
• Network
• Pro

  [Read more...]

With the build system, repos, patches and launchpad sorted, we can release! First up is a build of 5.0.67, using patchrev d6, for i386/x86_64. This is basically Percona patchset 5 with a few fixes plus the Sphinx storage engine. It even passes the testsuite

• RHEL/CentOS 4.6/5.2 RPMs and YUM repo info
• Ubuntu Hardy DEBs and apt-get repo info

Other useful links:

• Launchpad project and patch repo
• Developer team and mailing list (do join!)
• Bug handling

Now, this being a first release into

  [Read more...]

Dashboard view of the Top 5 tables being used by this blog. Current release of MONyog shows the disk usage even at table level.

Changes (as compared to 2.72) include:

Features:
* Added new monitoring module displaying disk usage information for databases and tables.
* Display of slow log data in Log Analyser had added more information (about when query occured, information about number of rows examined and sent)

Bug fixes:
* When a multibyte character was used in a connection name the display would garble and also the connection could not be deleted from GUI.
* When connection was not available the caption for counters should display “n/a”. Since 2.71 it would instead display a string exposing an

  [Read more...]

Changes (as compared to 7.02) include:

Features:
* Added keyboard shortcut (F6) for Edit Index.
* The behaviour of Ctrl+R shortcut was slightly changed. It will now position cursor inside the active tab in Result pane. Before it was functional only with DATA tab and RESULT tabs.
* Added tab-navigation (for query tabs) entries in Edit-menu. Also the active Query tab can now be closed from menu.
* In certain situations Schema Sync would generate CHANGE-clauses for a column that basically did nothing (changing column to what it was). This is now ‘cleaned up’.
* A tab in the Query pane (a Query tab, a Schema Designer tab and a Query Builder tab) can now be closed with Alt+L keyboard shortcut and can now be navigated with Ctrl+pgup and Ctrl+pgdn keyboard shortcuts.
* Favorites are now displayed using

  [Read more...]

Features:
* CPU optimisations in both MONyog (server) process (in particular when ‘Monitors/Advisors’ page was being viewed) and browser processes (viewing Dashboard could cause high CPU usage in Firefox browser in particular).

Bug fix:
* Fixed a dependency with the SSH library that could cause failure to install in Win2K. This was an issue with the updated SSH library introduced with version 2.5.

Miscellaneous:
* The RPM installer scripts for Linux were updated in various ways. This solves issues on specific distributions including: 1) uninstall with the SuSE/YaST ’software management’ GUI was not possisble. 2) It was not always possible to install on top of a running MONyog service - sometimes it was necessary to stop service manually before

  [Read more...]

Changes (as compared to 2.51) include:

Features:
* Log Analyzer code has been completely refactored resulting in better performance and stability and more maintainable code.
* The progress indicator for downloads in Log Analyzer page is now a true quantitative progress bar.
* Error messages in Log Analyzer were rewritten. Every single possible error is now differentiated by a specific message providing help for the situation.

Bug fixes:
* “Group by” option in history/trends page could deliver incorrect results if MySQL and MONyog were using different timezones.
* With SFTP connection to the log file selecting “ALL” for log size to be downloaded in Log Analyzer page could have the result that the log file download would last forever.
* Analyzing log chunks containing BULK

  [Read more...]

Changes (as compared to version 7.0) include:

Bug fix:
* When SQLyog tried to reconnect while exporting a crash could occur. This bug was introduced in 7.0 with the speed optimization of the export dialogue.

Also SJA for Linux was updated with a fix for a (non-related) issue: Since version 6.5 SJA for Linux would not run on Pentium 3 processors (a ‘illegal instruction’ error was returned).  This is now fixed with this generic build.

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

We are pleased to announce that we are now able to release MONyog 2.5 FINAL.

First: for the overall concepts and considerations with this release please refer to this BLOG post (from the release of first beta).

Details for this release (as compared to version 2.06) are:

Features:

MySQL Server Log Analysis: MONyog is now able to retrieve (completely or partially) the General Query Log and the Slow Query Log (whether stored as files or tables on the server) from the MySQL servers it connects to and analyze them.

Query Sniffer: A ‘query sniffer’ is implemented that will record a ‘pseudo log’ on the client

  [Read more...]

Changes as compared to version 6.56 include:

Features:

* New GRID design (’zebra’ Office 2007 style) for easier navigation.
* Multiple selection in GRIDs with SHIFT+CLICK.
* Improved Data Synchronization. Now typically 2-8 times faster than before depending on data. Option to generate a SQL sync script was added.
*  Drastically improved the speed of exports.
* New more user friendly design for the Schema Synchronisation (renamed from Structure Synchonisation). Various filter (’hide and ignore’) options were added. Also a long-running Schema Sync compare task can now be stopped.
*  Added automatic and manual update check.

Bug fixes:

* A backup script backing up all databases could fail to restore VIEWs referencing another database than the one where the VIEW was.

  [Read more...]

Bug fixes and Enhancements:

• Optimized SFTP code. This means that the Log Analyzer is now several times faster than previous Betas
• Fixed an issue with trending
• Log file parsing issue with MySQL 5.1.x resolved

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

Features:

* New GRID design (’zebra’ Office 2007 style) for easier navigation.
* Multiple selection in GRIDs with SHIFT+CLICK
* Improved Data Synchronisation. Now typically 2-8 times faster than before depending on data. Option to generate a SQL sync script was added.
* New more user friendly design for the Schema Synchronisation (renamed from Structure Synchonisation). Various filter (’hide and ignore’) options were added.

Bug fixes:

* A backup script backing up all databases could fail to restore VIEWs referencing another database than the one where the VIEW was.
* Around 50 other small (mostly GUI-related) fixes for issues reported by users.

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

MONyog 2.5 beta 2 has been released.

Bug fixes:

* Under specific circumstances the service would stop very slow.
* If network connection was temporarily unavailable the first CPU value after network came back told 100% CPU load.
* The temporary files for storing public/private keys are now being created with very restrictive file permission in Linux. So only the owner will be able to read/write these temporary files. Although these files would exist only for a fraction of second, in earlier versions of MONyog other users in the same Linux system could get access to them within that small timeslice.

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

We are very pleased to announce the release of MONyog 2.5 Beta 1. This is a major upgrade from the previous releases.

MySQL currently lacks advanced query profiling tools like SQL Server’s Query Profiler. While the current breed of MySQL monitoring tools provide monitoring and advisory information on various system metrics, they don’t help in pinpointing the problematic queries. No amount of hardware upgrades or tuning of mysql.cnf / mysql.ini parameters can match the performance gains that can be achieved when problematic queries and identified, rewritten and/or appropriate indexes are created.

MONyog 2.5 helps in identifying problem SQL by

1) Analyzing the general query log
2) Analyzing the slow query log
3) If the above

  [Read more...]

Bug fixes:

* The new version 3 release of Mozilla Firefox (now in RC) had a flickering issue with MONyog and the login page did not load correctly in that browser version.

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

Bug fixes:

*  OS monitoring issue in Fedora Core 6 Zod was fixed

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

Performance improvement:

* Earlier MONyog was semaphore intensive. That could result in reaching the ‘limit of semaphores that can be created by the kernel’ in some systems. MONyog 2.04 will use less semaphores. Another symptom was that a large number of small and zero-size files could be left behind (in system TEMP folder on Windows and in MONyog/bin folder on Linux). This is also solved with this.

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

Bug fixes:

* Structure Sync could miss the concluding quote around column comments. This bug was introduced in 6.5.
* Migration from SQL Server could fail with empty tables.
* Migration (UPDATE and DELETE) triggers could fail with specific schemas on source (afffected were small tables with short column types only - like integers and very short string types). This bug was introduced early in 6.x with the full Unicode support added here.
* Migration could generate non-matching columns-count with specific schemas. This was also introduced early in 6.x
* Message about ?Successful rows? could display twice in Migration (sja.log). Note: This was a cosmetical issue with the message only. Rows were only migrated once!

Downloads:

  [Read more...]

Bug fixes:
* In some situations where SSH connections failed (including if MONyog was not able to connect to MySQL, wrong SSH authentication details for tunnelling etc.), sockets were not being closed and it could result in that many sockets were kept in CLOSE_WAIT state. (note: connections to MySQL not using SSH were not affected!)

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

MySQL Lifecycle Policy Calendar

The official MySQL Lifecycle Policy calendar terminates the end of the Active Support Lifecycle for MySQL 4.1 at the end of this year. The product is then entering the Extended Support Lifecycle. Please click on the image and read "What is the difference between Active Lifecycle and Extended Lifecycle support?" to understand the implications of this.