| innoDB | MyISAM |
| innoDB support transactions, so that if something went wrong, we can roll back the transaction | MyISAM is not meant for transactional purpose. Once command issued we cannot rollback the transaction |
| innoDB doesn't support full support text searching | MyISAM support full text searching |
| innoDB do row locking | MyISAM do table locking |
| innoDB maintain ACID | MyISAM doesn't |
| innoDB can use with table having many data modification | MyISAM doesn't recommended |
| innoDB for high volume & High performance | MyISAM not recommended |
Wednesday, 19 September 2012
Difference between innoDB & MyISAM
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment