Database engine difference of InnoDB, MyISAM, Memory

Database engine difference of InnoDB, MyISAM, Memory

InnoDB:: 

This is the default storage engine for MySQL 5.5 and higher.  It provides transaction-safe (ACID compliant) tables, supports FOREIGN KEY referential-integrity constraints.  It supports commit, rollback, and crash-recovery capabilities to protect data.  It also support row-level locking. It’s “consistent nonlocking reads” increases performance when used in a multiuser environment.  It stores data in clustered indexes which reduces I/O for queries based on primary keys.

MyISAM::

This storage engine, manages non transactional tables, provides high-speed storage and retrieval, supports full text searching.

MEMORY::

Provides in-memory tables, formerly known as HEAP.  It sores all data in RAM for faster access than storing data on disks.  Useful for quick looks up of reference and other identical data.

 

 

For Database engines Please visit the link below,

http://stackofcodes.in/2018/03/13/database-engine-php/

Database engine in php

Please follow and like us:
0

1 thought on “Database engine difference of InnoDB, MyISAM, Memory”

  1. This differences may also help you to find the better one..

    #Difference betwween MYISAM & INNODB

    ** MYISAM: **

    MYISAM supports Table-level Locking
    MyISAM designed for need of speed
    MyISAM does not support foreign keys hence we call MySQL with MYISAM is DBMS
    MyISAM stores its tables, data and indexes in diskspace using separate three different files. (tablename.FRM, tablename.MYD, tablename.MYI)
    MYISAM not supports transaction. You cannot commit and rollback with MYISAM. Once you issue a command it’s done.
    MYISAM supports fulltext search
    You can use MyISAM, if the table is more static with lots of select and less update and delete.

    ** INNODB: **

    InnoDB supports Row-level Locking
    InnoDB designed for maximum performance when processing high volume of data
    InnoDB support foreign keys hence we call MySQL with InnoDB is RDBMS
    InnoDB stores its tables and indexes in a tablespace
    InnoDB supports transaction. You can commit and rollback with InnoDB

Leave a Reply

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