Question

When to use MyISAM and InnoDB?

Answer 1

It can be used for transaction purpose i.e. all ACID properties.

InnoDB can be used for row level locking, that means it gives higher performance as compared to MyISAM.

InnoDB can be used for both data and index for a large buffer pool.

InnoDB can be used when we need better performance than MyISAM.