Re: Re: Alter table and sort_buffer_size is to small

2002-07-28 Thread Victoria Reznichenko
Martin, Friday, July 26, 2002, 11:01:20 AM, you wrote: 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? MP I compiled it from

Re: Alter table and sort_buffer_size is to small

2002-07-27 Thread Martin Pavlas
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? MP I compiled it from source files. Something is very wrong with your

Re: Alter table and sort_buffer_size is to small

2002-07-25 Thread Victoria Reznichenko
Martin, Tuesday, July 23, 2002, 10:29:13 AM, you wrote: MP I'm running a MySQL server v 3.23.39 on Linux Debian. The server has 500 MP MB RAM. I have a table called sender with 18 columns (only integers MP and varchars, no blobs) and with 3 indexes. The table has about 15000 MP records. Now I

Re: Alter table and sort_buffer_size is to small

2002-07-25 Thread Martin Pavlas
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 compiled it from the source files. sql -- Martin Pavlas Pwrgeneration.net ICC

Re: Re: Re: Alter table and sort_buffer_size is to small

2002-07-25 Thread Victoria Reznichenko
Hello Martin, Thursday, July 25, 2002, 4:48:03 PM, you wrote: Please, send your questions/answers to the mailing list, not to me. 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

Alter table and sort_buffer_size is to small

2002-07-23 Thread Martin Pavlas
Hi all, I'm running a MySQL server v 3.23.39 on Linux Debian. The server has 500 MB RAM. I have a table called sender with 18 columns (only integers and varchars, no blobs) and with 3 indexes. The table has about 15000 records. Now I need to add one more column to the table with alter table