"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
Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.