Another coffee ? I'd buy Starbucks .............
Jerry ----- Original Message ----- From: "Peter Grigor" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "david" <[EMAIL PROTECTED]> Sent: Sunday, February 16, 2003 10:58 PM Subject: Re: CREATE INDEX is sooo slow! any ideas? > 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" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > 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 <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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