Prefix support and lengths of prefixes (where supported) are storage engine dependent. For example, a prefix can be up to 767 bytes long for InnoDB
tables or 3072 bytes if the innodb_large_prefix
option is enabled. For MyISAM
tables, the prefix limit is 1000 bytes. The NDB
storage engine does not support prefixes (see Section 21.1.6.6, “Unsupported or Missing Features in NDB Cluster”).
https://dev.mysql.com/doc/refman/5.7/en/create-index.html
Innodb(默认) | innodb_large_prefix Enable | MyIsam | NDB |
767 byte | 3072 byte | 1000 byte | ? |