How often do you need to check and optimize your database?

Discussion in 'Managing Your Online Community' started by Soliloquy, Jun 10, 2009.

  1. Soliloquy

    Soliloquy Regular Member

    Joined:
    Jun 3, 2009
    Messages:
    2,402
    Likes Received:
    66
    Location:
    New York City
    So far I've only been checking and optimizing my database tables every few months, or if there's a noticeable problem. I had read that it was best not to repair/optimize them if the overhead was only a few kb, so I only repair the ones that are 5kb or larger. What's your procedure?
     
  2. Wayne Luke

    Wayne Luke Regular Member

    Joined:
    Apr 2, 2009
    Messages:
    992
    Likes Received:
    276
    Repair? I never do unless it reports that there is a crashed table. I haven't had a crashed table in years because I primarily use InnoDB.

    Optimize? Only when you delete large quantities of data from your database. It provides no benefit otherwise.
     

Share This Page