Wordpress & InnoDB

Not for 'how-to' coding questions but PHP theory instead, this forum is here for those of us who wish to learn about design aspects of programming with PHP.

Moderator: General Moderators

Post Reply
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Wordpress & InnoDB

Post 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.
User avatar
Eran
DevNet Master
Posts: 3549
Joined: Fri Jan 18, 2008 12:36 am
Location: Israel, ME

Re: Wordpress & InnoDB

Post 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.
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Re: Wordpress & InnoDB

Post 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.
Post Reply