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

date_published Datetime8 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

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

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

Update delay

On an InnoDB table for 70k records the update action is taking so much time.(More than 30minutes). We got the innodb_buffer_pool_size as 4gigs. IS there anything more to add up to get the processes kick its speed. - javabuddy