• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.1 Incomplete Import: xf_search_index

#1
Converted from vb4 to XF1.1

Import failed when during import/rebuild of the search index.

Attempted to rebuild search index and the server continued to time out.

Followed this: http://xenforo.com/community/thread...ch-index-for-a-large-site-experts-only.11195/

Accomplished this:

Code:
ALTER TABLE xf_search_index DISABLE KEYS;
And then ran the rebuild search index: successful

Attempted this:

Code:
ALTER TABLE xf_search_index ENABLE KEYS;
Server processed for 8-plus hours and eventually overloaded and started crashing.

Does anyone have any creative ideas on how to get my search index rebuilt?

Thanks!
 

Jake Bunce

XenForo moderator
Staff member
#2
How many posts? What kind of server?

Rebuilding the search index is an intensive process. It can take a long time on very large forums.
 

Jake Bunce

XenForo moderator
Staff member
#5
I'm wondering if I could just do this locally thru MAMP and re-insert it...
Nope. The fulltext indexes don't transfer when you copy a database between servers. The indexes have to be rebuilt.

edit - well maybe. I mean the indexes are built for each record that is inserted into the table (i.e. during the restore).

1.5 million posts.

I'm on CentOS
Shared or dedicated? If the server is crashing during that query then it may not have enough resources or may already be under load.
 

Jake Bunce

XenForo moderator
Staff member
#7
MySQL only has 512K of tmp space? Is that what you meant? That is very small and may slow down the rebuild. Try increasing it.

If you continue to have problems then I say post your my.cnf file (minus any sensitive info) and move this thread to the server forum.
 
#8
MySQL only has 512K of tmp space? Is that what you meant? That is very small and may slow down the rebuild. Try increasing it.

If you continue to have problems then I say post your my.cnf file (minus any sensitive info) and move this thread to the server forum.
Ooh, I mean 512,000,000! :) It's late, sorry!
 

Hoffi

Well-known member
#10
Oh... I have also 1.5 Mio Posts. And on my XEON QuadCore with 16GB RAM, the Query runs about one hour. During the rebuild the Load raised up to 6.