How often do you Repair/Optimize MySQL Tables

Discussion in 'vBulletin' started by Abhik, Nov 2, 2009.

0
  1. #1
    There is a option in vBulletin Admin Control Panel, i.e
    Maintenance > Repair/Optimize.

    How often shall I do it? I have about 110K posts, 205K members and about 20K daily unique visitors.
     
    Abhik, Nov 2, 2009 IP
  2. munnakv

    munnakv Active Member

    Messages:
    293
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    60
    #2
    I do it once or twice in a day.
    And when I get too many mails about "Vbulletin database error!!"
     
    munnakv, Nov 2, 2009 IP
  3. Bohra

    Bohra Prominent Member

    Messages:
    12,573
    Likes Received:
    537
    Best Answers:
    0
    Trophy Points:
    310
    #3
    Its not neccesary to do it..only if u face issues u can do it..
     
    Bohra, Nov 2, 2009 IP
  4. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #4
    You certainly don't need to do it twice a day. Generally I do it if there are issues with a table (you pretty much have to do it at that point), or when I upgrade MySQL to a new major version (5.0.xx to 5.1.xx for example).
     
    digitalpoint, Nov 2, 2009 IP
  5. Abhik

    Abhik ..:: The ONE ::..

    Messages:
    11,337
    Likes Received:
    606
    Best Answers:
    0
    Trophy Points:
    410
    Digital Goods:
    2
    #5
    Thanks..
    I normally do it once or twice a month. That means I can keep it that way.
     
    Abhik, Nov 3, 2009 IP
  6. Davidpoul

    Davidpoul Active Member

    Messages:
    50
    Likes Received:
    0
    Best Answers:
    1
    Trophy Points:
    51
    #6
    No need to do it twice a day. Do it if there are issues with a table or when you upgrade MySQL.
     
    Davidpoul, Nov 20, 2009 IP
  7. t2000q

    t2000q Prominent Member

    Messages:
    4,636
    Likes Received:
    192
    Best Answers:
    0
    Trophy Points:
    300
    Digital Goods:
    1
    #7
    I tend to do it only when I am editing or backing up my databases ...
     
    t2000q, Nov 26, 2009 IP
  8. hotalexa

    hotalexa Peon

    Messages:
    292
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #8
    I don't remember when was te last time:)
     
    hotalexa, Nov 26, 2009 IP