Mysql error 1069 Too many specified keys; Maximum allowed 64 keys

Question

I try to run the alter table command and I get the following error:

# 1069 - Too many specified keys; maximum 64 keys allowed

any help would be much appreciated

Answer 1

According to mysql forums you should compile with

./configure --prefix = / usr / local / mysql --with-charset = cp1251 --enable-thread-safe-client --with-max-indexes = 256

source: http://forums.mysql.com/read.php?22,53666,262189#msg-262189

Unfortunately, there is no way to change after compilation

Answer 2

, ... 64 (, )