Ranger admin字符过长
错误原因:Specified key was too long; max key length is 767 bytes
错误分析:索引建立的时候,字符长度超过255,由于utf-8字符最长只能为255,超长之后会报错
问题解决:将innodb_large_prefix开启,改方式将允许索引高达3072字符、 方式:
1. set global innodb_file_format = BARRACUDA;
2. set global innodb_large_prefix = ON;