Linux Today: Linux News On Internet Time.

NewsForge: MySQL Migration: MyISAM to InnoDB

Jul 20, 2005, 07:00 (2 Talkback[s])
(Other stories by Keith Winston)

"The MySQL database is unique in that it offers multiple storage engines. The SQL parser and front end interfaces are separate from the storage engines, so you can choose among nine low-level table formats the one that suits your application best. I recently needed to convert a production application from the default indexed sequential format, MyISAM, to InnoDB. Here's my no-hassle guide to performing the conversion.

"Why would you want to convert an existing MySQL database from MyISAM to InnoDB? While the MyISAM format has low overhead and generally the fastest performance among MySQL storage engines, it does not have advanced features like transactions, rollbacks, and row-level locking..."

Complete Story

Related Stories: