What is the difference between MyISAM and InnoDB Storage engine? myisaminnodb Storage

What is the difference between MyISAM and InnoDB Storage engine? myisaminnodb Storage

1. MyISAM does not support advanced transaction processing, whereas InnoDB does.

2. MyISAM emphasizes performance and speed, while InnoDB provides advanced database functions such as transaction support and Foreign keys.

3. MyISAM has much better read performance than InnoDB. MyISAM data is separated from the index, and the index is compressed. InnoDB is bundled and the index is not compressed. Write operations are performed, myISAM has stronger insert than InnoDB, while update may be inferior to InnoDB.

Ps: csv (comma separate value, comma-separated values) storage engine to access data not stored in the database but stored in external files. When inserting, updating, and deleting data, it is not the operational data warehouse, but a newly created table_name.csv file in the current data warehouse directory.