3

Can someone tell me which mysql version provides better performance for magento 1.9.1?

Mysql 5.5 or 5.6? Thanks

  • obviously version is not the problem, configuration is. – user2857 Jun 1 '15 at 23:25
  • Vito, just wanted to check in to see if you were able to find the answer you were looking for, let us know if we can provide any additional info! – Bryan 'BJ' Hoffpauir Jr. Jul 19 '15 at 21:26
4

As in most cases, it depends quite specifically on the version you're running, but according the Official Magento CE User Guide for v1.9.1, (p.12) it is a System Requirement that you run

Database MySQL 5.6 (Oracle or Percona)

This guide also confirms the same point: although it may be POSSIBLE to run Magento 1.9.1 on MySQL versions prior to 5.6, it is recommended to use 5.6

Although there has been some discussion about the specific tuning parameters needed, and the differences you may encounter if running MySQL on Amazon Web Services RDS, the general consensus seems to support that 5.6 will AT LEAST double the performance of 5.5, with Oracle claiming it's 230% faster on read workloads (over 3x). I'm not sure I'd give their marketing literature the same weight as data-driven benchmarks, but there should be no doubt - you should be running MySQL 5.6 if it's at all possible.

You do need to take absolute performance statements with a grain of salt because of the myriad of tuning options available and massive variances possible between environments. But the overwhelming consensus seems to support that you should be running 5.6 if possible with your webhost.

I'd also recommend you take the time to really dig into Ben Lessani's incredibly thorough deep dive into a similar question. He notes that one of the first things you need to do is define "performance" specifically:

Do you mean the page load time for a single user, or the overall capacity/total concurrency? The two are very distinctly different - and not strictly related. It is entirely possible to have a fast store with limited capacity; or a slow store with lots of capacity.

So when addressing either type of performance:

  1. Single user perceived page load time
  2. Total capacity/concurrency

You have to tackle each independently with their own solutions - especially since each have their own bottlenecks.

There is no easy way to answer this question, not if you want to truly address the issue of performance / scalability and the inevitable tradeoffs that pursuing those objectives may entail.

  • Thanks for the edits, Ben. And sorry I mangled your Last Name in my original answer so terribly :) – Bryan 'BJ' Hoffpauir Jr. Jul 1 '15 at 0:16

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.