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

One thought on “MySQL engine type

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s