Mysql ERROR 1709 (HY000) The maximum column size is 767 bytes on local Docker but not AWS
We are using Docker for local development and Aws for production and we are using mysql5.6. I am trying to update or local mysql to match aws which is 5.6 and when I run out Schema I get the error
ERROR 1709 (HY000) at line 974: Index column size too large. The maximum column size is 767 bytes.
But we do not have this error on AWS.
I am using the docker image
mysql:5.6.29 and have the following configuration set
[mysqld] max_allowed_packet = 900M default-storage-engine=innodb lower_case_table_names=1 innodb_buffer_pool_size=1702545920 innodb_file_format=Barracuda innodb_file_format_check=ON innodb_file_format_max=Barracuda innodb_file_per_table=ON innodb_large_prefix=ON
the line it is tripping up on is trying to create an index on a
varchar(250). Unfortunately it is not an option to change this.
Can someone advise on this?
So I just figured out It is not possible without setting ROW_FORMAT to COMPRESSED, it does not work on Amazons mysql, but Amazon some how migrated it from 5.5 to 5.6 without the change in ROW_FORMAT which I have yet to figure out