I'm very proud to announce PostgreSQL support as a big new
feature!
Read and take part in the discussions:
* http://www.heidisql.com/forum.php?t=7025
* issue #3190
Or download the installer (which includes required
DLL's).
We are about to release upgrades to both SQLyog and MONyog with an important fix: linked libraries possibly vulnerable to the ‘Heartbleed’ OpenSSL bug have been upgraded to non-affected versions (the new MONyog release will have a few more fixes as well).
Since this security issue became known a few days ago, media and Internet have swollen with information about vulnerable systems. There is probably both a lot of facts and fiction circulating.
A good summary appeared in the Percona blog. It mostly focuses on server-side vulnerabilities. However this blog indicates that the vulnerability may also be exploitable from clients linking a vulnerable OpenSSL version. SQLyog and MONyog users …
[Read more]The recently released MySQL Workbench 6.1 continues expanding the capabilities of the tool. This version focuses on performance analysis features for MySQL server workload and queries, taking advantage of performance_schema improvements introduced in MySQL 5.6 and 5.7 DMR.
This is a overview of the new features we’ve added. Some of them are covered in more detail in separate posts.
New Navigator PERFORMANCE Section
The new PERFORMANCE section includes Dashboard, Performance Reports, andPerformance Schema Setup pages. Generally, this new performance reporting feature provides a graphical representation of key statistics from the MySQL server status, and provides an overview of the MySQL server subsystems.
Dashboard
View server performance statistics in a graphical dashboard.
…
[Read more]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 …
[Read more]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. …
[Read more]
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 …
[Read more]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 […]