XF 1.2 Very slow search index rebuild

[Nnirvi]

Hi!

After a successful import, I've tried to rebuild the search index. Yesterday I started it pretty late and forum had around 60 active users at that moment. It started nicely but came to a crawl couple of hours later after indexing 1,5M messages.

This morning I cancelled it (it had made no significant improvement from 1,5M overnight) and started again, this time with a delay of 1 second. Again, it started nicely (this time forum was almost empty) and now it's taking 20 seconds per 500 messages.

Any ideas?

 

[Jake Bunce]

With 1.5 million posts you really need to use the Enhanced Search addon:

http://xenforo.com/help/enhanced-search/

The default search engine (fulltext) doesn't scale well to that many posts.

 

[rdn]

You should optimize your mysql config.
Make use of Innodb. Specifically, optimize Innodb.

 

[Mike]

Alternatively, if you really do want to continue with MySQL in this case (not really recommended), you will want to run:

ALTER TABLE xf_search_index DISABLE KEYS;

Rebuild the index and when it's complete run:

ALTER TABLE xf_search_index ENABLE KEYS;

This will cause MySQL to build the full text index in bulk so the insert will be much faster, though note that it could take some time to enable keys there.

 

[Nnirvi]

Ok, thanks for the tips!

 

[Nnirvi]

Enhanced search requires Elasticsearch, is this possible to install without root access to the server?

 

[rdn]

Enhanced search requires Elasticsearch, is this possible to install without root access to the server?

No.

 

[Nnirvi]

Ok, I'll just try Mike's method then. Thanks!