INNODB storage engine: notes

Advantages

  • transactions
  • row-level locking
  • foreign key constraints ! and behaviour
    ON [DELETE|UPDATE] [RESTRICT|CASCADE|SET NULL|NO ACTION|SET DEFAULT]
Disadvantages

  • INNODB does NOT support FULLTEXT index (MyISAM does)
  • not initial value for auto_increment keys