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).
One thought on “MySQL engine type”
MyISAM HEAP nnoDB and Berkley DB