If you are on a version prior to 4.1.2 the max index size is 500 bytes
{not sure why the error mentions 1024}
>From section 14.1 of documention
The maximum key length is 1000 bytes (500 before MySQL 4.1.2). This can
be changed by recompiling. For the case of a key longer than 250 bytes,
a larger key block size than the default of 1024 bytes is used.
-----Original Message-----
From: javabuddy [mailto:[EMAIL PROTECTED]
Sent: Friday, August 12, 2005 12:30 PM
To: mysql@lists.mysql.com
Subject: Index - max key length is 1024 bytes
I am trying to create an index with multiple fields.
The sixe of each of the column is listed and thier sum is 560bytes. But
when I try to create an index with the colums, it complains on the size
exceeded 1024 bytes. Below is the query and the size of each..
create index selectTechnologyClubsThread_idx on content
(club_id, date_update, subject, message_id, id, date_published,
comment_count_d, display_usr_name_d, short_content)
COLUMN_NAME TYPE SIZE
club_id Bigint 8
date_update Bigint 8
Subject Varchar(120) 121
message_id varchar(120) 121
Id Bigint 8
date_published Datetime 8
comment_count_d Int 4
short_content Varchar(250) 251
display_usr_name_d Varchar(30) 31
TOTAL : 560
Any sort of help would be great....
- javabuddy
------------------------------------------------------------------------
----------------------------
People are conversing... without posting their email or filling up their
mail box. ~~1123867827435~~
roomity.com http://roomity.com/launch.jsp No sign up to read or search
this Rich Internet App
------------------------------------------------------------------------
----------------------------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
