27 Apr, 2024

What’s the difference between MyISAM and InnoDB?

The difference between MySQL Table Type MyISAM and InnoDB are MYISAM MyISAM designed for need of speedMYISAM supports Table-level LockingMyISAM stores its tables, data and indexes in diskspace using separate three different files. (tablename.FRM, tablename.MYD, tablename.MYI)MyISAM does not support foreign keys hence we call MySQL with MYISAM is DBMSMYISAM supports fulltext searchYou can use MyISAM, […]

Share your Love
1 min read