XF 1.1 Search Indexing after Import - Runaway count

[MRaburn]

I just migrated to Xen today! Yay!

I was letting the search index build and about 3 hours in when it got to be over 3.5Gb big and had over 8mil posts indexed when I only have around 4mil messages I just stopped the indexing.

Search function works but Im not sure what happened. The index table is bigger than the post table.

Any suggestions on how to clear it out and rerun the index?

Thanks!
Mike

 

[Floris]

Are you doing the indexing via command line, or via the admin.php ?
For a size like this, I recommend using CLI.

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

 

[MRaburn]

I am attempting this method now, thanks!



Mike

 

[MRaburn]

I rebuilt the table. I had truncated the data first or after I removed the keys, not sure, because when I ran the Enable Keys, the query ran OK and 0 rows affected.

Here is what this table stucture looks like, just wanted to see if someone see's anything wrong at this point, as search is working.