[wp-hackers] innodb vs myisam

[Frank Bueltge]

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.

Best regards
Frank


On Mon, Mar 28, 2011 at 7:59 PM, Otto <otto at ottodestruct.com> wrote:

> On Mon, Mar 28, 2011 at 8:15 AM, Andrew Gray <andrew at graymerica.com>
> wrote:
> > I just wanted to let all the folks on this list know, that I fixed a
> client site that was getting horrible performance by switching the post and
> post meta tables to Innodb from MyIsam.
>
> I also noticed improved performance from switching the comments,
> commentsmeta, and options tables to InnoDB as well. Changing the
> options table seemed to increase overall performance everywhere,
> albeit only slightly. The options tables tend to get written to a lot
> by normal use. Comments showed a good amount of improvement because I
> get a lot of comments on my sites. :)
>
> InnoDB has gotten to the point where it's just a better default than
> MyISAM for most cases. I would only use MyISAM for a table that is
> large and often read-only.
>
> -Otto
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>