MySQL Forums
Forum List  »  Full-Text Search

Disable full-text Index update stops search services
Posted by: Martin Feng
Date: March 12, 2006 12:30AM

MySQL version: 5.0.15.

I need to insert to a table having full-text indexed column several thousands rows per day. To speed up the insert, I run

ALTER TABLE DISABLE KEYS

before insertion to stop full text index update during insertion. After insertion, run

ALTER TABLE ENABLE KEYS

to rebuild the full text index.

There is only insert operation; no delete or update run on this table.

The problem is during the insertion, the full text search ability is also disabled.


Question:

Is there a way to stop full text index update during insertion, but still provide full text search ability using original index?



Edited 2 time(s). Last edit at 03/12/2006 12:36AM by Martin Feng.

Options: ReplyQuote


Subject
Views
Written By
Posted
Disable full-text Index update stops search services
5790
March 12, 2006 12:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.