List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:August 1 1999 9:52pm
Subject:[Q]should I 'rebuild' the indexes frquently?
View as plain text  
>>>>> "sinisa" == sinisa  <sinisa@stripped> writes:

sinisa> Silver CHEN writes:
>> Dear Sir:
>> 
>> I've a simple question for mySQL:
>> 
>> Should I 'rebuild' the indexed frequently? In some products, the manual
>> suggests that
>> the indexes should be maintianed by the administratot himself, is this true
>> for mySQL?
>> 
>> Thanks for your help
>> 
>> Regards.
>> 
>> --
>> +~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+
>> |    Shan-Ta CHEN                    E-Mail : sansil@stripped   |
>> |    Silver CHEN                     Tel(O) : +886-2-2773-9858-288   |
>> |    ³¯µ½¹F                          Tel(H) :
> +886-2-2914-1402       |
>> +~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+

sinisa> You should run periodically isamchk.   

sinisa> The best way to do it is to make a cron job which would shotdown
sinisa> server, run isamchk and restart a server.

sinisa> Sinisa

Hi!

It depends on what you do; If you don't delete big blocks of data and
don't reuse these at once or have dynamic length rows that are updated
a lot, then you need to run isamchk (or OPTIMIZE TABLE) once in a
while.  If not, you don't need to run isamchk.  You can find a lot
more information about this in the MySQL manual!

Regards,
Monty

Thread
[Q]should I 'rebuild' the indexes frquently?Silver CHEN21 Jul
  • [Q]should I 'rebuild' the indexes frquently?sinisa22 Jul
    • [Q]should I 'rebuild' the indexes frquently?Michael Widenius2 Aug