Well, MySql stores all its index information in one index file, so when you add another index it has to rebuild the WHOLE file. :)
Peter <^_^> --------------------------------------------- Peter Grigor Hoobly Free Classifieds http://www.hoobly.com ----- Original Message ----- From: "david" <[EMAIL PROTECTED]> To: "Peter Grigor" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, February 16, 2003 6:13 PM Subject: Re: CREATE INDEX is sooo slow! any ideas? > 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" <[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
