> > When mysql is indexing You can check your data file direcory and You > > ca see that one file (the index) is growing in size. > I see it grow up to 8M and it stays there. Watching this, it grows very slowly. After 5 minutes of indexing, the file size has barely hit 2MB.
> > The command I use is: > > create fulltext index Name on Table(field) > So far I've only used the alter table call... I will use this call > next and see if I get any problems. I've used the create index call now, as described above, and it does not change anything. The index still only grows to 8MB. > I've read something of MySQL 4.0.12-0 having a fulltext index bug that > converts text into char. (MySQL documentation in MySQL 4.0.13-0 docs > describes this in a bug fix entry. Perhaps this is a symptom ? > I am busy downloading the newer version to find out. No change. > Can your system handle files larger than 2GB? Maybe this is the problem. Can anyone give me any indication as to whether this may be the case ? Should I load the kernel that supports bigger filesystems ? Thanks for all help Ciao H M Kunzmann
signature.asc
Description: This is a digitally signed message part
