Re: Repeated "repair table ... quick" takes same amount of time (long) under 4.1.7

2004-12-13 Thread Gleb Paharenko
Hello REPAIR QUICK is a recommended method to rebuild FULLTEXT indexes. See: http://dev.mysql.com/doc/mysql/en/Fulltext_Fine-tuning.html Haitao Jiang <[EMAIL PROTECTED]> wrote: > Hi, > > If I remember correctly, if table is ok, then if one does a table > repair, the command should ret

Repeated "repair table ... quick" takes same amount of time (long) under 4.1.7

2004-12-08 Thread Haitao Jiang
Hi, If I remember correctly, if table is ok, then if one does a table repair, the command should return immediately. I have a table with 14 million rows, and I repeated table repair (quick) 3 times, it took the same amount of time (55 min). It is almost the same time as if I built the index from s