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.

Percona will launch its new Percona Server 5.6 at 8AM tomorrow morning which will feature many of the features of MySQL enterprise edition for free.