In the last episode (Jul 25), [EMAIL PROTECTED] 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 [EMAIL PROTECTED] --------------------------------------------------------------------- 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
