Storage engines decide how and where the data is stored and in which way. MySQL storage engines include both those that handle transaction-safe tables and those that handle non-transaction-safe tables
MySQL supports following storage engines.
MyISAM Storage Engine
InnoDB Storage Engine
MERGE Storage Engine
MEMORY (HEAP) Storage Engine
BDB (BerkeleyDB) Storage Engine
EXAMPLE Storage Engine
FEDERATED Storage Engine
ARCHIVE Storage Engine
CSV Storage Engine
BLACKHOLE Storage Engine
One may choose a storage engine depending on the development requirement.
For example – MyISAM is a disk based storage engine. Aiming for very low overhead, it does not support transactions where as InnoDB is also disk based, but offers versioned, fully ACID transactional capabilities. InnoDB requires more disk space than MyISAM to store its data, and this increased overhead is compensated by more aggressive use of memory caching, in order to attain high speeds. The CSV storage engine stores data in CSV format.
Thats some basics about storage engines in MySQL !!
lnteresting, can you elabarate the post with some examples and detailed explanation , it will really help us