# 查看数据库被限制了索引的大小
SHOW variables like 'innodb_large_prefix'
# 解除限制
SET GLOBAL INNODB_LARGE_PREFIX = ON;
# 查看当前的innodb_file_format引擎格式类型
SHOW variables like 'innodb_file_format'
# 修改
SET GLOBAL innodb_file_format = BARRACUDA;
# 查看数据库被限制了索引的大小
SHOW variables like 'innodb_large_prefix'
# 解除限制
SET GLOBAL INNODB_LARGE_PREFIX = ON;
# 查看当前的innodb_file_format引擎格式类型
SHOW variables like 'innodb_file_format'
# 修改
SET GLOBAL innodb_file_format = BARRACUDA;