当前位置：网站首页>MySQL of fighting spirit and courage

MySQL of fighting spirit and courage

2022-04-22 17:03:00 【Brother Yunlan】

1.myisam and innodb The difference between ：

myisam myisam Engine is 5.1 The default engine before version , Support full text search 、 Compress 、 Space function, etc , However, transaction and row level are not supported lock , Therefore, it is generally used in scenarios with a large number of queries and a small number of inserts , and myisam Foreign key not supported , And the index and data are stored separately .
innodb innodb It's based on clustering index , and myisam Instead, it supports transactions 、 Foreign keys , And through MVCC To support high concurrency , Cable Index and data are stored together .

2.mysql What are the indexes of ： According to the data structure, the index mainly contains B+ Trees and Hash Indexes .
3. What are clustered and nonclustered indexes ：

B+ Trees

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

边栏推荐

猜你喜欢

随机推荐