This question already has an answer here:
Our server is creating a lot of tables and one of them is the
We are using MySQL 5.5 on Percona. Also we are using
It throws the following error when creating the following index on
ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
Here is the create-table query:
create table Lock_ ( uuid_ VARCHAR(75) null, lockId LONG not null primary key, companyId LONG, userId LONG, userName VARCHAR(75) null, createDate DATE null, className VARCHAR(75) null, key_ VARCHAR(200) null, owner VARCHAR(255) null, inheritable BOOLEAN, expirationDate DATE null );
create unique index IX_DD635956 on Lock_ (className, key_, owner);
This problem is happening on one of our prod servers (previously it was standalone mysql and then later moved to percona, but the problem was present in both the editions), but this is working fine on our dev environment.
So is there a way we can update the prod environment's index length or something so that it does not throw this error?