Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
526 Views
