Monday , December 10 2018
Trang chủ / Database / What’s the difference between MyISAM and InnoDB in MySQL

What’s the difference between MyISAM and InnoDB in MySQL

MyISAM and InnoDB are two most commonly used storage engines of MySQL database. However, MyISAM is the default storage engine chosen by MySQL database, when creating a new table. The major differences between these two storage engines are:

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

 

About admin

Check Also

Resolve: ERROR! MySQL is running but PID file could not be found

1# service mysqld status Khi chạy lệnh trên các bạn sẽ thấy lỗi như sau: …

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Đăng Ký Nhận Tin Qua Email

Nhận thông tin bổ ích về WordPress, Hosting, Thủ thuật website, Download miễn phí....và các phần quà hấp dẫn qua email.

* là bắt buộc