MYISAM table in MySQL

Question

What is the use of MyISAM table in MySql

Satyapriya Nayak · Answer

Hi Lucy, There are two storage engine available in mysql database they are 1.MyISAM 2.InnoDB MyISAM is the default storage engine.Each MyISAM table is stored on disk in three files. The files have names that begin with the table name and have an extension to indicate the file type. An .frm file stores the table format. The data file has an .MYD (MYData) extension. The index file has an .MYI (MYIndex) extension. InnoDB is a transaction-safe (ACID compliant) storage engine for MySQL that has commit, rollback, and crash-recovery capabilities to protect user data. InnoDB row-level locking (without escalation to coarser granularity locks) and Oracle-style consistent nonlocking reads increase multi-user concurrency and performance The big difference between MySQL Table Type MyISAM and InnoDB is that InnoDB supports transaction InnoDB supports some newer features: Transactions, row-level locking, foreign keys InnoDB is for high volume, high performance Thanks

MYISAM table in MySQL

Answers (1)