Main differences:
- 1). MyISAM is a non-transactional security type, and InnoDB is a transaction-safe type.
- 2). The granularity of MyISAM locks is table-level, while InnoDB supports row-level locking.
- 3). MyISAM supports full-text type indexing, while InnoDB does not support full-text indexing.
- 4). MyISAM is relatively simple, so in terms of efficiency is better than INNODB, small applications can consider the use of MyISAM.
- 5). MyISAM tables are saved as files, and using MyISAM storage in cross-platform data transfer saves a lot of hassle.
- 6). The InnoDB table is more secure than the MyISAM table and can be switched from non-transactional tables to transaction tables (ALTER TABLE tablename TYPE=INNODB) without ensuring that the data is not lost.
Application Scenarios:
- 1). 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.
-
- 2). InnoDB is used for transactional applications and has 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.
Turn from: 54375341
Main differences and application scenarios for MyISAM and InnoDB