MYISAM VS. INNODB
| MYISAM | INNODB | |
|---|---|---|
| Transaction support | NO | YES |
| Data row locking | NO | YES |
| Foreign key constraints | NO | YES |
| Full text index | YES | NO |
| Table size | smaller | bigger(2 times) |
Advantage
MYISAM: space saving, faster
INNODB: higher security, support multi-table multi-user operation
Comments
Post a Comment