I often need to choose between MyISAM and InnoDB. Here is a little list for me for future reference.
- MyISAM supports fulltext searching, but does not support transactional processing.
- Fulltext searching: Match(), Against(), WITH QUERY EXPANSION, IN BOOLEAN MODE
- InnoDB is a transaction-safe engine It does not support full-text searching.
- In addition, MEMORY is functionally equivalent to MyISAM. The data is stored in memory (instead of on disk), thus is extremely fast (and ideally suited for temporary tables).