Index - max key length is 1024 bytes

What are the pros and cons in resizing the MAX index size, from 1024. - javabuddy People are conversing... without posting their email or filling up their mail box. ~~1123957730975~~

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

RE: Index - max key length is 1024 bytes

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

Index - max key length is 1024 bytes

Thanks But still I can't get the part where my column size totals to 560, but MySql complaining that I have exceeded 1024. Did I went anywhere wrong??? - Gana. People are conversing... without

Re: Index - max key length is 1024 bytes

javabuddy wrote: Thanks But still I can't get the part where my column size totals to 560, but MySql complaining that I have exceeded 1024. Did I went anywhere wrong??? - Gana. People are

Re: Index - max key length is 1024 bytes

javabuddy wrote: But still I can't get the part where my column size totals to 560, but MySql complaining that I have exceeded 1024. Did I went anywhere wrong??? Are you sure you've thought your index through correctly and considered how MySQL will use it? What sort of query would such an

Index - max key length is 1024 bytes

Thanks Devananda.. it helped. - javabuddy. People are conversing... without posting their email or filling up their mail box. ~~1123878070408~~ roomity.com http://roomity.com/launch.jsp No sign