MySQL :: MySQL 8.4 参考手册 :: 17.22 InnoDB 限制和限制

8.4 中文镜像

MySQL 8.4 参考手册 · 中文镜像

正文为中文，英文原文默认隐藏。点击任意中文段落即可展开 / 收起对应英文原文。

打开官方英文原文 ↗

译文由机器翻译生成，仅供理解参考；有疑问请以官方英文原文为准。

MySQL 8.4 参考手册 / 17 InnoDB 存储引擎 / 17.22 InnoDB 限制和限制

中文点击中文段落可显示 / 隐藏英文原文本页译文覆盖 100%

17.22 InnoDB 限制和限制17.22 InnoDB Restrictions and Limitations

本节描述 InnoDB 存储引擎的限制和约束。This section describes restrictions and limitations of the InnoDB storage engine.

您不能创建一个列名与内部 InnoDB 列名相同的表（包括 DB_ROW_ID、DB_TRX_ID 和 DB_ROLL_PTR）。这个限制适用于任何字母大小写的名称使用。You cannot create a table with a column name that matches the name of an internal InnoDB column (including DB_ROW_ID, DB_TRX_ID, and DB_ROLL_PTR. This restriction applies to use of the names in any lettercase.
```
mysql> CREATE TABLE t1 (c1 INT, db_row_id INT) ENGINE=INNODB;
ERROR 1166 (42000): Incorrect column name 'db_row_id'
```
SHOW TABLE STATUS 不会提供 InnoDB 表的准确统计信息，除非是表预留的物理大小。行数只是用于 SQL 优化的粗略估算。SHOW TABLE STATUS does not provide accurate statistics for InnoDB tables except for the physical size reserved by the table. The row count is only a rough estimate used in SQL optimization.
InnoDB does not keep an internal count of rows in a table because concurrent transactions might “第 13.4.4 节，“几何体的正确性和有效性”” different numbers of rows at the same time. Consequently, SELECT COUNT(*) statements only count rows visible to the current transaction.InnoDB does not keep an internal count of rows in a table because concurrent transactions might “see” different numbers of rows at the same time. Consequently, SELECT COUNT(*) statements only count rows visible to the current transaction.
有关 InnoDB 如何处理 SELECT COUNT(*) 语句的信息，请参阅 COUNT() 在第 14.19.1 节，“聚合函数描述” 中的描述。For information about how InnoDB processes SELECT COUNT(*) statements, refer to the COUNT() description in Section 14.19.1, “Aggregate Function Descriptions”.
ROW_FORMAT=COMPRESSED 在页面大小大于 16KB 时不受支持。ROW_FORMAT=COMPRESSED is unsupported for page sizes greater than 16KB.
使用特定 InnoDB 页面大小的 MySQL 实例（innodb_page_size）不能使用来自使用不同页面大小的实例的数据文件或日志文件。A MySQL instance using a particular InnoDB page size (innodb_page_size) cannot use data files or log files from an instance that uses a different page size.
有关使用可传输表空间功能导入表的限制，请参见表导入限制。For limitations associated with importing tables using the Transportable Tablespaces feature, see Table Import Limitations.
有关在线 DDL 的限制，请参见第 17.12.8 节，“在线 DDL 限制”。For limitations associated with online DDL, see Section 17.12.8, “Online DDL Limitations”.
有关通用表空间的限制，请参见通用表空间限制。For limitations associated with general tablespaces, see General Tablespace Limitations.
有关静态数据加密的限制，请参见加密限制。For limitations associated with data-at-rest encryption, see Encryption Limitations.

首页上一级下一节