[wp-hackers] innodb vs myisam
frank at bueltge.de
Mon Mar 28 18:09:15 UTC 2011
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.
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>
> > 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.
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
More information about the wp-hackers