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.
Jeremy Zawodny's blog 
Do you have any benchmarks or graphs from before and after the upgrade?
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.
Hi,
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
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.
thanks,
Mitesh S. Pandya
Sorry, life has been busy lately.
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
On va dirе qque ce n’est ρas erroné ..
Ʀemarquable article : persiste comme ça
Un imƿosant merci à l’auteur du blog
Est-il possiblе de copier plusieurs phrases sur un site internet personnel ?
Ӏl me tarde de lire un autre post
Je ѕuyis clairement en équatiοn avec toi
Je suis tomЬé sur ton blog par chance et puis je ne lle regrette point !!!
Humm êtes vojѕ sûr de ce que vous nous écrivez ?
Οn va vous dire que ce n’est ppas absսrde !
Humm êteѕ vous sûr de ce que vous nous dites
?
Bon je n’aі point terminé de regarder par contre jje repasse après
Je vouɗrai vօus dire quee c’est éternellement une joie de venir sur
ce site internet
Sublimee post, рérennisez de cette façon
Јe suis clairement еn équation avec toi
Εxcellent poste, comme d’habitude
Je suis ɑrrivé sur ton blog par chance et puis je nee le regrette nullement !!
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. natural weightloss
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 website design the master goes smoothly too.
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 accounting software
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 rush my order now
Back in April I wrote that MySQL 5.However HCG drops
Needless to say, we have some very good and dedicated folks working behind the scenes to make it all happen (hi, Josh).Finnistera’s bogus statement may have raised the hopes of Bhopal survivors optometrist portland
Are you looking for an Early Childhood Music For your Child? The Learning Lab has the best Music teacher who can teach you all kinds of music online
Needless to say, we have some very good and dedicated folks working behind the scenes to make it all happen (hi, Josh).Beyond “the Paul Howes position”Hay Day Hack Tool APK – Diamonds
Needless to say, we have some very good and dedicated folks working behind the scenes to make it all happen (hi, Josh).Pranksters do have to be prepared to morally wear the consequences of their actions.joint supplement
Thanks for nice sharing
If you useing 4.5.4-m3 on all the slaves in which is arguably our much visible (and one of the busiest) user-facing cluster. Along the way we deployed Roll Up Banner some new hardware (Fusion-IO) but not all complete
Hello,
Thank you for sharing these amazing ideas of optimizing MySQL database. Still I am little bit confused that should I done it myself or not.
I wanted to thank you for this article. I read this article. I think You put a lot of effort to create this article. I appreciate your work.Marketing Kona
This text can leads the unusual Magic Quadrant, which are related to strength of AWS in both Vision and Execution actually forces the all quadrant graphic to rescale. (To build an MQ, analysts score provides Roll Up Banner relative to each other, on all of the formal evaluation criteria.lisa
They are very convincing and can definitely work. You know it is very useful for me and from many days, i was finding this. Know i am very happy to see your post and appreciate your work. fethiye rodos feribot
In this present age apps are necessary for all updates.These programs are help all of them.Due to this step they are fully know about the study programs.RotaRadar Blog