A.2.1. | 我可以从哪里获得 MySQL 存储引擎的完整文档？Where can I obtain complete documentation for MySQL storage
engines? |
| 请参阅第 18 章，替代存储引擎。该章节包含了除InnoDB 存储引擎和NDB 存储引擎（用于 MySQL 集群）之外的所有 MySQL 存储引擎的信息。InnoDB 在第 17 章，InnoDB 存储引擎中介绍。NDB 在第 25 章，MySQL NDB 集群 8.4中介绍。See Chapter 18, Alternative Storage Engines. That chapter contains
information about all MySQL storage engines except for the
InnoDB storage engine and the
NDB storage engine (used for MySQL
Cluster). InnoDB is covered in
Chapter 17, The InnoDB Storage Engine.
NDB is covered in
Chapter 25, MySQL NDB Cluster 8.4. |
A.2.2. | MySQL 8.4 中有新的存储引擎吗？Are there any new storage engines in MySQL 8.4? |
| 没有。InnoDB 是新表的默认存储引擎。详情请参见 第 17.1 节，“InnoDB 简介”。No. InnoDB is the default storage engine for
new tables. See Section 17.1, “Introduction to InnoDB” for
details. |
A.2.3. | MySQL 8.4 中有存储引擎被移除吗？Have any storage engines been removed in MySQL 8.4? |
| 没有。No. |
A.2.4. | 我可以阻止使用特定的存储引擎吗？Can I prevent the use of a particular storage engine? |
| 是的。disabled_storage_engines 配置选项定义了哪些存储引擎不能用于创建表或表空间。默认情况下，disabled_storage_engines 是空的（没有禁用任何引擎），但可以设置为一个或多个引擎的逗号分隔列表。Yes. The
disabled_storage_engines
configuration option defines which storage engines cannot be
used to create tables or tablespaces. By default,
disabled_storage_engines is
empty (no engines disabled), but it can be set to a
comma-separated list of one or more engines. |
A.2.5. | 仅使用 InnoDB 存储引擎，而不是结合使用 InnoDB 和非 InnoDB 存储引擎，有什么优势吗？Is there an advantage to using the InnoDB
storage engine exclusively, as opposed to a combination of
InnoDB and non-InnoDB
storage engines? |
| 是的。仅使用 InnoDB 表可以简化备份和恢复操作。MySQL 企业备份会对所有使用 InnoDB 存储引擎的表进行 热备份。对于使用 MyISAM 或其他非 InnoDB 存储引擎的表，它会进行一种 “温备份”，在备份期间数据库仍然运行，但这些表无法被修改。见 第 32.1 节，“MySQL Enterprise Backup 概述”。Yes. Using InnoDB tables exclusively can
simplify backup and recovery operations. MySQL Enterprise Backup does a
hot backup of all tables
that use the InnoDB storage engine. For
tables using MyISAM or other
non-InnoDB storage engines, it does a
“warm” backup, where the database continues to run,
but those tables cannot be modified while being backed up. See
Section 32.1, “MySQL Enterprise Backup Overview”. |
A.2.6. | ARCHIVE 存储引擎有哪些独特的好处？What are the unique benefits of the ARCHIVE
storage engine?
|
| ARCHIVE 存储引擎存储大量数据但不使用索引；它占用空间小，并通过表扫描执行查询。详情请参见 第 18.5 节，“ARCHIVE 存储引擎”。The ARCHIVE storage engine stores large
amounts of data without indexes; it has a small footprint, and
performs selects using table scans. See
Section 18.5, “The ARCHIVE Storage Engine”, for details.
|