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


21 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
    Replies

    1. I have read your blog its very attractive and impressive. I like it your blog.

      Guaranteed SEO services Guaranteed SEO

      Delete
  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
  12. Thank you for Sharing. We are leading erp software solution providers in chennai. For more details call +91 9677025199. erp in Chennai

    ReplyDelete
  13. Really awesome blog. Your blog is really useful for me. Thanks for sharing this informative blog..
    Mat Lab Project Center in Chennai | Best Mat Lab Project Center in Chennai | No.1 Mat Lab Project Center in Chennai.

    ReplyDelete
  14. The website is looking bit flashy and it catches the visitors eyes. A design is pretty simple and a good user-friendly interface.

    Programmierung in L├╝denscheid

    ReplyDelete