MySQL Forums
Forum List  »  Full-Text Search

Full-Text index on a 40gb Table
Posted by: gene sigalov
Date: October 04, 2007 11:08AM

Guys,

I'm trying to do a full text index on 5 columns in a 40gb table. The columns total about 38gb. THe machine is a dual 2.8ghz xeon with 3gb memory and myisam_sort_buffer_size was set to 2gb.

As I watched the temp files grow I realized that it would take close to a month to index this table. Is this normal? Does anyone have any suggestions? Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
Full-Text index on a 40gb Table
3937
October 04, 2007 11:08AM


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.