innodb_large_prefix设置步骤,解决max key length is 767 bytes

seeker908

mysql> set global innodb_file_format = BARRACUDA;

运行后提示：Query OK, 0 rows affected (0.00 sec)


mysql> set global innodb_large_prefix = ON;

运行后提示：Query OK, 0 rows affected (0.00 sec)