Hi,
I have a 3GB index which includes a fulltext index on 2 columns. I
wanted to drop this fulltext index from the table, but it took
forever. Why it is so slow? Is it because MySQL basically go through
the index file (there is only one) and re-write it to another file and
then copy it back?
Any
At 01:27 PM 8/5/2004, you wrote:
Hi,
I have a 3GB index which includes a fulltext index on 2 columns. I
wanted to drop this fulltext index from the table, but it took
forever. Why it is so slow? Is it because MySQL basically go through
the index file (there is only one) and re-write it to another
On Thu, Aug 05, 2004 at 11:27:40AM -0700, Haitao Jiang wrote:
Hi,
I have a 3GB index which includes a fulltext index on 2 columns. I
wanted to drop this fulltext index from the table, but it took
forever. Why it is so slow? Is it because MySQL basically go through
the index file (there is
In the last episode (Aug 05), Jeremy Zawodny said:
On Thu, Aug 05, 2004 at 11:27:40AM -0700, Haitao Jiang wrote:
I have a 3GB index which includes a fulltext index on 2 columns. I
wanted to drop this fulltext index from the table, but it took
forever. Why it is so slow? Is it because MySQL