Problem re-indexing search database

[TS | Julio]

A few weeks ago I had a few users of my board complaining because of the minimum 4 word lenght in the search area. So, I tried changing this on the forums CP and then tried reindexing (I did clear the index first).

The problem I'm having is that the reindexing times out everytime and it tipically does in the thread id#667, which is a 165 page large topic, tipical word association forum game.

How can I prevent the reindexing from timing out? Right now the search feature is not working properly as a result.

[MUG]

Reduce the number of threads per cycle to 50, this should help.

[George L]

there's a few things you can do

- optimising mysql configuration
- increasing php time out value, max_execution_time in your server's php.ini configuration file i.e. set it to 180 seconds
- specifying smaller sets of threads to index at a time or maybe doing that specific thread last by specifying start and end thread id values
- running reindexing with forum closed and at the lowest load of traffic on your server

if you want a tune up please provide the following

1. your server specs, such as mysql and php version
2. if possible how mysql was compiled/installed
3. your top stats
4. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf if on Windows server if you don't have that file you need to log into telnet and as root user type

mysqladmin -u root -p variables

copy and paste output here

5. your mysql extended-status output either still telnet as root user type

mysqladmin -u root -p extended-status

copy and paste output here

or preferred is to installed extended-status output script which is located at http://vbulletin.com/forum/showthread.php?threadid=3477

and post url to that here

6. oh and is your vB the only thing on the server? or other scripts? sites?

7. how many average and max concurrent users on your vB forum ?

8. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site

<?
phpinfo();
?>

i.e. yourdomain.com/phpinfo.php

[TS | Julio]

Thanks for the help, I'm the process of correctly reindexing now