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;