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 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 scratch. > > Any idea? The table seems ok for query as I checked. This is under > MySQL 4.1.7, MyISAM table with full text indexes. > > Thanks > > Haitao > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
