当前位置：网站首页>Mysql two engines comparison

Mysql two engines comparison

2022-08-09 16:03:00 【Yunhaigutian】

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)

版权声明
本文为[Yunhaigutian]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/221/202208091447399431.html