升级报错:Specified key was too long; max key length。。原创
795次浏览
编辑于2020年08月28日 18:14:57
问题:
升级报错如图:Specified key was too long; max key length is 767 bytes。。。。。。
解决:
执行以下脚本
show variables like 'innodb_large_prefix';
show variables like 'innodb_file_format';
--修改最大索引长度限制
set global innodb_large_prefix=1;
set global innodb_file_format=BARRACUDA;
-- 添加
set global innodb_file_format_max=BARRACUDA;