I meant buy the whole chain, its going to take a few cups !!!! Jerry
----- Original Message ----- From: "Peter Grigor" <[EMAIL PROTECTED]> To: "Jerry" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, February 16, 2003 11:11 PM Subject: Re: CREATE INDEX is sooo slow! any ideas? > Yes, and better go to the one across town to get it :) > > Peter > <^_^> > --------------------------------------------- > Peter Grigor > Hoobly Free Classifieds > http://www.hoobly.com > > > ----- Original Message ----- > From: "Jerry" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Sunday, February 16, 2003 6:00 PM > Subject: Re: CREATE INDEX is sooo slow! any ideas? > > > > 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 > > > > > --------------------------------------------------------------------- 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