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?

1 answer

  • answered 2017-01-11 14:18 jonnie

    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