yes... if it take more then 30-40 minutes, it is better to drop fulltext index, do flush, repair table, optimise table and after it try to create index again.
PS on one my friend's forum with ~1.6mln posts it took 28 minutes to create index :)

Took me 9 hours and 30 minutes to index.

Now I can't post or delete threads :(

Btw, was reindexing through a mysql shell prompt not vbulletin.

then what error message you have when you "can't post or delete threads"?
and i still think that 9 hours is not normal...
and still recommend to try again

ALTER TABLE post DROP INDEX pagetext
after it
ALTER TABLE post DROP INDEX title
after it
FLUSH TABLE post
after it
REPAIR TABLE post
after it
ALTER TABLE post ADD FULLTEXT (title)
after it
ALTER TABLE post ADD FULLTEXT (pagetext)
and after it
OPTIMIZE TABLE post

Nearly sure that it must take less then hour summary :)

Running a dedicated server only hosting the forum, P4 2.4ghz 1.5 gigs RAM, 1.3 million posts.

Right now I'm getting ready to revert back to my backed up database.

Takes forever to try and drop indexes, and/or repair table.

hmm question whats in this hack that makes getting unanswered posts impossible

ie this hack should be simple but each time it returns 0 results

https://vborg.vbsupport.ru/showthrea...095#post491095

Did you shut down your board while altering the tables? If there are queries waiting for access to the post table while it is locked, your machine load will grow high and higher. This has an affect on ALL tasks running on your machine, incl. creating the index columns at your post table.

rikman

Any other large forums tried this yet? :)

http://www.wass-up.com/forum/

has it installed i helped with the installation of it and we've not had any problems with it but there is one sacrifice which is similar threads
they don't seem to work with this hack

The "Unanswered Threads" hack doesn't work with it, either, I am told.