Yes it is but why would that slow down index creation on the other field.
The full text index is just for the body field.
Thanks
At 05:58 PM 2/16/2003 -0500, Peter Grigor wrote:
>That body column wouldn't happen to be a fulltext index, would it? :)
>
>If so, 'ave another coffee.
>
>Peter
><^_^>
>---------------------------------------------
>Peter Grigor
>Hoobly Free Classifieds
>http://www.hoobly.com
>
>
>----- Original Message -----
>From: "david" <simoon@stripped>
>To: <mysql@stripped>
>Sent: Sunday, February 16, 2003 5:47 PM
>Subject: CREATE INDEX is sooo slow! any ideas?
>
>
> >
> > 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
> >
> > Thanks
> > David
> >
> >
> >
> > ---------------------------------------------------------------------
> > 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 <mysql-thread132539@stripped>
> > To unsubscribe, e-mail
><mysql-unsubscribe-pgrigor=hoobly.com@stripped>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
