1. 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

Discussion in 'Installation, Upgrade, and Import Support' started by Douglas Taylor, Dec 30, 2011.

  1. Douglas Taylor

    Douglas Taylor Active Member

    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!
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    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.
     
  3. Douglas Taylor

    Douglas Taylor Active Member

    1.5 million posts.

    I'm on CentOS
     
  4. Douglas Taylor

    Douglas Taylor Active Member

    I'm wondering if I could just do this locally thru MAMP and re-insert it...
     
  5. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    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).

    Shared or dedicated? If the server is crashing during that query then it may not have enough resources or may already be under load.
     
  6. Douglas Taylor

    Douglas Taylor Active Member

    Dedicated. 512K tmpdsk, so perhaps that might part of the problem. Kind of at wits end.
     
  7. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    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. Douglas Taylor

    Douglas Taylor Active Member

    Ooh, I mean 512,000,000! :) It's late, sorry!
     
  9. Douglas Taylor

    Douglas Taylor Active Member

    And that's it.
     
  10. Hoffi

    Hoffi Well-Known Member

    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.
     
  11. Douglas Taylor

    Douglas Taylor Active Member

    Did it eventually finish?
     

Share This Page