Page 1 of 1

Wordpress & InnoDB

Posted: Tue Jul 27, 2010 12:22 am
by Benjamin
Does anyone here have any experience converting the Wordpress database tables to InnoDB? I'm thinking about converting all the tables, except for the tables that require fulltext indexing of course, to InnoDB. I would like to do this so I can take advantage of transactions.

Maybe somehow emulating transactions would be acceptable, but that would require much more code I imagine.

I'm thinking that I could get a small performance boost out of the conversion on high traffic sites as well due to a reduction in table locks.

Re: Wordpress & InnoDB

Posted: Tue Jul 27, 2010 3:33 am
by Eran
I don't think you'll see much change converting wordpress to InnoDB. As far as performance, table locks are mostly a non-issue for an application like wordpress, where almost all queries are SELECT queries that don't use locks.

Re: Wordpress & InnoDB

Posted: Tue Jul 27, 2010 4:20 am
by Benjamin
Well I suppose you're right. It would be nice to be able to use transactions for some of the things I am building, but it's not necessary.