Use InnoDB for transactions, foreign keys, and row-level locking instead of MyISAM.
MyISAM lacks transactions, FK enforcement, and crash recovery, risking data integrity.
BeforeMerge scans your pull requests against this rule and dozens more. Get actionable feedback before code ships.
InnoDB provides ACID transactions, row-level locking, foreign-key enforcement, and crash recovery. MyISAM offers none of these and uses table-level locking, which serializes writes and can corrupt data on crash. InnoDB is the default engine in modern MySQL/MariaDB for good reason.
-- Bad: MyISAM (no transactions, no FKs, table locks)
CREATE TABLE orders (id INT PRIMARY KEY) ENGINE=MyISAM;
-- Good: InnoDB
CREATE TABLE orders (id INT PRIMARY KEY) ENGINE=InnoDB;