A few months ago we announced the EXPLAIN Analyzer, a simple tool to help you understand how MariaDB / MySQL was running queries. For users of HeidiSQL this is now even easier. As discussed in their news post you can now send a query to the EXPLAIN analyzer with a single click.

We hope this helps both new and experienced users better understand the queries they run.

More information about the EXPLAIN Analyzer and the simple API client authors can use to add support to their apps is available in the AskMonty Knowledgebase:

• …

A screencast demonstrating the MariaDB Windows installer.

(I recommend watching it in full screen 720p, so you can see the details.)

Some links:

• The MariaDB homepage
• The AskMonty Knowledgebase
• The MariaDB Downloads page
• Installing MariaDB on Windows documentation
• The HeidiSQL homepage

Acknowledgments:

A big thanks to Vladislav Vaintroub, MariaDB’s Windows guru, and to Rasmus Johansson for help with the screencast.

Quick pointer that MariaDB 5.2.7 is now released. Highlights from the release notes: RHEL 5 RPMs (in addition to the CentOS 5 RPMs), and the inclusion of the HeidiSQL GUI client for the Windows MSI package. As always, the complete changelog, and what are you waiting for – download it now and give it a try!

Virtual and persistent columns are a feature of MariaDB 5.2+, and HeidiSQL's table editor now fully supports them. Just update your HeidiSQL to the latest build to see this in action.



Also, if you are on a MariaDB server, a brown seal icon in the tree and in the status bar now indicates the right server vendor: