MySQL Database engine (MyISAM, InnoDB)

MyISAM, InnoDB Difference

Nnodb and MyISAM are the two most common table types used by many people when using MySQL, both of which have pros and cons, depending on the application.

The basic difference is that the MyISAM type does not support advanced processing such as transaction processing, and InnoDB type support. The MyISAM type of table emphasizes performance, which is performed more quickly than the InnoDB type, but does not provide transactional support, while InnoDB provides transactional support for advanced database functions such as external keys.

MySQL Database engine (MyISAM, InnoDB)