Hi,
Sorry to repost my question but I did not get any answer.
What is the maximum number of keys for a MyISAM table (without rebuilding
mysqld from source), 16 as specified in error message or 32 as in doc. ?
Thanks
-------- Original Message --------
Subject: Maximum number of keys
Date: Tue, 28 Aug 2001 16:42:38 +0200
From: [EMAIL PROTECTED]
To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Hello,
According to MySQL documentation (Chap. 7.1 "MyISAM Tables"):
"Maximum number of keys/table is 32 as default."
However when I try to create more than 16 keys, I get:
ERROR 1069 at line 1: Too many keys specified. Max 16 keys allowed
This table is of MyISAM type.
I am currently running MySQL 3.23.41 on Linux (2.4.5) from precompiled
binaries (MySQL-3.23.41-1.i386.rpm).
Is there any way to use more than 16 keys ?
Thanks your help
--
Joseph Bueno
NetClub/Trader.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