1、set global innodb_file_format = BARRACUDA;
set global innodb_large_prefix = ON;
2、查看一下,是否设置成功
show variables like 'innodb_large_prefix';
show variables like 'innodb_file_format';
3、在建表语句后面加上ROW_FORMAT=DYNAMIC
1、set global innodb_file_format = BARRACUDA;
set global innodb_large_prefix = ON;
2、查看一下,是否设置成功
show variables like 'innodb_large_prefix';
show variables like 'innodb_file_format';
3、在建表语句后面加上ROW_FORMAT=DYNAMIC