What is the difference between MyISAM and 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)

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
How to check checkbox is checked or not using jquery

Leave a Reply

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