MySQL two engine contrast

MySQL two engine contrast

MyIsam      Advantages: 1. Support for B-tree retrieval and full text Retrieval 2. The performance consumption is relatively low 3. Support full table lock disadvantage: No transaction management no data cache InnoDB Advantages: c8> 1. Support for transaction management (commit, rollback, etc.) 2. Support row lock, ensure transaction integrity 3. Support data caches 4. Support for foreign key (foreign key) association Disadvantages: c11> High performance consumption, consumption of hard disk storage large (see table below for detailed comparison, from the official MySQL manual)

MySQL two engine contrast