Specified key was too long; max key length is 767 bytes

set global innodb_large_prefix=on;
set global innodb_file_format=Barracuda;
set global innodb_file_format_max=Barracuda;

row_format 设置为dynamic 或compressed

已存在表:
ALTER TABLE TEST ROW_FORMAT=DYNAMIC;
新表:
create table QRTZ_PAUSED_TRIGGER_GRPS (
sched_name varchar(120) not null,
trigger_group varchar(200) not null,
primary key (sched_name,trigger_group)
) engine=innodb ROW_FORMAT=DYNAMIC;

posted @ 2019-11-25 17:07  别问1991  阅读(289)  评论(0编辑  收藏  举报