Mysql Server 5 vs 6 vs MariaDB [closed]

Closed. This question is off-topic. It is not currently accepting answers.

---

开发者_StackOverflow

Want to improve this question? Update the question so it's on-topic for Stack Overflow.

Closed 9 years ago.

Improve this question

Have a simple question here. I've a database with around 1 billion records, a server with 200GB of ram to handle it.

What do you suggest for best performances? Mysql 5, Mysql 6 or MariaDB?

---

MariaDB 5.3 should give you the best performance:

• It uses the XtraDB (InnoDB improved) storage engine from Percona as default.
• The optimizer is greatly improved to handle big data.
• Replication is a magnitude faster in MariaDB if you have lots of concurrent updates to InnoDB.

See http://kb.askmonty.org/en/what-is-mariadb-53 for a list of features.