Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • MyISAM vs INNODB in mysql

    @kshitiz.dixit
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 250
    Comment on it

    Difference between MYISAM and INNODB are given below.

    MYISAM:

    1 MyISAM does not support foreign keys.

    2 MyISAM stores its indexes,data and tables in disk space using separate three different files

    3 MYISAM not supports transaction

    4 MYISAM supports full text search.

    5 You should use MyISAM, if the table is more static with lots of select operation and with less update and delete operation.

    6 MyISAM is good for speed.

    7 Table-level Locking is supported by MYISAM

    INNODB:

    1 InnoDB support foreign keys hence we call as RDBMS.

    2 InnoDB stores its data,tables and indexes in a tablespace.

    3 In InnoDB we can commit and rollback as it supports transaction.

    4 Row-level Locking is supported by InnoDB

    MYISAM VS INNODB
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: