lucas
asked Feb 07 2017
Answer
The major difference is that,
- MyISAM can do only table-level locking system whereas InnoDB had row-level locking system.
- InnoDB has better crash recovery than MyISAM
- InnoDB supports foreign keys & relationship controls.
Though InnoDB is slower when compared to MYISAM, InnoDB is recommended.
MyISAM is faster since it has simple construction and consume lass server resources.
jagannatharumugam
asked Feb 24 2017
edited Oct 05 2018
difference between innodb and myisam
In the recent discussion with Gabriel, discussed about default_storage_engine modification..... There mentioned MyISAM and i have heard about the commonly used one called InnoDB.... So what is the difference and which is the best to use....???