Jump to content

What's the best way to convert from MyIASM to INNODB?

Recommended Posts

OK, after five years my forum as grown to the point where MyIASM is no longer cutting it. Both traffic and the total number of posts has increased to the point where a table lock or search can lead hitting cache hard.. I've been regularly throwing more RAM at it for years but that's not going to cut it, plus I want to use Sphinx.

I know how to convert it one table at a time but I'm looking for suggestions on how to script it so I can convert the whole db at once.

Any ideas?

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...