Re: Adding index to Memory table LOSES ROWS!

2008-07-28 Thread mos
At 03:31 PM 7/27/2008, Kevin Hunter wrote: At 12:42p -0400 on Sat, 26 Jul 2008, mos wrote: > At 09:14 AM 7/26/2008, you wrote: >> The reproducible part is very important, because without it, it's >> suspect to be just your individual case, as with a bug in *your* >> application code, your hardwar

Re: Adding index to Memory table LOSES ROWS!

2008-07-27 Thread Kevin Hunter
At 12:42p -0400 on Sat, 26 Jul 2008, mos wrote: > At 09:14 AM 7/26/2008, you wrote: >> The reproducible part is very important, because without it, it's >> suspect to be just your individual case, as with a bug in *your* >> application code, your hardware, or generally something in your setup. > >

Re: Adding index to Memory table LOSES ROWS!

2008-07-26 Thread mos
At 09:14 AM 7/26/2008, you wrote: At 5:52p -0400 on Fri, 25 Jul 2008, mos wrote: [Adding index to memory table silently loses data] First thing, what version are you using? MySQL 5.0.24a on Windows XP Pro with 3gb RAM. The server is on the same machine as the client since I'm the only one usi

Re: Adding index to Memory table LOSES ROWS!

2008-07-26 Thread Kevin Hunter
At 5:52p -0400 on Fri, 25 Jul 2008, mos wrote: [Adding index to memory table silently loses data] First thing, what version are you using? Second thing, although it would still be broken, did you read the MySQL docs to make sure that the Memory table type supports the index *type* you attempted t

Adding index to Memory table LOSES ROWS!

2008-07-25 Thread mos
I have a memory table with a few hundred thousand rows. As soon as I add an index to the table, it loses 75% of the rows! No error is produced in the log file or on the client machine. The rows 'A' to 'E' are present, but rows 'F' to 'Z' are missing. I have max_heap_table_size=1024M and tmp_ta