关于MySQL数据库的存储引擎详细介绍

最新推荐文章于 2024-09-05 10:00:22 发布

海阔天空-NiceGG

最新推荐文章于 2024-09-05 10:00:22 发布

阅读量97

点赞数

文章标签：数据库

本文链接：https://blog.csdn.net/weixin_37529641/article/details/100664913

版权

MySQL数据库提供了多种存储数据的方式，专业术语叫存储引擎。在自己的应用数据库中根据自己的需要创建适合自己应用的数据库表，可以提高数据库处理数据的速度，改善应用的整体功能。

在MySQL数据库中使用show engines命令查看有MySQL的存储引擎：

mysql> show engines;
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine     | Support | Comment                                                        | Transactions | XA   | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
| FEDERATED  | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |
| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance         | NO           | NO   | NO         |
| BLACKHOLE  | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
| MRG_MYISAM | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
| CSV        | YES     | CSV storage engine                                             | NO           | NO   | NO         |
| ARCHIVE    | YES     | Archive storage engine                                         | NO           | NO   | NO         |
| InnoDB     | YES     | Supports transactions, row-level locking, and foreign keys     | YES          | YES  | YES        |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
8 rows in set (0.00 sec)

简单的介绍一下各存储引擎：

1. MyISAM是默认存储引擎。2.