MySQL optimization key #3: No defaults! Like any software, MySQL has many configurable settings that can be used to modify behavior (and ultimately, performance).

The limits that apply to index key prefixes also apply to full-column index keys. MySQL 5.7文档内容如下： If innodb_large_prefix is enabled (the default), the index key prefix limit is 3072 bytes for InnoDB ...