Follow Me:

Friday, 7 August 2015

Differences between InnoDB and MyISAM 

   In MySQL, major difference of InnoDB and  MyISAM are given below. MyIsam is supporting the table level locking in database. But InnoDB is supporting the row level locking in the database. MyIsam is supporting the FULL TEXT SEARCH functionality and InnoDB also supporting the FULL TEXT SEARCH after MySQL Version of 5.6.4.

 

 MyISAM Engine : 

1. It supporting Table-level Locking
2. It supports FULLTEXT SEARCH functionality
3. It is designed for need of speed
4. It is not supporting foreign key constraints
5. It is storing the data as its tables, data and indexes in diskspace using separate three different files formats. (table.FRM, table.MYD, table.MYI)
6. It is not supporting transactions [ We can't COMMIT and ROLLBACK the comments ]
7. It recovering data by using Requires full repair/rebuild of indexes/tables
8. It is storing the data as no ordering format

INNODB Engine : 

1. It is supporting Row-level Locking
2. After MySQL Version 5.6.4 ,Supporting FULL TEXT SEARCH functionality
3. It is designed for maximum performance when processing high volume of data
4. It is supporting foreign key constraints
5. It is supporting transactions [ We can COMMIT and ROLLBACK the comments ]
6. It stores data as tables and indexes in a tablespace
7. It is Auto recovery from crash via replay of logs
8. It is stored the data row as primary key order


15 comments:


  1. Nice Article !

    Really this will help to people of MySQL Server Community.
    I have also prepared small note on this, the main difference between innodb and myisam of MySQL Server.

    http://www.dbrnd.com/2015/11/mysql-the-main-difference-between-innodb-and-myisam/

    ReplyDelete
  2. This comment has been removed by a blog administrator.

    ReplyDelete
  3. Thank you for your post. This was really an appreciating one. You done a good job. Keep on blogging like this unique information with us.


    Web Designing Training in Chennai

    ReplyDelete
  4. This information is impressive..I am inspired with your post writing style & how continuously you describe this

    topic. After reading your post,thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic.. SAP Training in chennai

    ReplyDelete
  5. Good post. Thanks for sharing such a useful post.

    php training in chennai

    ReplyDelete
  6. Informative post. Thanks for sharing such a useful post.

    ppc training in chennai

    ReplyDelete
  7. This is a great post. I like this topic.This site has lots of advantage.I found many interesting things from this site. It helps me in many ways.Thanks for posting this again.


    SEO Company in Chennai

    ReplyDelete
  8. Thanks for this blog. provided great information. All the details are explained clearly with the great explanation. Thanks for this wonderful blog. Step by step processes execution are given clearly.Know the details about different thing.
    Digital marketing company
    Digital marketing services

    ReplyDelete
  9. I keep on reading your blog post.. This was still amazing. Thanks a lot for sharing this unique informative post with us.. I really enjoyed by reading your blog post

    Seo Company in Chennai

    ReplyDelete
  10. Digital Marketing has an awesome future in India. Every organization gives equal importance to advanced promoting when compared with traditional marketing. Digital Marketing can yield extraordinary results gave it is done truly from the promoters.
    Digital Marketing courses | Digital Marketing Training in Chennai | Digital Marketing Training Institute in Chennai

    ReplyDelete

  11. Thanks for posting this useful content, Good to know about new things here, Let me share this, . Hadoop training in pune

    ReplyDelete