解决 Specified key was too long; max key length is 767 bytes 问题
安装cacti过程中,在导入cacti.sql时存在错误提示:Specified key was too long; max key length is 767 bytes ;
解决方法:
修改mysql配置,
set global innodb_file_format = BARRACUDA;
set global innodb_large_prefix = ON;
set global innodb_file_per_table=ON;
修改后查看:
show variables like 'innodb_large_prefix';
show variables like 'innodb_file_format';
show variables like 'innodb_file_per_table';
修改后再次导入无报错。
版权声明:本文由老瓦罐儿煨汤发布,如需转载请注明出处。