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), k
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
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
