MySql的七种表类型(存储引擎)

来源：互联网发布：mac 文件编辑器编辑：程序博客网时间：2024/06/08 04:02

root@(none) 02:21:54>show engines;+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+| Engine             | Support | Comment                                                                    | Transactions | XA   | Savepoints |+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+| PERFORMANCE_SCHEMA | YES     | Performance Schema                                                         | NO           | NO   | NO         || CSV                | YES     | CSV storage engine                                                         | NO           | NO   | NO         || MRG_MYISAM         | YES     | Collection of identical MyISAM tables                                      | NO           | NO   | NO         || BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears)             | NO           | NO   | NO         || MyISAM             | YES     | MyISAM storage engine                                                      | NO           | NO   | NO         || MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                  | NO           | NO   | NO         || ARCHIVE            | YES     | Archive storage engine                                                     | NO           | NO   | NO         || FEDERATED          | NO      | Federated MySQL storage engine                                             | NULL         | NULL | NULL       || InnoDB             | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES          | YES  | YES        |+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+9 rows in set (0.01 sec)

Mysql的存储引擎（表类型分为以下几种）

（1）MyISAM：具有较高的插入、查询速度，但是不支持事务。

（2）InnoDB：支持事务、支持行级锁

（3）MEMORY：

（4）ARCHIVE:

（5）CSV存储引擎将数据以逗号分隔的形式存储在文本文件中

创建数据库表的时候可以通过engine来选定要创建何种类型的存储表

create table tablename (...,...,...,) ENGINE = INNODB

0 0