XF 2.0 rebuilding search index is taking forever

[KSA]

we have a large forum with ~ 2.5ml posts and we tried to rebuild search index multiple times with no luck. its takes about 2 hrs doing the processing and then stops, throwing 502, 504 error and sometime giving MySQL server has gone away.

Any idea how to fix this. we have tried to ALTER TABLE xf_search_index DISABLE KEYS; and then run it again but same issue keeps popping up again and again.

 

[Robru]

Have you tried it with the command line options?

 

[KSA]

Have you tried it with the command line options?

I have not tried that yet. I would appreciate if you can post the appropriate command.

 

[Robru]

cd /var/www/html/community/

php cmd.php xf-rebuild:search

Obviously enter your own server data in the first line

 

[AndyB]

we have a large forum with ~ 2.5ml posts

You should be using Enhanced search.

 

[KSA]

cd /var/www/html/community/

php cmd.php xf-rebuild:search

Obviously enter your own server data in the first line

can this be done through phpmyadmin?

 

[KSA]

You should be using Enhanced search.

Im not able to understand how to install elastic search considering we don't have ssh access.

 

[Robru]

Im not able to understand how to install elastic search considering we don't have ssh access.

Then you can request this from the support department of your hosting company, if you do not have the option to do this yourself.

 

[KSA]

Then you can request this from the support department of your hosting company, if you do not have the option to do this yourself.

This was posted three years ago...I have grown a pair since then.