Announcement

Collapse
No announcement yet.

Rebuilding index's to enable Fulltext 3 character word search on 1 million post forum

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

  • Rebuilding index's to enable Fulltext 3 character word search on 1 million post forum

    Any tips on getting it done?

    Things to watch out for?

    Thanks in advance,

  • #2
    Decide when you're going to run the the "REPAIR TABLE ... QUICK;" statements (preferably at an off-time for your board so that you don't anger too many users), shut down httpd so you don't end up tapping out all of your mysql connections, and fire away.

    With only 1 million posts you should be able to repair both the `post` and `thread` tables within 10 minutes or so (less if the server is fast and well optimized) but for those 10 minutes your board is going to be unavailable.
    Jason Litka - Utter Ramblings

    Comment

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