CODEWITHSUNDEEP
mysqlinnodbmyisam
Galbert
Galbert

Reputation: 227

Does changing MYSQL table engine from MYISAM to INNODB can cause a data corruptions?

I have a simple question. I have a mysql databases. I have 2 tables, that uses MYISAM, I want to change to INNODB, one of the table has 1.000 rows, if I do this this change, is there a risk that it will cause any corruption of my data/rows?

Upvotes: -1

Views: 91

Answers (1)

jmvcollaborator
jmvcollaborator

Reputation: 2495

The two main advantages to switch to InnoDB are reliability and scalability. Also InnoDB is more granular due to row level locks while MyISAM supports table level locks. Crash recovery in InnoDB is a way better. But bear in mind that it can cause some headaches

I would strongly suggest to check official docs here and here

Upvotes: -2

Related Questions