Saturday, 20 October 2007

New Blog Layout

Our Web team has just installed the newest Wordpress MU edition for blogging, and Akismet for spam fighting -- plus a new layout. I'm already relieved from lots of spam, which feels great!

I'd like to make a couple of remarks on the banner, which has pictures by my two favourite portrait photographers, James Duncan Davidson and Julian Cash.



The two leftmost pictures are by Duncan, from panels at the last two MySQL Users Conferences. The first one is from the Clash of the DB Egos at the MySQL Conference and Expo 2007 (no, I am not chewing my nails or eating sweets -- I am blowing a whistle to keep the egos apart), and the second one from the 2006 conference panel interviewing the MySQL founders.

The rightmost one is by Julian, who regularly goes not only to Burning Man but also to Open Source conferences (such as ours 2006). Julian's passion for fisheye in turn has inspired myself to buy an 8mm fisheye myself.

Thank you, Duncan and Julian, for your great photography at various Open Source conferences, and for being a great inspiration for myself as an amateur photographer!

MySQL 5.1 errata sheet

As indicated last week, we have decided to start producing a condensed report of outstanding issues in our current development release, MySQL 5.1.



This list is now available as part of our reference manual at dev.mysql.com/doc/refman/5.1/en/open-bugs.html.

The list is updated daily based on the then-current status in our bug database.

The purpose of the list is to make it possible for our users to more easily make an informed judgement about whether our development release is ready for them to test and use. While the corresponding bugs have already been openly and publicly available for searching in our bug database, I hope this list is easier to navigate, as it is compiled into one web page that is sorted into categories such as


  • C API

  • Client

  • Connector/J

  • Server: Backup

  • Server: Charsets

  • Server: Cluster

  • Server: Events

  • Server: I_S (Information Schema)

  • Server: InnoDB

  • Server: Partition

  • Server: RBR (Row-based replication)

  • Server: Replication



Hence, if you're into using Row-based replication, read through the corresponding section. Our goal is to make it easy for you to know whether any of the outstanding bugs are relevant for you.

The list also contains target fix releases (with 5.1.23 currently being the next one), and links directly into the bugs system for detailed inspection of the bug description.

Friday, 19 October 2007

Country-specific MySQL Conferences

MySQL UC JapanLocal MySQL offices have hosted country-specific user or customer conferences in a number of countries this autumn:


and we're continuing this with two more conferences


after which the following big one is The Big One, i.e.


We just concluded yesterday's German Kundenkonferenz, with a packed (despite a local transport strike) main room in the Hilton. For me, the highlight was moderating the Storage Engine panel with Ralf Gebhardt, Jan Kneschke and Kai Voigt as vocal, knowledgeable and fun panelists in front of a very interactive audience. "With delight and a dash of horror" (adapted from a Swedish saying) I'm looking forward to moderating next week's equivalent French panel. I anticipate that the my preparations will not be limited to a casual look in my Swedish-French dictionary.

The London, Munich and Paris event are/were similar in nature, with content of both technical and decision-maker nature. The Milan launch is lighter on the technical side, mainly an opportunity to meet the team.

Finally, you've still got a good week, until 30 October 2007, to propose sessions for the 2008 UC in Santa Clara.

Wednesday, 17 October 2007

MySQL 5.1.22 is out



A good two weeks ago, MySQL 5.1.22 was released. MySQL 5.1 is a new release of MySQL Server, with new features like


  • partitioning (likely the top feature in 5.1)

  • events ("crontab" triggers in the database)

  • row-based replication

  • table logs

  • some XML functions



and also with major bug fixes, such as the AUTO_INCREMENT table-lock contention in InnoDB (fixed now in 5.1.22), as well as early indications of performance improvements of up to 20 % - 40 % on dual cores in some scenarios.

Jay Pipes has written an overview that compresses all of the pointers to 5.1 into one article, MySQL 5.1 Article Recap. I recommend you read it. I also recommend the manual section What's New in MySQL 5.1.

With 5.1.22, MySQL also changed the maturity state to "RC", Release Candidate. Looking at our own Support Policies, Release Candidate (aka Gamma) release is defined as follows:

Release Candidate binaries, also known as Gamma releases, are believed stable, having passed all of MySQL's internal testing, and with all known fatal runtime bugs fixed. However this release has not been in widespread use long enough to know for sure that all bugs have been identified.

However, we recognise that this particular RC does not fit the definition exactly. We still have some fatal runtime bugs left. We are producing an errata list of these, and expect to have the list ready and published on by 23 Oct 2007. We know that we should have published this list together with the RC itself, and we are now working as fast as we can to fix this.

We know we have thus released our RC too early according to our own standards, and we are doing our best to fix it. We apologise for any inconvenience/miscommunication and are working on improving our internal guidelines to ensure it doesn't happen again.

That said, 5.1.22 is a great release, one that we're proud of, and very likely worthy of your attention!

Thursday, 4 October 2007

Users Conference 2008 Call for Papers

This is a friendly reminder that we have opened our Call for Participation for the MySQL Users Conference 15-18 April 2008 in Santa Clara, California.



Yes, 15 April next year may seem far away. But 30 October this year isn't. And that's when the Call for Paper closes.

Some UC 2008 highlights:

  • Conference theme is "Harnessing the Power of MySQL"

  • We expect to bring over 1,500 open source and database users together

  • Over 100 sessions, geared toward many skill levels (novice to expert)



Consider to present, especially if you belong to one or more of the below categories:

  • Developer or DBA at an established or up-and-coming company

  • Business manager with purchasing authority

  • Strategist, business developer, CTO, CIO

  • Technology evangelist, scout, entrepreneur pushing their enterprise boundaries

  • Researcher, academic, programmer



To learn how to phrase your submission, click on the below picture and remember


  • Be creative! Conference participants want to hear about real-world scenarios using MySQL, about ways they can be more productive, or write better code. Please submit original session and tutorial ideas that focus on hands-on instruction and real-world examples.

  • Be descriptive! Include in your proposal as much detail about the planned presentation as possible. The more we know about what you plan to present, the better.

  • Be specific! Proposals which are vague or cover too much material are unlikely to be accepted. If you think your proposal covers too much of a topic, consider submitting two proposals which split the material into different sessions.



Monday, 1 October 2007

Free the falcons!

Last Sunday, just before the MySQL Dev Meeting in Heidelberg ended, we went to see a falconry. Strictly speaking, the German Raptor Research Centre isn't a falconry (which is a commercial venture for raising falcons), but a privately funded research station dedicated to the preservation of birds of prey, or "Eagles, vultures & co" as they say on their home page at deutsche-greifenwarte.de. Their actions over the past 30 years have given concrete results for many raptors, such as the eagle-owl ("Uhu" in German and Swedish), which is no longer on the list of endangered species in Europe. The German Raptor Research Centre has successfully set out 37 sea eagles (Seeadler, havsörn) in Central Europe, an admirable investment in nature which now including second and third generation offspring has grown to about 400 eagles.



Through a donation in part from MySQL GmbH, in part from MySQL AB, but mostly from individual MySQLers attending the Heidelberg Dev Mtg, Jim Starkey and I had the pleasure of handing over a cheque of 4500 euros to Bettina Fentzloff, the wife of the research centre's founder, Claus Fentzloff, who brought another falcon for the audience of MySQLers to admire. I hope the donation will enable the Deutsche Greifenwarte to give freedom (as in speech) to many birds of prey in Europe and worldwide!



Jim, as the creator of the Falcon engine, seemed to have a good hand also with the namesake birds.