5 ms·
Could somebody please point me to a longer yet still intelligent comparison of MyISAM and InnoDB? Thx.
by mildweed 15y ago
Could somebody please point me to a longer yet still intelligent comparison of MyISAM and InnoDB? Thx.
- nerfhammer 15y agoShort version: MyISAM doesn't support transactions and only supports table-level locking, so a heavy concurrent read/write workload will bring it to its knees. Generally you shouldn't use MyISAM anymore unless you know what you're doing and have a specific reason for doing so. InnoDB is much more crash-safe, supports transactions, and can support concurrent read-writes using row-level locking. It's generally a much more advanced storage engine than MyISAM and it's what Oracle is investing its development efforts in going forward.