5 ms·
FWIW, in addition to MariaDB, there is Percona Server as well, and they are also maintaining a launchpad for the base MySQL code on Launchpad while Oracle negle
by falcolas 14y ago
FWIW, in addition to MariaDB, there is Percona Server as well, and they are also maintaining a launchpad for the base MySQL code on Launchpad while Oracle neglects that codebase.
http://www.mysqlperformanceblog.com/2012/08/16/where-to-get-a-bzr-tree-of-the-latest-mysql-releases/ http://www.mysqlperformanceblog.com/2012/08/16/where-to-get-...
- caseyf 14y agoI highly recommend Percona Server. especially if you are using SSDs or a mix of SSDs and regular disks.
- __Joker 14y agoCan you elaborate ?
- heretohelp 14y agoPercona has done a lot of work to enable MySQL to take advantage of SSDs, work that hasn't percolated into mainline or MariaDB.
- latimer 14y agoI've benchmarked all three and it seemed like the vast majority of the performance improvement on SSDs was due to the XtraDB engine which is included with MariaDB.
- heretohelp 14y agocoughs http://www.percona.com/software/percona-xtradb/ http://www.percona.com/software/percona-xtradb/
- latimer 14y agoYes you have to install it separately for MySQL but it's enabled by default in MariaDB so their work has in fact made it into MariaDB.
- caseyf 14y agoPercona Server has lots of improvements (some small things and others that are pretty essential for me) On the SSD front, the main ones are: * You can put the innodb doublewrite buffer on your spinning disks - that's the best place for it since it's heavy sequential writes. See section 2.2.2 here http://yoshinorimatsunobu.blogspot.com/2009/05/tables-on-ssd-redobinlogsystem.html http://yoshinorimatsunobu.blogspot.com/2009/05/tables-on-ssd... * The ability to tune various parts of innodb that were originally designed to perform well on regular disks - those with fast sequential access, slower random access, and no real wear considerations. See http://www.percona.com/doc/percona-server/5.1/scalability/innodb_io.html http://www.percona.com/doc/percona-server/5.1/scalability/in... Here's a recent post from Percona showing MySQL vs Percona server on an Intel 320 SSD: http://www.mysqlperformanceblog.com/2012/02/23/percona-server-vs-mysql-on-intel-320-ssd/ http://www.mysqlperformanceblog.com/2012/02/23/percona-serve... -- MariaDB is pretty nice too. Their team has introduced some sorely needed query optimizations (http://kb.askmonty.org/en/what-is-mariadb-53/#subquery-optimizations http://kb.askmonty.org/en/what-is-mariadb-53/#subquery-optim...) and it does include Percona's XtraDB. I haven't looked at MariaDB 5.5 to see how it compares to Percona Server 5.5. I put Percona Server into production last fall and MariaDB was still at 5.3 at the time.