Lecture 4: CCIS2701 DB Design: Table Engines

CREATE TABLE ...... ENGINE = whatever
MyISAM
- Fast
- non-transactional
- high-speed
- machine architecture independent
- 64 indexes per table
- 16 columns per index
ACID: Atomicity, Consistency, Isolation, Durability
InnoDB
- ACID compliant: Transaction-safe
- row-level locking
- supports foreign keys!