Announcement

Collapse
No announcement yet.

What happens when a thread is moved?

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

  • What happens when a thread is moved?

    The steps vbulletin takes in moving a thread from one forum to another. The issue is that we have several threads that are very active. It's been recommended to close large threads to keep the load down, which is cool with me. So threads that hit 10,000 posts are locked and moved to a separate forum.

    However, whenever this happens the board seizes up and is unusable for quite a while (too many connections errors). I'm curious as to all the steps that are taken to move a thread that would cause such a high load.

  • #2
    Moving or copying?

    Moving shouldn't do anything except for changing the forum ID on the thread and post records. Though locking the thread should be enough if you just want to remove it from circulation at 10,000 posts. I don't see why you think you need to move it.

    Copying can do all sorts of intensive things.

    Make sure that the Duplicate Search Index Information on Thread Copy? is set to no.

    vBulletin Options -> vBulletin Options -> Server Settings and Optimization Options.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API - Full / Mobile
    Vote for your favorite feature requests and the bugs you want to see fixed.

    Comment


    • #3
      Originally posted by Wayne Luke View Post
      Moving or copying?

      Moving shouldn't do anything except for changing the forum ID on the thread and post records. Though locking the thread should be enough if you just want to remove it from circulation at 10,000 posts. I don't see why you think you need to move it.

      Copying can do all sorts of intensive things.

      Make sure that the Duplicate Search Index Information on Thread Copy? is set to no.

      vBulletin Options -> vBulletin Options -> Server Settings and Optimization Options.
      Definitely moving. It's not really seeing a need to move it, it was more for organizational purposes (which I agree, the reasoning even for that is weak at best).

      Would query time be affected with such a move when the post table is probably 3,000,000ish posts?

      Thanks for the response, too!

      Comment


      • #4
        Originally posted by Wayne Luke View Post
        Moving or copying?

        Moving shouldn't do anything except for changing the forum ID on the thread and post records. Though locking the thread should be enough if you just want to remove it from circulation at 10,000 posts. I don't see why you think you need to move it.

        Copying can do all sorts of intensive things.

        Make sure that the Duplicate Search Index Information on Thread Copy? is set to no.

        vBulletin Options -> vBulletin Options -> Server Settings and Optimization Options.
        Wayne, would either moving or copying generate a notification email if the target location has an "email address to notify" set up?

        Bill

        Comment


        • #6
          Originally posted by whelck View Post
          Would query time be affected with such a move when the post table is probably 3,000,000ish posts?
          Posts don't reference a forum so it shouldn't be even access the entire post table for the move as far as I am aware.

          Three things happen:

          1) The forumid in the thread table is updated.

          2) If a redirect is created then a new thread object is created and flagged to redirect to the old thread.

          3) The last post of the forum is updated.

          It would most likely be #3 that causes the time consumption. It doesn't occur on this forum though. Granted we don't have 3 million posts but at almost 1.7 million posts, I would anything noticeable would have started rearing its ugly head.

          One thing you could do is run the slow query log in MySQL and move a few threads causing the problems then we can look at those queries to see if they can be improved.

          See:
          http://dev.mysql.com/doc/refman/5.1/...query-log.html
          Translations provided by Google.

          Wayne Luke
          The Rabid Badger - a vBulletin Cloud demonstration site.
          vBulletin 5 API - Full / Mobile
          Vote for your favorite feature requests and the bugs you want to see fixed.

          Comment


          • #7
            Originally posted by Wayne Luke View Post
            Posts don't reference a forum so it shouldn't be even access the entire post table for the move as far as I am aware.

            Three things happen:

            1) The forumid in the thread table is updated.

            2) If a redirect is created then a new thread object is created and flagged to redirect to the old thread.

            3) The last post of the forum is updated.

            It would most likely be #3 that causes the time consumption. It doesn't occur on this forum though. Granted we don't have 3 million posts but at almost 1.7 million posts, I would anything noticeable would have started rearing its ugly head.

            One thing you could do is run the slow query log in MySQL and move a few threads causing the problems then we can look at those queries to see if they can be improved.

            See:
            http://dev.mysql.com/doc/refman/5.1/...query-log.html
            Thanks for the update! I'll take a look at the slow query log and see what other information I can gather.

            Comment

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