~Seth
to get past spam filter: MySQL sql query
Subject: Re: Maximum of 16 indexes per table
From: Michael Widenius
Date: Fri, 30 Jul 1999 23:57:19 +0300 (EEST)
>>>>> "Troy" == Troy Grady <[EMAIL PROTECTED]> writes:
>> (The maximum number of keys are 32 because MyISAM uses a bitmap in a
>> 'long' to check which keys are in use)
>>
>> Regards,
>> Monty
Troy> Section 10.17 of the manual, "Table Types", states the following about
Troy> MYISAM:
Troy> "Maximum number of keys/table enlarged to 32 as default. This can be
Troy> enlarged to 64 without having to recompile myisamchk."
Troy> Are 64 indexes per table possible? If so, how?
Troy> Regards,
Troy> Troy
Hi!
To do this you have to change some constants in myisam.h and unireg.h
and also change the key_map typedef from long to longlong.
The main problem is that we haven't tested the code with more than 32
keys. The main problem is that I may have have missed some
key_map variable and this is still declared as 'ulong' instead of type
'key_map'. In theory it wouldn't be that hard to change 3.23.2 to use
64 keys...
Regards,
Monty
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
