Initially, MySQL was designed with a character code that represents one character in 3 bytes, so the index has only 767 bytes, which fits 255 characters x 3 bytes.