From: Dan Nelson
Date: July 26 2002 2:47am
Subject: Re: 32 key max in InnoDB
List-Archive: http://lists.mysql.com/mysql/115614
Message-Id: <20020726024711.GE62267@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Jul 25), speters@stripped said:
> what sthe deal with having max 32 keys in InnoDB tables in MySQL?
> 
> the is ABSOLUTELY NO documentation  i can find anywhere that states
> anything about a 32 key max in InnoDB tables.
> 
> Please,  Please, Please, Please, Please,  Please, Please, Please
> point me at some documentation about this

http://www.mysql.com/doc/F/e/Features.html

   Scalability and Limits
          + Up to 32 indexes per table are allowed. Each index may
            consist of 1 to 16 columns or parts of columns. The maximum
            index width is 500 bytes (this may be changed when
            compiling MySQL Server). An index may use a prefix of a
            CHAR or VARCHAR field.


-- 
	Dan Nelson
	dnelson@stripped