MySQL Forums
Forum List  »  Newbie

ERROR 1069: Too many keys specified. Max 32 keys allowed
Posted by: iam iam
Date: August 18, 2004 01:07PM

Hello,

that's my first message to that forum, so let you know me.

I'm trying to create a so complicated database (a really big database) and I'm in trouble with the maximum number of keys (maybe indexes too?) allowed per table. The situation is I need a table with one field as the primary key, fourty fields as foreign keys (all these fourty foreign keys references to the same table. You can think that as a fourty people in a working team). As I use InnoDB tables for all that, every foreign key needs a corresponding index, so, fourty indexes. These are 41 keys and 40 indexes, so, I get the error you can see into the subject.

Can I avoid/modify this restriction easily? I think I could if I modify MySQL source code, but is not the solution for me.

Thank you all.

Options: ReplyQuote


Subject
Written By
Posted
ERROR 1069: Too many keys specified. Max 32 keys allowed
August 18, 2004 01:07PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.