Closed xperseguers closed 6 years ago
According to https://dev.mysql.com/doc/refman/5.7/en/innodb-restrictions.html, an InnoDB table has an index key prefix limit of 767 bytes if configuration parameter innodb_large_prefix is disabled.
innodb_large_prefix
By constraining the DN key to 64 characters, we should still have a good discriminant index while preventing errors when trying to create the index in the Install Tool.
Resolves: #9
I'd like @tbrodard to confirm that this changes is fine. Thanks.
@xperseguers Tested on a TYPO3 7.6 instance: no error message while updating the db schema from the Install Tool
=> it's OK
According to https://dev.mysql.com/doc/refman/5.7/en/innodb-restrictions.html, an InnoDB table has an index key prefix limit of 767 bytes if configuration parameter
innodb_large_prefix
is disabled.By constraining the DN key to 64 characters, we should still have a good discriminant index while preventing errors when trying to create the index in the Install Tool.
Resolves: #9