- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
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.
- Related Articles
- 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?
- How can I set a MySQL database to use MyISAM by default?
- When to use inline function and when not to use it in C/C++?
- When to use an abstract class and when to use an interface in Java?
- When should I use an Inline script and when to use external JavaScript file?
- When to use $(document).ready() and when $(window).load() in jQuery?
- 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 anonymous JavaScript functions?
- When to use tuples in C#?
