You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
环境:centos6.9 myslq-5.5.60,venv虚拟环境,按照readme中的方法进行迁移数据库 python manage.py migrate
报错:pymysql.err.InternalError: (1709, 'Index column size too large. The maximum column size is 767 bytes.')
根据百度到的方法:配置下面mysql配置,然后重启mysql,但是还是显示错误
innodb_file_format = Barracuda
innodb_file_per_table = 1
innodb_large_prefix
从mysql可以看到已经生效
mysql> show global variables like 'innodb_lar%';
+---------------------+-------+
| Variable_name | Value |
+---------------------+-------+
| innodb_large_prefix | ON |
+---------------------+-------+
1 row in set (0.00 sec)
mysql> show global variables like 'innodb_fil%';
+--------------------------+-----------+
| Variable_name | Value |
+--------------------------+-----------+
| innodb_file_format | Barracuda |
| innodb_file_format_check | ON |
| innodb_file_format_max | Antelope |
| innodb_file_per_table | ON |
+--------------------------+-----------+
4 rows in set (0.00 sec)
不知是否遇到过这个问题
The text was updated successfully, but these errors were encountered:
环境:centos6.9 myslq-5.5.60,venv虚拟环境,按照readme中的方法进行迁移数据库 python manage.py migrate
报错:pymysql.err.InternalError: (1709, 'Index column size too large. The maximum column size is 767 bytes.')
根据百度到的方法:配置下面mysql配置,然后重启mysql,但是还是显示错误
innodb_file_format = Barracuda
innodb_file_per_table = 1
innodb_large_prefix
从mysql可以看到已经生效
mysql> show global variables like 'innodb_lar%';
+---------------------+-------+
| Variable_name | Value |
+---------------------+-------+
| innodb_large_prefix | ON |
+---------------------+-------+
1 row in set (0.00 sec)
mysql> show global variables like 'innodb_fil%';
+--------------------------+-----------+
| Variable_name | Value |
+--------------------------+-----------+
| innodb_file_format | Barracuda |
| innodb_file_format_check | ON |
| innodb_file_format_max | Antelope |
| innodb_file_per_table | ON |
+--------------------------+-----------+
4 rows in set (0.00 sec)
不知是否遇到过这个问题
The text was updated successfully, but these errors were encountered: