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/mysql?unsub=m...ie.nctu.edu.tw

If you are on a version prior to 4.1.2 the max index size is 500 bytes=20
{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:maillist (AT) roomity (DOT) com]=20
Sent: Friday, August 12, 2005 12:30 PM
To: mysql (AT) lists (DOT) mysql.com
Subject: Index - max key length is 1024 bytes

I am trying to create an index with multiple fields.=20

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
=09
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
------------------------------------------------------------------------
----------------------------


--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=3...rint (DOT) com




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3...ie.nctu.edu.tw