This section describes limits for InnoDB
tables, indexes, tablespaces, and other aspects of the InnoDB
storage engine.
本节介绍InnoDB表、索引、表空间和InnoDB存储引擎的其他方面的限制。
A table can contain a maximum of 1017 columns (raised in MySQL 5.6.9 from the earlier limit of 1000). Virtual generated columns are included in this limit.
一个表最多可以包含1017列(在MySQL5.6.9中从之前的1000列限制提高)。虚拟生成的列包含在此限制中。
A table can contain a maximum of 64 secondary indexes.
一个表最多可以包含64个辅助索引。
If innodb_large_prefix
is enabled (the default), the index key prefix limit is 3072 bytes for InnoDB
tables that use the DYNAMIC
or COMPRESSED
row format. If innodb_large_prefix
is disabled, the index key prefix limit is 767 bytes for tables of any row format.
如果启用了innodb_large_prefix(默认值),则对于使用动态或压缩行格式的innodb表,索引键前缀限制为3072字节。如果禁用innodb_large_prefix,则对于任何行格式的表,索引键前缀限制为767字节。
innodb_large_prefix
is deprecated; expect it to be removed in a future MySQL release.