MySQL 5.5.4-m3 in Production

Back in April I wrote that MySQL 5.5.4 is Very Exciting and couldn’t wait to start running it in production. Now here we are several months later and are using 5.5.4-m3 on all the slaves in what is arguably our most visible (and one of the busiest) user-facing cluster. Along the way we deployed some new hardware (Fusion-IO) but not a complete replacement. Some boxes are Fusion-io, some local RAID, and some SAN.  We have too many eggs for any one basket.

We also converted table to the Barracuda format in InnoDB, dropped an index or two, converted some important columns to BIGINT UNSIGNED and enabled 2:1 compression for the table that has big chunks of text in it. Aside from a few false starts with the Barracuda conversion and compression, things went pretty well. Coming from 5.0 (skipping 5.1 entirely) we had some my.cnf work to do to take advantage of all the new InnoDB tuning (especially on the boxes with Fusion-IO cards and more memory). Hopefully switching the master goes smoothly too.

Needless to say, we have some very good and dedicated folks working behind the scenes to make it all happen (hi, Josh). Most of my involvement was initial testing, prodding, schema changes, and finding my.cnf options for the InnoDB tuning.

About Jeremy Zawodny

I'm a software engineer and pilot. I work at craigslist by day, hacking on various bits of back-end software and data systems. As a pilot, I fly Glastar N97BM and high performance gliders in the northern California and Nevada area. I'm also the original author of "High Performance MySQL" published by O'Reilly Media. I still speak at conferences and user groups on occasion.
This entry was posted in craigslist, mysql, tech. Bookmark the permalink.

23 Responses to MySQL 5.5.4-m3 in Production

  1. Ramoonus says:

    Do you have any benchmarks or graphs from before and after the upgrade?

  2. No benchmarks, sorry. The real performance gains are expected on the newer hardware so it would have been a pretty unfair comparison without a lot of extra effort.

  3. mitesh says:


    I am confused for latest stable version of mysql.

    mysql server 5.5.4-m3-log (community license GPL )is beta release or final/stable release.

    thanks ,
    Mitesh S. Pandya

  4. Mitesh says:

    Hi ,

    Are you inactive on this blog.
    Still I didn’t got any reply from you.
    If this is inactive blog jst mark on this page so next time any one can have idea that not to post on this blog.

    Please don’t mind.

    Mitesh S. Pandya

  5. I simply could not go away your site before suggesting that I really loved the usual info an individual supply for your visitors?
    Is gonna be back frequently in order to check up on new posts

  6. On va dirе qque ce n’est ρas erroné ..

  7. Ʀemarquable article : persiste comme ça

  8. ddl porno says:

    Un imƿosant merci à l’auteur du blog

  9. Est-il possiblе de copier plusieurs phrases sur un site internet personnel ?

  10. Ӏl me tarde de lire un autre post

  11. Je ѕuyis clairement en équatiοn avec toi

  12. Je suis tomЬé sur ton blog par chance et puis je ne lle regrette point !!!

  13. Humm êtes vojѕ sûr de ce que vous nous écrivez ?

  14. Jeune Salope says:

    Οn va vous dire que ce n’est ppas absսrde !

  15. Humm êteѕ vous sûr de ce que vous nous dites

  16. suceuses says:

    Bon je n’aі point terminé de regarder par contre jje repasse après

  17. rousse sexy says:

    Je vouɗrai vօus dire quee c’est éternellement une joie de venir sur
    ce site internet

  18. Sublimee post, рérennisez de cette façon

  19. Јe suis clairement еn équation avec toi

  20. Εxcellent poste, comme d’habitude

  21. Je suis ɑrrivé sur ton blog par chance et puis je nee le regrette nullement !!

  22. Boon post, рérennise de cette manière

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s