Home > datacenter, MySQL > MySQL 5.5.4 looks awesome.

MySQL 5.5.4 looks awesome.

April 15, 2010

Been at the MySQL conference the last few days, and I have to say, I’m really blown away by MySQL 5.5.4‘s improvements.  Last year I keynoted and I begged Oracle on stage to realize that MySQL and InnoDB under one roof represented opportunity.  It’s clear they heard the community – this is some serious progress, and right when we needed it.

Jeremy Zawodny’s blog post covers most of the stuff I’m really excited about, and there are some great detailed technical slides here and here, but I wanted to go into a little more detail on one important improvment:  We’ve been plagued by MySQL’s undo slot limits for an awfully long time.  Basically, you could have 512 INSERT transactions and 512 UPDATE transactions running at once, for a grand total of 1024.  If you use INSERT … ON DUPLICATE KEY UPDATE, though, it takes two of those spots, meaning you get 512 concurrent transactions.  On modern hardware, it’s trivially easy to hit this limit.

I’ve had an Enterprise support ticket open for years on the issue, there’s been a MySQL bug for a long time, and there was basically no movement.  In fact, I’d gotten so frustrated about this issue, I’d basically decided this year was our last year of Enterprise MySQL support.  It was one of the sole reasons we paid for support for the last few years – the promise that a fix was just around the corner.  I felt good about voting with my dollars, and contributing back to a core technology we depend on, but enough was enough.

Lo and behold, it’s fixed!  You can now have a whopping 128K transactions in flight.  Best of all, it’s far more performant than it used to be!  And craziest of all?  If you run 5.5.4 on a database, then roll back to some older release, the change still takes effect.  Backwards bug and performance fixing – that’s a new one on me.

THANK YOU ORACLE!

Shameless plug – we’re hiring. And it’s a blast.

Categories: datacenter, MySQL Tags: , , , ,
  1. James Day
    April 16, 2010 at 12:04 pm | #1

    Don, though do note that at present backwards compatibility has only been tested as far as plugin 1.0.6. Testing for earlier versions is on the to do list but no guarantees yet that it would apply to say 5.0.

    James Day, MySQL Senior Support Engineer, Oracle

  2. April 29, 2010 at 5:17 am | #2

    I was just thinking if Oracle will be giving mysql update for free in the future? I am afraid of mysql will be no longer for free

  3. Nate Wiger
    April 29, 2010 at 9:03 pm | #3

    Hey Don – it’s Nate from CAB. Great post, I’m with you, the newest MySQL improvements are really awesome. Hopefully they will help eliminate some of the FUD around DB’s as a whole. NoSQL is compelling for certain aspects of infrastructure, but RDB’s are invaluable and we all need to continue supporting and investing in them. Kudos to Oracle for investing in MySQL in a way Sun (my first employer) never did.

  4. May 15, 2010 at 5:19 am | #4

    What’s the best way to go about learning MySQL? I’ve tried reading up on some lessons on the internet, but it hasn’t really helped much. Would you recommend taking a course?

Comments are closed.
Follow

Get every new post delivered to your Inbox.

Join 33 other followers

%d bloggers like this: