[wp-hackers] innodb vs myisam

[Paolo Tresso]

Il giorno 28/mar/2011, alle ore 20.09, Frank Bueltge ha scritto:

> I notice a performance boost on comments, if i use innodb.
> And on posts, esspecilly pages it is not better, same values.
> 
> On myisam you have an blocking on change/write access on tables, innodb has
> this not - was create for banking-access, is more secure in the idea. But
> myisam can compressive different access and innodb write datas on harddisc
> and so it is possible, innodb is slower.
> 
> But i think, mySQL 5.5 has innodb as default and is faster than older
> version, maybe you can test with a newer version from mySQL.

I wonder if anyone tested WP with Percona Server (a MySQL replacement with a powerful innodb-based engine and many other great patches, built by one of the major MySQL consultance firm in the world..). 

I'm just trying to compile it and have a test run but I'd love to know if someone had the same thought..

More info on it: http://www.percona.com/software/percona-server/

Regards,
Paolo (aka pixline)