Archives: 12/09/2010

MYISAM vs INNOBD

The 2 major types of table storage engines for MySQL databases (/var/lib/mysql) are InnoDB and MyISAM. To summarize the differences of features and performance: InnoDB is newer while MyISAM is older. InnoDB is more complex while MyISAM is simpler. InnoDB is more strict in data integrity while MyISAM is loose. InnoDB implements row-level lock for…

Go Top