Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Germany
    Posts
    17

    Unanswered: difference? ANALYZE, CHECK, REPAIR, OPTIMIZE

    Hi!

    I'm confused about the maintenance functions of MySQL. There are ANALYZE, CHECK, REPAIR and OPTIMIZE. So what are the differences? Which one should I use for nightly maintenance?

    Thanks in advance.

    roga
    Last edited by roga; 01-20-04 at 06:33.

  2. #2
    Join Date
    Sep 2002
    Location
    Montreal, Canada
    Posts
    224
    Provided Answers: 1

    Re: difference? ANALYZE, CHECK, REPAIR, OPTIMIZE

    Originally posted by roga
    Hi!

    I'm confused about the maintenance functions of MySQL. There are ANALYZE, CHECK, REPAIR and OPTIMIZE. So what are the differences? Which one should I use for nightly maintenance?

    Thanks in advance.

    roga
    ANALYZE is used to update the statistics table so MySQL uses the indexes more intelligently

    REPAIR is used to repair corrupted tables

    OPTIMIZE is used to "defragment" the tables (after lots of INSERT/UPDATE/DELETE)

    CHECK is used to verify is a table is corrupted in any way... Useful to verify that after a server is stopped abruptely, all tables were closed properly

  3. #3
    Join Date
    Jan 2004
    Location
    Germany
    Posts
    17
    Thank you!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •