The multiple storage engine architecture allows applications to take advantage of the particular strengths of each engine, allowing for much finer grain control. Within a single database, you might have some tables using MyISAM for its speed, small memory footprint and fulltext capabilities, while others use InnoDB for its support of transactions and foreign keys. You can even roll your own storage engine, if you want to use MySQL as a front end to your proprietary data format.
Dig Deeper on Linux servers
Related Q&A from Scott Noyes
A MySQL expert offers a workaround for the lack of syntax support for full outer joins. Continue Reading
The differences between MySQL Enterprise and MySQL Community. Continue Reading
An expert describes compares trigger functions in Oracle, MySQL and Microsoft SQL Server. Continue Reading