The MySQL Development team is happy to announce our 5.7.4 development milestone release, now available for download at dev.mysql.com.  You can find the full list of changes and bug fixes in the 5.7.4 Release Notes.  Here are the highlights. Enjoy!

Error Logging

Use of error logging API in InnoDB (WL#6755) This work by Anil Toshniwal completes the integration of the new error log formatting in 5.7. It was done for the server layer in 5.7.2 and now it has been done for InnoDB. There is one common API for all error logging. Messages to the error log now have the same format with connection ID and UTC timestamp with microsecond resolution.  The user is in …

The MySQL developer tools team announces 6.1.4  as our GA release for MySQL Workbench 6.1.

MySQL Workbench 6.1 is an upcoming major update for the official MySQL graphical development tool.
Introducing over 30 new features, this version has many significant enhancements focusing on real-time performance assessment and analysis from the SQL statement level to server internals and file IO. You can see this in additions to the SQL Editor as well as new dashboard visualization and reporting that take advantage of MySQL Server 5.6 and 5.7 Performance Schema, and enhancements to the MySQL Explain Plans.

Additionally Workbench 6.1 is leveraging work from various teammates in MySQL Engineering by introducing a schema called “SYS” that provides simplified views on Performance Schema, Information Schema, and other areas. Special thanks to the server optimizer team, server runtime team, and Mark Leith.  …

The previous integration of plink.exe into HeidiSQL's SSH tunnel connection lacked a message dialog which asked for caching a non-existing host key. This includes some more (error-)messages which can only be seen on the command line. HeidiSQL never displayed these messages, as it did not yet watch the stdInput, stdOutput and stdError pipes of the plink.exe process.

Now, with a completely rewritten interface to plink.exe, HeidiSQL displays all messages from the different I/O pipes on the Plink process. Even it creates cancelable confirmation dialogs out of various prompts on the Plink command line.



Bind parameters
Not yet finished but usable: Bind parameters for SQL queries. When your SQL query contains one or more ":myparam:" occurences, the right hand box offers to set a value for these …

The previous integration of plink.exe into HeidiSQL's SSH tunnel connection lacked a message dialog which asked for caching a non-existing host key. This includes some more (error-)messages which can only be seen on the command line. HeidiSQL never displayed these messages, as it did not yet watch the stdInput, stdOutput and stdError pipes of the plink.exe process.

Now, with a completely rewritten interface to plink.exe, HeidiSQL displays all messages from the different I/O pipes on the Plink process. Even it creates cancelable confirmation dialogs out of various prompts on the Plink command line.



Bind parameters
Not yet finished but usable: Bind parameters for SQL queries. When your SQL query contains one or more ":myparam:" occurences, the right hand box offers to set a value for these parameters. Adrien, a contributor from France, …

The previous integration of plink.exe into HeidiSQL's SSH tunnel connection lacked a message dialog which asked for caching a non-existing host key. This includes some more (error-)messages which can only be seen on the command line. HeidiSQL never displayed these messages, as it did not yet watch the stdInput, stdOutput and stdError pipes of the plink.exe process.

Now, with a completely rewritten interface to plink.exe, HeidiSQL displays all messages from the different I/O pipes on the Plink process. Even it creates cancelable confirmation dialogs out of various prompts on the Plink command line.



Bind parameters
Not yet finished but usable: Bind parameters for SQL queries. When your SQL query contains one or more ":myparam:" occurences, the right hand box offers to set a value for these …

The wild and crazy guys over at S&T Geotronics, James Sanderson and Marc Tessier, have decided to go full tilt with a Kickstarter version of their DIY Open Enigma Project.  For those who missed the fanfare last year, they were featured on Instructables showing how to build an Arduino-based encryption machine that works exactly like a WWII era Enigma.  You know, the thing that Alan friggin' Turing and his team at …

When we launched the official MySQL repos back in October, we wanted to achieve a number of things: First, we closed a gaping hole in our distribution on Linux. Some Linux distros do not ship all the MySQL products, and not everyone is able to or always wants to use the distro packages. And the […]

The MySQL February Newsletter is available! Find out the latest news on MySQL products and MySQL Connect 2014, and read the technical tips written by MySQL experts at Oracle and in the community. Below are the highlights in this edition:

• Start Preparing for MySQL Connect 2014 Call for Papers
• New GA Release: MySQL for Visual Studio
• Blog: State of the UNION
• Blog: New MySQL Web Installer -- Have You Tried It Yet?
• Blog: MySQL Workbench: Frequent Crashes on Mac OS X? This Might Be The Fix
• Event: MySQL Seminars Are Coming to a City Near You

You can read it online or subscribe to it to receive the latest updates right in your inbox. Watch this …

The SQL Editor in MySQL Workbench 6.1 adds a new interface for query results.  This addition offers 4 new views to your query results, 2 for the result data itself and 2 for meta-information about the query that was executed.

Query Result Set Grid

The traditional result set grid. Run a SELECT query on a table with a primary key and you can edit the data. You must click the Edit button to enter edit mode.

Note: Until Workbench 6.1.1, the check was being done automatically for every SELECT query, but since that requires extra queries to MySQL, the check is now done on demand.

Result Set Form Editor

The new form editor for result sets comes in handy when you want to closely inspect the fields of each record (specially if it has multi-line text). You …

Red Hat recently released a beta of what will become the next version of their Enterprise Linux. As many people have noticed, Red Hat opted for a forked version of MySQL 5.5 (which GA’d 3 years ago). MySQL has come a long way in those three years, and MySQL 5.6 was released just under a […]