Get the App
SLTechnology News&Howtos  ›  Database  › 

The difference between InnoDB and MyISAM storage engine

Shulou Source: shulou.com Published: 2022-06-01 16:45:40 11月10日 Update

Differences between InnoDB and MyISAM storage engines:

InnoDB Storage engine:

The current mainstream of MySQL storage engine, InnoDB storage engine supports transactions, row locks, unlocked reads, and foreign keys.

MyISAM Storage engine:

MyISAM does not support transactions, row-level locks, table locks (inefficient), and full-text indexing. The biggest drawback is that it cannot be safely recovered after a crash.

These are the details of the differences between InnoDB and MyISAM storage engines. Please pay more attention to other related articles!

Tags: Support engine storage differences transactions maximum security differences mainstream full text content that is efficiency articles more indexes defects Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Huawei NVidia MariaDB Linux macOS