fulltext index update crash

2002-08-12 Thread Ryan Barber
Is anyone else still having problems with fulltext indexed tables using 4.0.2? Ours crashed over the weekend during an update, corrupting the table. The server was left running, which is an improvement over the behavior of 4.0.1, where the whole server would die. The changes to the boolean se

Full-Text update crash

2002-06-04 Thread Ryan Barber
I've read a couple posts about problems issuing updates to mysql on full-text key'd columns, unfortunately the only answer found is that its will be fixed in the upcoming 4.0.2 release. any idea when that will go beta? or should I trying using the cvs version? I could post a stack trace, but I

Re: MySQL Full-text search

2002-05-30 Thread Ryan Barber
Thanks Philip, I spent some time looking for that list, but obviously didn't look hard enuf. Ryan > > 2) Why would these sample words have no match? > > Cannot match against "when", "most", "like", "goes" Why are these > > words not in the index? The file contains 1 million title records > > an

MySQL Full-text search

2002-05-30 Thread Ryan Barber
Hi, We have two major concerns with the full-text search in MySQL. They appear to be simple problems that can be fixed. We are about to use MySQL in a big way, and we would like to license it, however these problems are a major obstacle that must be fixed (or at least understood). 1) Using the w