Hello.
On Wed, Aug 29, 2001 at 12:01:07PM +0200, [EMAIL PROTECTED] wrote:
Sorry to repost my question but I did not get any answer.
20 hours is hardly a period of time after which you should assume your
message has slipped through. Please avoid early reposting. The list
already gets a lot of mail.
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. ?
I am not able to reproduce the problem:
mysql create table t10 (a int, b int, c int, d int, key(a), key(b), key(c), key(d),
key(a,b), key(a,c), key(a,d), key(b,a), key(b,c), key(b,d), key(c,a), key(c,b),
key(c,d), key(d,a), key(d,b), key(d,c), key(a,b,c), key(a,b,d), key(a,c,b),
key(a,c,d));
Query OK, 0 rows affected (0.01 sec)
mysql select version();
+-+
| version() |
+-+
| 3.23.40-log |
+-+
1 row in set (0.01 sec)
[...]
According to MySQL documentation (Chap. 7.1 MyISAM Tables):
Maximum number of keys/table is 32 as default.
Correct.
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
16 keys/table was the limit before the MyISAM table type was
introduced. So you are probably using an ISAM table (or one of the
other table types - I don't know about their limits).
This table is of MyISAM type.
Oh. Well, then I may have made the false conclusions. But you may want
to verify the table type once again to be sure, for example with
SHOW CREATE TABLE;
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 ?
The need for so much keys may mean that there is some design problem.
If everything above does not help, please cite the complete command
you are using. Maybe the problem is related to this and not to a real
table restriction.
Bye,
Benjamin.
-
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