[wp-hackers] Percona Server and WordPress
kevinjohngallagher at hotmail.com
Fri Mar 9 17:22:39 UTC 2012
[people don't like it when i actually write things, so here's links with answer to your questions]
I also found this interesting:
> Date: Fri, 9 Mar 2012 11:22:02 -0500
> From: wp-hackers at thecodecave.com
> To: wp-hackers at lists.automattic.com
> Subject: Re: [wp-hackers] Percona Server and WordPress
> Oh interesting....
> I'd not heard of MariaDB before...
> "MariaDB is primarily driven by developers at Monty Program, a company
> founded by Michael "Monty" Widenius, the original author of MySQL"
> It's curious why these changes aren't added to the MySQL core if they
> make such a significant difference...
> Brian Layman
> On 3/9/2012 10:29 AM, Jeremy Clarke wrote:
> > We switched to http://mariadb.org/ rather than Percona Server, but the
> > underlying software is almost entirely the same, both are packages of all
> > the wonderful open-source patches that just don't make it into the core
> > MySQL. In either case, the really mind-blowing performance gains come from
> > XtraDB, which is the replacement for the core InnoDB engine of MySQL.
> > Preparing and implementing the switch was time consuming and there was some
> > brief downtime while me and an expert figured out the config changes to
> > make (there are a couple of config variables that needed changing to make
> > it work right) but otherwise the transition was smooth. No WP related
> > issues as far as I can tell, it's pretty much totally compatible in terms
> > of actual SQL.
> > The performance gains I got were tremendous. Load went from static around 6
> > to more like 2 and stopped spiking the way it did before. Our upgrade was
> > from MySQL 5.0.x. to the 5.1.x branch of MariaDB, so the actual MySQL
> > upgrade could have also played a part, but the change was so drastic I
> > believe it was XtraDB making the difference (the same kind of improvements
> > are described for people just switching within a major MySQL branch).
> > IMHO this is the future of MySQL. I hope the hosts of the world start
> > switching :)
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
More information about the wp-hackers