Re: 32 key max in InnoDB

[Dan Nelson]

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