Hi!
>>>>> "Arjen" == Arjen Lentz <[EMAIL PROTECTED]> writes: Arjen> Hi Tim, Arjen> On Sat, 2002-02-23 at 02:46, Tim Allwine wrote: >> So it appears there is a maximum of 32 keys (indexes) that can be >> created on a table. Is there any way to increase this? If so how? Arjen> I think it is very important to ask the "WHY" question here.... can you Arjen> post your table CREATE statement, and some sample queries you use? This has been up a couple of times before... You can find the reson and solution in the MySQL email archive. The reason is that we are using a bitmap for index optimization; On 32 bit machines there is a limit of 32 index, while on 64 bit machines you can use 64 indexes. To get 64 indexes on a 32 bit machine, change the define in sql/mysql_priv.h from: typedef ulong key_map; to typedef ulonglong key_map; and in sql/unireg.h #define MAX_KEY 32 to #define MAX_KEY 64 and in include/myisamdef.h #define MI_MAX_KEY 32 to #define MI_MAX_KEY 64 Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com --------------------------------------------------------------------- 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