Hi! On Feb 16, david wrote: > > Hi > > I have one table with 12 million records. I'm trying to create an index > on one of the fields and it's taking hours ( over 6 so far)! Am I doing > something wrong? > > The command I issued was > create index title on article ( title); > > The table files are > -rwxrwxrwx 1 mysql mysql 8646 Feb 14 17:32 article.frm > -rwxrwxrwx 1 mysql mysql 1406663720 Feb 14 23:27 article.MYD > -rwxrwxrwx 1 mysql mysql 69661696 Feb 14 23:27 article.MYI > > As you can see the main file is 1.4Gb > > The table definition is > mysql> show columns from article; > +-----------+--------------+------+-----+---------+-------+ > | Field | Type | Null | Key | Default | Extra | > +-----------+--------------+------+-----+---------+-------+ > | ID | bigint(20) | YES | | NULL | | > | id2 | bigint(20) | YES | | NULL | | > | title | varchar(250) | YES | | NULL | | > | body | text | YES | MUL | NULL | | > +-----------+--------------+------+-----+---------+-------+ > 4 rows in set (0.00 sec) > > I'm running this on linux redhat 7.3, P500Mhz 512Mb ram -- MySQL version > 3.23.53a
Use MySQL-4.x In 3.23 creating FULLTEXT index can easily take months, not hours. In 4.0 this process is ~80-100 times faster. Regards, Sergei -- MySQL Development Team __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php