- Trending Categories
- Data Structure
- Operating System
- C Programming
- 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.
- MyISAM versus InnoDB in MySQL?
- Can I use InnoDB and MyISAM tables in a single database in MySQL?
- Converting table from MyISAM to INNODB in MySQL?
- MySQL - changing table engine from innoDB to MyISAM?
- How to convert MyISAM to InnoDB storage engine in MySQL?
- How do I know if a MySQL table is using myISAM or InnoDB Engine?
- When to use an abstract class and when to use an interface in Java?
- When to use inline function and when not to use it in C/C++?
- When to use $(document).ready() and when $(window).load() in jQuery?
- How can I set a MySQL database to use MyISAM by default?
- When to use new operator in C++ and when it should not be used?
- When to use C over C++, and C++ over C?
- When to use tuples in C#?