[MariaDB] Specified key was too long; max key length is 767 bytes

---

MariaDB에서 ranger db 생성할 때마다 발생하는 에러입니다... 까먹지 않게 적어둠..

초기에 세팅해두면 좋습니다.

 

💡 해결 방법

• my.cnf에 아래 옵션 추가 후 mariaDB 재기동

$ vi /etc/my.cnf

[mysqld]
...
innodb_file_format = barracuda
innodb_large_prefix = on

 

✅ 재기동 후 확인 명령어

MariaDB [(none)]> SHOW VARIABLES LIKE 'innodb_lar%';
+---------------------+-------+
| Variable_name       | Value |
+---------------------+-------+
| innodb_large_prefix | ON    |
+---------------------+-------+

MariaDB [(none)]> SHOW VARIABLES LIKE 'innodb_file%';
+--------------------------+-----------+
| Variable_name            | Value     |
+--------------------------+-----------+
| innodb_file_format       | Barracuda |
| innodb_file_format_check | ON        |
| innodb_file_format_max   | Barracuda |
| innodb_file_per_table    | ON        |
+--------------------------+-----------+