List:General Discussion« Previous MessageNext Message »
From:Peter Grigor Date:February 16 2003 11:27pm
Subject:Re: CREATE INDEX is sooo slow! any ideas?
View as plain text  
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" <simoon@stripped>
To: "Peter Grigor" <pgrigor@stripped>; <mysql@stripped>
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" <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
> > >
> > >
>
>
> ---------------------------------------------------------------------
> 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-thread132546@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-paul.harrison=eweb.eugene.or.us@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>

Thread
CREATE INDEX is sooo slow! any ideas?david16 Feb
  • Re: CREATE INDEX is sooo slow! any ideas?Peter Grigor16 Feb
    • Re: CREATE INDEX is sooo slow! any ideas?david17 Feb
  • Re: CREATE INDEX is sooo slow! any ideas?Jerry17 Feb
  • Re: CREATE INDEX is sooo slow! any ideas?Peter Grigor17 Feb
  • Re: CREATE INDEX is sooo slow! any ideas?Jerry17 Feb
  • Re: CREATE INDEX is sooo slow! any ideas?Peter Grigor17 Feb
    • Re: CREATE INDEX is sooo slow! any ideas?david17 Feb
      • Re: CREATE INDEX is sooo slow! any ideas?Michael T. Babcock17 Feb
        • Re: CREATE INDEX is sooo slow! any ideas?Dan Nelson17 Feb
          • Re: CREATE INDEX is sooo slow! any ideas?Sergei Golubchik17 Feb
            • Re: CREATE INDEX is sooo slow! any ideas?Michael T. Babcock17 Feb
  • Re: CREATE INDEX is sooo slow! any ideas?Sergei Golubchik17 Feb
Re: CREATE INDEX is sooo slow! any ideas?Sebastian Stan27 Feb
  • Re: CREATE INDEX is sooo slow! any ideas?Sergei Golubchik27 Feb