Mysql two engines comparison

Comparison of Mysql two engines

MyIsam

Benefits:

1. Support B-Tree search and full text search

2. Relatively low performance consumption

3. Support full table (table) lock

Cons:

No transaction management

No data cache

InnoDB

Benefits:

1. Support transaction management (commit, rollback, etc.)

2. Support row (row) lock to ensure transaction integrity

3. Support data caches

4. Support foreign key association

Cons:

High performance consumption and large hard disk storage consumption

(See the table below for a detailed comparison, from the mysql official manual)