I have uploaded my three presentations from the 2010 MySQL Users Conference in Santa Clara, California which was my 5th consecutive year appearing as a speaker.

• IGNITION – MySQLCamp for Oracle DBA – Volume I
• LIFTOFF – MySQLCamp for Oracle DBA – Volume 2
• 10x Performance Improvements – A Case Study

A full history of my MySQL presentations can be found on the Presenting page.

…

I haven’t been blogging much about the changes in MySQL for a while. But the MySQL and InnoDB engineers have been doing a ton of work over the last couple years, and now it’s seeing the light of day, so it’s time to offer words of congratulations and appreciation about that.

I was holding my breath for a big-splash 5.5 GA announcement at last week’s conference, but I was wrong. Still, there’s a lot to talk about in 5.5, with a dozen or more substantial blog posts from the InnoDB and MySQL teams alone over the last week or so! Here are a few choice tidbits of the good, the bad, and the ugly.

InnoDB is the default storage engine

“No big deal,” I thought. “Serious users do this anyway.” But then Morgan Tocker pointed out that it really is a big deal. This is going to cause a sea change in the way MySQL is …

As far as I know, nobody who was at the MySQL User Conference and lives in Europe has made it back home yet!

Please leave a comment on this blog as soon as you get home. I am interested to know...

My flight was yesterday, so I have the worst prospects. I am booked on a flight for next week Wednesday (10 days delay)! No joke! :(

Randy Kennedy at the New York Times covered the Seven on Seven event and my collaboration with Evan Roth which resulted in Surprise Me on WordPress.com. There was also coverage in BusinessWeek. Hat tips to Niall and Noel for some day-of bug fixes and debugging.

I haven’t been blogging much about the changes in MySQL for a while. But the MySQL and InnoDB engineers have been doing a ton of work over the last couple years, and now it’s seeing the light of day, so it’s time to offer words of congratulations and appreciation about that. I was holding my breath for a big-splash 5.5 GA announcement at last week’s conference, but I was wrong.

I’ve been keeping my eye open and my ears to the ground with regards to the Oracle purchase of MySQL. I was waiting for the O’Reilly conference to get a better idea of what might happen to MySQL in the future.

After watching the presentations from the conference I can conclude that from what I saw - people are still generally worried about MySQL.
Those people are divided into two camps. On the left side you have the people that say, Oracle has a lot of money and lets make the best out of a bad situation. On the right side, you have people saying that we should band around MySQL and continue adding to the community version.

What I understood from Oracle is that they would like to continue supporting MySQL and they would like to move MySQL into their stack. Meaning that Oracle would like to be the main provider of backup, monitoring and support - the areas where you can make money around MySQL. You can think of …

I got a couple of questions and comments about OpenSQL Camp in the past week, and I thought it would be worth noting down the history, because I think there is some difference in perception and memory about this series of events. The following is only my point of view.

What is OpenSQL Camp?

I can say what I had in mind when I created the original event, but this is bigger than me, so I don’t get to dictate anything. I wanted a free technical event created entirely by and for a community of open-source databases, in an inclusive sense. Not created or heavily influenced by someone employed by a corporation whose job title includes the word “Community,” but really by a community themselves. There’s nothing wrong with Community So-And-So employed at a corporation, but they are by nature a liaison with that company, and it’s not the same thing. My original …

Answering questions asked on the site.

James asks:

Your series on hierarchical queries in MySQL is tremendous! I’m using it to create a series of threaded conversations.

I’m wondering if there is a way to paginate these results.

Specifically, let’s say I want to limit the conversations to return 10 root nodes (parent=0) and all of their children in a query.

I can’t just limit the final query, because that will clip off children. I’ve tried to add LIMITs to your stored functions, but I’m not getting the magic just right.

How would you go about doing this?

A quick reminder: MySQL does not support recursion (either CONNECT BY style or recursive CTE style), so using an …

I (Peter Gulutzan) gave a Performance Schema talk at the O’Reilly MySQL User Conference are available at oreilly.com. My colleague Jimmy Yang gave a talk about InnoDB monitoring which was about 40% devoted to Performance Schema; his slides too are available at oreilly.com.
Edward Screven’s keynote talk also mentioned Performance Schema. I had a few minutes to show it during the “Demo of all the Big New Features” talk which I co-presented with Konstantin Osipov.

The rest of this blog is the text of the talk that I planned for the slides. Naturally it came out differently due to time constraints and questions.

User Conference Slides: …

Typography for Lawyers is a cool use of WordPress for a mini-book. Hat tip: Scots Law Student.