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 <serg@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
