This week's Log Buffer is dedicated to Jolt, Mountain Dew, and Google's Open Source Program Office, who treated the campers like royalty this past weekend at the first MySQL Camp. Leslie Hawthorn, from the OSPO, shed blood for the camp, and deserves the Congressional Medal of Honour for her valiant heroism! (She received 20+ stitches for a cut on her arm due to an accident carrying beer for a session on Saturday. )

MySQL Camp Highlights

MySQL Camp was a wonderful event, even if completely free-form at times. Sessions were lively, interactive, and participants really had a chance to dig in to session material and ask Monty, Brian, Mårten, and a host of other MySQLers good questions. …

In query examinations it is often interesting which columns query needs to access to provide result set as it gives you ideas if you can use covering indexes to speed things up or even cache some data by denormalizing tables. So far it has to be done manually - look at SELECT clause, WHERE clause, ORDER BY GROUP BY and HAVING to sum it up, not to mention more complex questions of subselects.

It would be great tool for MySQL Performance Optimization if MySQL Server could show this table and I know it already has this data as it is used by the optimizer.

It would be also good if such tool would show mapping of WHERE clauses to the tables as well as other clauses such as GROUP BY and ORDER BY. For complex queries especially if they do not refer to the columns with table prefix it may take a while to figure our where these columns come from and so how they can be optimized.

We held the first ever MySQL Camp "un-conference" last week and it turned out to be a great success.  Kudos to Jay Pipes from our Community team for putting together this great event. There were over 200 registered attendees contributing ideas, sharing best practices techniques and generally geeking out on MySQL.  It was great to have attendees from some of the heavy-duty MySQL users like FaceBook, Google, Yahoo, YouTube, Flickr, SixApart, AdBrite and many others mixing in with key developers, consultants and SEs from MySQL.  We also had a few of our partners there including Hyperic, Proven Scaling, Solid, Zmanda, Zimbra and even Ken Jacobs (" …

A great post by Pete Lacey about SOAP and the problems one WILL encounter when trying to use it and understand it. Please someone make it go away!

My initial posting about using Zeroconf host names and Virtual Appliances on wasn’t quite complete…

It should be added that in order for Zeroconf-assigned host names (ie. in the form of https://mysql.local.) to resolve on Windows, it is necessary to install Apple’s Bonjour package.  Without this, the system is unable to resolve Zeroconf host names.

For modern Linux distributions, the nss-mdns GNU Name Switch Service (NSS) plugin is necessary …

MySQL Connector/ODBC is our next generation ODBC driver which allows access to the MySQL server using the ODBC standard - a cross-platform, cross-database C Call Level Interface. This version is being released to get community feedback but is NOT suitable for production environments. It is now available in binary form from the Connector/ODBC download pages at http://dev.mysql.com/downloads/connector/odbc/5.0.html and mirror sites (note that not all mirror sites may be up to date at this point of time - if you can’t find this version on some mirror, please try again later or choose another download site.)

Install Notes

Please uninstall any existing Connector/ODBC v5 before installing this version.

Changes

• FIX: length now used when handling bind parameter (needed in particular for …

At our MySQL Camp Jay and Brian pitted off in the Umbrella Joust. Not sure if there was a winner, or a looser, but in the end no blood was split (except Leslie, but that’s another story).

See these and more camp photos at Flickr.

New Report From The 451 Group Serves as a Practical Guide for Understanding and Calculating the Financial Benefits of Open Source, The 451 Group (Press Release)

Intalio Releases Most Standards-Compliant BPMS, Intalio (Press Release)

Palamida Announces Product Enhancements to Help Companies Leverage Sun’s Decision to Open Source Java Technology, Palamida (Press Release)

OASIS Forms Committee to Standardize Content Analytics Complementary Open Standards and Open Source Efforts Launch, OASIS (Press Release)

…

Zmanda specializes in backup and recovery solutions. First they gave the world Amanda, and now they've given MySQL users a new reason to rejoice with the launch of Zmanda Recovery Manager (ZRM) for MySQL. I recently got to speak to Paddy Sreenivasan, the Vice President of Engineering and co-founder of Zmanda Inc., amidst his busy schedule, about what they do and why MySQL users should be jumping towards ZRM for MySQL for all their backup & recovery needs.