MySQL table types

• HEAP tables; Fixed row size tables that are only stored in memory and indexed with a HASH index.
• ISAM tables; The old B-tree table format in MySQL 3.22.
• MyISAM tables; New version of the ISAM tables with a lot of extensions:
  • Binary portability.
  • Index on NULL columns.
  • Less fragmentation for dynamic-size rows than ISAM tables.
  • Support for big files.
  • Better index compression.
  • Better key statistics.
  • Better and faster auto_increment handling.
• Berkeley DB (BDB) tables from Sleepycat: Transaction-safe (with BEGIN WORK / COMMIT | ROLLBACK).