I have a working stable Magento community website using Mysql 5.1 for many years now with no problems.

If I upgrade Mysql to 5.5 will I have problems with my Magento website? Or should I just stay with Mysql 5.1 and not take a chance of ruining a working stable website?

I know that Mysql 5.1 default engine is MyISam and Mysql 5.5 the default engine is InnoDB. Will this cause problems?

I looked at my present Magento datbase and all but 3 items are TYPE InnoDB, but the default engine is MyISam.

Thanks for helping me!


There should not be a foreseen problem with the upgrade:

Also consider Percona as an alternate, Percona has some nice InnoDB optimizations and tools.

  • Thank you for your answer. I will be updating to MySql 5.5 and let you know how it goes! – Techp Feb 16 '15 at 10:54
  • 1
    Update to MySql 5.5 completed and Magento is working perfectly!! THANKS!! – Techp Feb 16 '15 at 13:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.