Tuesday, March 29, 2011

MyISAM Or InnoDB MySQL engine?


MyISAM limitations

No Foriegn keys and cascading deletes and updates
No rollback abilities
No transactional integrity (ACID compliance)
Row limit of 4,284,867,296 rows
Maximum of 64 indexes per row


InnoDB Limitations

No full text indexing
Cannot be compressed for fast, read-only

No comments:

Post a Comment