The difference between MySQL InnoDB and Myisam storage engine

1. InnoDB supports things, Myisam does not support things

2. InnoDB is a row-level lock, Myisam table-level lock

3. InnoDB does not support full-text indexing, Myisam supports full-text indexing, but does not support foreign keys

4. InnoDB is two files on disk, Myisam is three files

5 MyISAM Manage non-transactional tables. It provides high-speed storage and retrieval, as well as full-text search capabilities. MyISAM is a better choice if you need to perform a large number of select queries in your application

6InnoDB is used for transactional applications with many features, including acid transaction support. If you need to perform a large number of insert or update operations in your app, you should use InnoDB, which can improve the performance of multiple user concurrency operations.