[Forum] How do I tell VB to reindex or repair searching?

[Zackw]

Hi guys, we upgraded from 3x to 4x and then moved the database to a fresh install of VB on another server.

I know the search indexing system changed from 3x to 4x but what's happening is that VB is not able to search for anything from before the move. It's not indexing "backwards", as it were. It's only finding threads and posts that have been created since the move.

If I'm not mistaken, VB uses the MySQL index right? So is there some query I can run in MySQL or VB maintenance script that will cause the index to be created for the entire database and not just the newly created threads/posts?

Should I look in to a different search subsystem like Sphinx or something?

[Steve Machol]

You need to rebuild the search index:

Admin CP -> Maintenance -> Update Counters -> Rebuild Search Index

[Zackw]

Isn't the search index part of MySQL or does VB actually have to process that?

We have about 400 users online regularly I'm wondering how much of a performance hit we'll have to run that. And how long it would take. Does VB do it or does MySQL do it in the background without VB's help?

[Trevor Hannant]

How many posts/threads do you have?

[Zackw]

68,000 Threads, 950,000 posts. 300-400 users on any given time, most users online over 2,400.

What kind of hit can I expect?