MySQL 5.1 or MySQL 5.1, which one gives a better performance

development

Linode 720

Cpanel VPS optimized

Apache + Eaccelerator + memcache + mod_Deflate

There’s an upgrade option in Cpanel i can choose from, keep using mysql 5.0 or upgrade to mysql 5.1.

Which one gives a better performance for magento? Some benchmarks say mysql 5.0 is better, others say mysql 5.1 is the one to go with.

Any experiences here? Did anyone benchmark 5.0 and 5.1 and what were the results?

It's my understanding that the only real major difference between 5.0 and 5.1 is the ability to do partitioning.

http://dev.mysql.com/doc/refman/5.1/en/ … shell.html">http://dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.html

There's nothing mentioned there about major performance differences.

MySQL 5.1 offers many benefits, while performance is either slightly less, equal or much faster.

Benefits it offers:

Besides that, i'd suggest you use on of the newer and more performant options: Either MariaDB, OurDelta's MySQL build or Percona's MySQL build.

If you use InnoDB, I believe that there are plugins for MySQL 5.1 that are quite a bit faster than the built-in InnoDB engine.

Description

Please enter an answer

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

**I am bold** I am bold

*I am italicized* I am italicized