Mysql Server 5 vs 6 vs MariaDB [closed]
开发者_StackOverflow
Want to improve this question? Update the question so it's on-topic for Stack Overflow.
Closed 9 years ago.
Improve this questionHave 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.
精彩评论