Alex Rivera | Logout

Mysql Server 5 vs 6 vs MariaDB

Asked 2011-09-25T17:11:29.787
14

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?

mysql mariadb
Edit
Report

1 Answer

14

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.

answered 2011-09-26T16:54:47.467

Your Answer