Database Storage Engine

Database Storage Engine : What is it and its types in MySQL

Posted by
Spread the love

In last article I talked about the some useful PHP magic methods. But no matter how interested they are, a PHP app is always dependent on any database system to save its data. A database can be of any type backed by a storage engine.

What is Database Storage Engine ?

There are many types of database management systems out there. But every system needs a something that does the operations like creating, reading, updating and deleting that data from the system. Database engine is that component of software module that does these staffs.

Types

There are different types of engines , all types are not supported in all db management systems. In this article I will discuss about the ones supported by MySQL database.

InnoDB:

This engine is the default one set in MySQL 5.5 or later versions. It is ACID compliant engines. It supports transactions, row-level locking, crash recovery, multi-version concurrency control. It provides foreign key referential integrity.

MyISAM:

This engine was default engine in the version prior to MySQL 5.5 . It does not support transactions. It provides table-level locking.

Memory:

This storate engine creates tables in memory. It is the fastest engine, but it is non transactional. Data is deleted when the database is restarted.

CSV:

It stores data in csv file. It plus point is that data in it can be integrate to any other application.

Merge:

To manage large volume of data it is a good one. It is actually operates on underlying MyISAM table.

Archive:

It is optimized engine for high speed insertion. It compress the data when it is inserted. It also does not support transactions.

Other than these, there are two more types of engines Federated and Blackholes storage engine.

About The Author

Leave a Reply

Your email address will not be published. Required fields are marked *