mysql innodb_large_prefix_那些从MySQL5.6升级到5.7的坑--innodb_large_prefix-阿里云开发者社区...

前言

升级有风险，参数需谨慎

innodb_large_prefix

关于innodb_large_prefix这个参数，在之前的“MySQL之最”中有提到过，那在5.6和5.7中的表现哪里不一样呢？更直观一点，举个例子：

在5.6中的表现：

$mysql -uroot -p

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 4708773

Server version: 5.6.16.12-20161009-log Source distribution

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

mysql> CREATE TABLE `cc` (

-> `id` int(11) NOT NULL AUTO_INCREMENT,

-> `c` varchar(255) DEFAULT NULL,

-> PRIMARY KEY (`id`),

-> KEY `idx_c` (`c`)

-> ) ENGINE=InnoDB AUTO_INCREMENT&