CODEWITHSUNDEEP
mysqlinnodbmyisam
Andrew Neelands
Andrew Neelands

Reputation: 438

What complications should I look out for when converting tables to InnoDB?

I'm having trouble with a liferay installation that is suddenly (without any code modifications) failing with "dulplicate id" errors. We've identified that the issue may be solved by changing the mysql engine to InnoDB.

I'm planning the change now, but i'm not sure what complications are likely in the process.

I've checked for full text indexes mentioned in this question

Converting table from MyISAM to INNODB

Are there any other likely problems I should

Upvotes: 1

Views: 219

Answers (2)

Mike Sherov
Mike Sherov

Reputation: 13427

Andrew, there are lots of differences between MyISAM and InnoDB, the least of which is the fact that they are controlled by different configuration options in the MySQL conf. There is also the fact that InnoDB is ACID compliant unlike MyISAM. Also, backups cant be done with just copying MYI and MYD files anymore. Then there is the matter of different size requirements, different index types, and different performance characteristics between the two engines.

Even though I like InnoDB is most cases, may I ask what leads you to believe that a switch to InnoDB will solve your problem? and perhaps you should be seeking an alternate answer to THAT question instead of this one?

Upvotes: 0

wallyk
wallyk

Reputation: 57784

Biggest problem is not having a backup of the database before conversion. With a backup, you can experiment all you like. Naturally you're doing this on a test database, right? (Not a production database.)

Upvotes: 1

Related Questions