Professional Web Applications Themes

How to schedule non-interrupt OPTIMIZE commands? - MySQL

Some questions: 1. How to schedule non-interrupt/min-interrupt OPTIMIZE commands? Any best practices? Assuming MySQL master-slave setup, with MyISAM 2. Is it important to reorganizing the table for MyISAM, something like the REORG in other DMBS? Thanks....

  1. #1

    Default How to schedule non-interrupt OPTIMIZE commands?

    Some questions:

    1. How to schedule non-interrupt/min-interrupt OPTIMIZE commands? Any
    best practices? Assuming MySQL master-slave setup, with MyISAM

    2. Is it important to reorganizing the table for MyISAM, something
    like the REORG in other DMBS?

    Thanks.

    howa Guest

  2. #2

    Default Re: How to schedule non-interrupt OPTIMIZE commands?

    howa wrote: 

    there are different ways of scheduling the optimize command to run on
    either the master and/or slave. i'd like to run optimize locally (does
    not write to bin log) on my tables. depending upon what os your work out
    of, you can write a shell and/or bat file to accomplish this and then
    schedule it to run either with cron and/or windows scheduler.

    it is important to reorg myisam tables specially if the table is
    volatile (a lot of write and delete).

    --
    lark -- net
    To reply to me directly, delete "despam".
    lark Guest

  3. #3

    Default Re: How to schedule non-interrupt OPTIMIZE commands?

    On 5月21日, 下午9時19分, lark <.net> wrote: 

    optimize on the slave would be more easy as i can just point to
    another slave db.
    but do you think master also need to optimize? i mean if i don't
    optimize the master for long time, will write performance suffer?

     

    may i know how to do `reorg` in mysql?

    thanks.......

    howa Guest

  4. #4

    Default Re: How to schedule non-interrupt OPTIMIZE commands?

    howa wrote: 
    >
    > optimize on the slave would be more easy as i can just point to
    > another slave db.
    > but do you think master also need to optimize? i mean if i don't
    > optimize the master for long time, will write performance suffer?
    >

    >
    > may i know how to do `reorg` in mysql?
    >
    > thanks.......
    >[/ref]
    you run the optimize command on the table like this:

    optimize table t1;

    that'll do it.

    --
    lark -- net
    To reply to me directly, delete "despam".
    lark Guest

  5. #5

    Default Re: How to schedule non-interrupt OPTIMIZE commands?

     

    yes but seems reorg in other db do more then just optimize...thanks
    anyway











    howa Guest

Similar Threads

  1. sio clock interrupt problem
    By Richard Jones in forum FreeBSD
    Replies: 0
    Last Post: February 22nd, 01:13 PM
  2. CFString interrupt safe?
    By Carl in forum Mac Programming
    Replies: 3
    Last Post: February 3rd, 03:08 PM
  3. sending interrupt
    By Ramprasad A Padmanabhan in forum PERL Beginners
    Replies: 2
    Last Post: September 4th, 02:54 AM
  4. How to get interrupt from the parallell port
    By Lars in forum Sun Solaris
    Replies: 2
    Last Post: August 13th, 07:43 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139