Alter table and sort_buffer_size is to small

the table (and even optimized) and it's fine. I hope there must be something to help me. Thank you. PS: I'll send the structure of the table if it helps. Martin -- Martin Pavlas Pwrgeneration.net ICC s.r.o. - Before

Re: Alter table and sort_buffer_size is to small

Hi, > MP> But when I do it I get: > MP> ERROR 1034: sort_buffer_size is to small > Hm.. > > Error 1034 means: > "Incorrect key file for table ..." > > not a "sort_buffer_size is to small" > > How did you installed the server? I co

Re: Alter table and sort_buffer_size is to small

HI, I can't really do this because it's production machine and I can't change the MySQL instalation. Do you think it will help if I try the latest 3.23.51? But I'll have to compile it from the source again. -- Martin Pavlas Pwrgeneration.net ICC s.r.o. ---