Monday, June 8, 2009

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

No comments:

Post a Comment

 

PHP and tips|PHP