InnoDB
Optimizing MySQL and PHP
2024-11-25
21
•
Transaction-capable
•
Row-level locking
•
MVCC architecture
•
Standard part of 4.0 (available in 3.23)
•
Great for balanced read/write usage
CREATE TABLE order ( ... ) TYPE = InnoDB; ALTER TABLE address TYPE = InnoDB;
BDB
•
Transaction-capable
•
Page-level locking
•
Built on top of Sleepycat Software's Berkeley DB
•
Part of MySQL Max