> ## Content Index
> Fetch the complete content index at: https://helpmonks.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# MySQL: Specified key was too long; max key length is 767 bytes
- URL: https://helpmonks.com/blog/mysql-specified-key-was-too-long-max-key-length-is-767-bytes/
- Published: 2017-09-07T00:00:00.000Z
- Updated: 2026-04-04T01:57:10.000Z
- Description: I just ran into this issue while setting up a new client server with MySQL 5.6, well, Percona 5.6 in my case. It looks like one has to explicitly allow long
- Author: Nitai
- Tags: email marketing

I just ran into this issue while setting up a new client server with MySQL 5.6, well, Percona 5.6 in my case.

It looks like one has to explicitly allow long prefixes in 5.6\. Something that was never needed in 5.5 or earlier version of MySQL.

In any case, adding:

innodb\_large\_prefix = on

to the my.cfn file solved it.

Hope it helps someone else out there 🙂