MySQL engine type

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).