- MyISAM offers speed where as InnoDB offers reliability.
- Innodb support transactions, MyISAM not.
- InnoDB also supports row-level locking, while MyISAM only supports table locking.
- InnoDB is specifically for high volume, high performance.
- With replication it's even possible to take advantage of both storage engines on one table. For example, the master could store a table as InnoDB which makes it fast for INSERTs, UPDATEs and DELETEs while the slave(s) could store the same table as MyISAM and offer the best performance for SELECTs.
-
nothing is impossible!!!!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment