User fired queries in a query tab are now processed in a separate thread, which makes the GUI responsive while you run a longer query. Many users asked for that in issue #1509, which is finally fixed now. However, there is one follow up issue, caused in one specific scenario - will be fixed soon. Please update to the latest build to check that out (Help > Check for updates).

Second thing is I am searching for a new logo image, including an application icon in sizes of 16px, 32px and 48px. As a non-designer, I recently tried out some of my own ideas but in the end they all feel slightly wrong and ugly. If you have a good idea or even like to create a logo for HeidiSQL feel free to comment and attach files on issue #2332. The new logo should contain some green …

Ronald Bradford will be speaking in New York on March 22nd at the offices of the startup incubator General Assembly starting at 6pm.

His presentation “How better indexes save you money” will be an enlightening experience about how index only improvements to already indexed queries and with no additional code changes resulted in huge performance improvements and significant savings in hosting costs for a client.

More information available at Meetup.com EffectiveMySQL Group.

David Stokes mentioned yesterday that the mid-April Orlando Florida “Collaborate 11″ conference has many MySQL-related sessions.

I (Peter Gulutzan) emphasize these session titles, presenters, and what they represent:
MySQL 5.5 Replication by Lars Thalmann (MySQL replication team)
InnoDB: Performance and Scalability Features by Inaam Rana (MySQL InnoDB team)
MySQL Backup and Security - Best Practices by Lenz Grimmer (MySQL community team)
InnoDB: Status, Architecture and Latest Enhancements by Calvin Sun (MySQL InnoDB team)
Sharding Techniques for MySQL by Mats Kindahl (MySQL replication team)
When Things Go Wrong: How to Find SQL Error by Sveta Smirnova (MySQL support team)
MySQL, Oracle and …

Cloud, cloud, cloud. Cloud computing has become the phrase du jour, says one analyst from Gartner. But with many moving to cloud for its obvious benefits, it can no longer be ignored. An offshoot of cloud computing is utility computing. What interests us here is Database-as-a-Service, in particular MySQL on cloud.

Coming back to our original question – Is your MySQL monitoring tool cloud ready? Well, many monitoring tools need agents on server to be monitored. For obvious reasons database-on-cloud vendors don’t allow one to install anything on the servers. With Amazon launching RDS (which is nothing but MySQL instance on cloud) there is a pressing need for tools that …

Monty Widenius has announced that Trudy Pelzer's and
Peter Gulutzan's reference book "SQL-99 Complete, Really" is now
available on the askmonty.org knowledge base
http://monty-says.blogspot.com/2011/01/sql-99-complete-really-now-freely.html

Of course I agree with Monty's praise of our book, but
remember that for more current SQL-standard
information I occasionally post here on blogs.mysql.com/peterg.

When you have an .sql with a huge number of single INSERT statements, such as this:

INSERT INTO mytable (id, name, ...) VALUES (1, 'foo', ...);
INSERT INTO mytable (id, name, ...) VALUES (2, 'bar', ...);
INSERT INTO mytable (id, name, ...) VALUES (3, 'xyz', ...);
...

Such dumps take quite a long time to import normally, as there is a significant overhead per query, multiplied many times for large dumps. HeidiSQL now can package such statements into one larger multi statement query and send this at once the server. As I was testing 4000 INSERTs on a local, simple table I experienced a huge performance improvement:
- single queries: ~40 seconds
- one packaged multi stament: <1 second.

HeidiSQL automatically calculates a package size of some kb below your max_allowed_packet size. Which is in some cases not small enough as I noticed connection cut offs as I sent …

MySQL Workbench is an extensible tool for database design, development, and administration – with support for python scripting and plugins, that can automate basic tasks.

Starting with MySQL Workbench 5.2.31, and with MySQL designers, developers, and administrators in mind, we’ve added a new plugin called MySQL Utilities. The MySQL Utilities is a set of python scripts that automate basic tasks. And as MySQL Workbench is about helping design, develop and administer databases, we’ve put the MySQL Utilities at your fingertips so you can quickly get to them and get your job done. Users will benefit from proven scripts, leverage the testing and ideas of the community and the experts at MySQL, and avoid having to reinvent common scripts…

Lets go on a quick tour…

The MySQL Utilities Plugin starts a shell that contains a set of python scripts that perform tasks such as copying, exporting, and importing databases, finding …

I only recently found out about GigaOm's upcoming Net:Work conference.  It's held December 9 at UCSF Mission Bay conference center.  While the name of the conference is a bit ambiguous, the actual area of focus is very clear: how will we collaborate in the 21st century?  

The impact of smartphones, tablet computing, social networks, Software-as-a-Service and Cloud computing is just starting.  As a result, I think there are tremendous opportunities for startup companies to disrupt existing markets with more modern, lightweight applications that foster collaboration inside the company as well as with partners, vendors, consultants and customers.  

…

Update: Thank you all for making this campaign a stupendous success. We are extending this offer till 3rd Dec 10, 23:59 PST succumbing to users demand. Many corporate users requested us to extend the offer as they require time to get official approval. Pick your copy right now! Use coupon code blkfrdy10 to get 50% off.

Happy Thanksgiving!

Black Friday is back with a bang! We are happy to offer a 50% flat discount on all Webyog products. Hurry up, this offer is valid only till 29th Nov 10, 23:59 PST 3rd Dec 10, 23:59 PST.

Still using SQLyog Community Edition? Upgrade to feature rich SQLyog Professional/Enterprise/Ultimate Edition. This offer is literally too good to pass up. Check out the features here.

Worried about your MySQL server’s health? Monitor it like a PRO. Get MONyog – MySQL Monitor & …

Now it's two and a half year since the last refactoring of HeidiSQL's dialog for editing user accounts. The current dialog was ok from a usability point of view, but it did not allow users to assign routine privileges on newer servers. And it edited and created users by updating the tables in the mysql db directly, which is error prone, complex and not recommended by MySQL.

The new dialog now does all updates by GRANT, REVOKE, RENAME USER and SET PASSWORD, as recommended by MySQL. The GUI has also evolved:
- you can clone users now
- the entered password must be repeated
- privilege names are painted in different colors for read, write and admin relevance
But see yourself:



To get it, just go to Help > Check for updates and install the latest build.