MySQL Forums
Forum List  »  Full-Text Search

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


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

Written By
Full-Text index on a 40gb Table
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.