Announcement

Collapse
No announcement yet.

Problem re-indexing search database

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Problem re-indexing search database

    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.
    Julio Franco
    TechSpot.com

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

    Comment


    • #3
      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
      :: Always Back Up Forum Database + Attachments BEFORE upgrading !
      :: Nginx SPDY SSL - World Flags Demo [video results]
      :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

      Comment


      • #4
        Thanks for the help, I'm the process of correctly reindexing now
        Julio Franco
        TechSpot.com

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X