When to use MyISAM and InnoDB?

InnoDB is a general-purpose storage engine that balances high reliability and performance. Since MySQL 5.6, InnoDB is the default MySQL storage engine.

InnoDB can be used for various purposes. Here are some of them −

  • 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.

MyISAM is the default storage engine for the MySQL relational database management system versions prior to 5.5 1.

MyISAM can also be used for various types of purpose.

  • MyISAM is easily used for creating and designing. Hence, it can be used by beginners.

  • In MyISAM, there is no complication involving foreign key relationship between tables.

  • This is faster as compared to InnoDB.

  • We can use it when we need minimal performance.

Updated on: 30-Jul-2019


Kickstart Your Career

Get certified by completing the course

Get Started