Re: Maximum of 16 indexes per table

[Seth Price <suppressed>]

Has the maximum number of keys in a MyISAM table been tested more since 
this post? Is it possible to get above 64 keys? (I'm going for 90, btw)
~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 <suppressed> 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 <suppressed>
To unsubscribe, e-mail <suppressed>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php