I am planning to change some large
MyISAM tables in my MySQL database into
This is because I am having performance problems where large and complex updates (updating a few million rows in one go) are stopping users from concurrently accessing that tables.
I understand that if I convert the table to InnoDB then the writes/updates will cause row locking rather than table locking.
If I do this, Will have have to review all my
SQL selects/insert statements, and my stored procedures, and make any changes due to the engine change, or will they all 'just work'?