Limit on Number of Indexes on MySQL Table

Question:

I use MySQL 5.0.13RC under Linux

I’m trying to create a table with 70 foreign keys and the next message appear :
ERROR 1069: Too many keys specified. Max 64 keys allowed

Can I avoid/modify this restriction easily?

Thank you all.

Solution:

For anyone interested here’s the SQL file that I run through the MySQL client.

shell> mysql -f < test_index_limit.sql
ERROR 1069 (42000) at line 75: Too many keys specified; max 64 keys allowed
...

The test script creates a test_index_limit database, creates an index_limit table and attempts to put 70 indexes on that table. The script drops the database, so if you happen to have a test_index_limit database on your system please be careful.

If user get erro

ERROR 1069 (42000) at line 75: Too many keys specified; max 64 keys allowed

user can recompiling your mysql

./configure –with-max-indexes=256

Find more information http://dev.mysql.com/doc/refman/5.0/en/myisam-storage-engine.html