List:General Discussion« Previous MessageNext Message »
From:Jerry Date:February 16 2003 11:12pm
Subject:Re: CREATE INDEX is sooo slow! any ideas?
View as plain text  
I meant buy the whole chain, its going to take a few cups !!!!

Jerry


----- Original Message -----
From: "Peter Grigor" <pgrigor@stripped>
To: "Jerry" <jerry@stripped>; <mysql@stripped>
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" <jerry@stripped>
> To: <mysql@stripped>
> 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" <pgrigor@stripped>
> > To: <mysql@stripped>; "david" <simoon@stripped>
> > 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" <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-thread132540@stripped>
> > > To unsubscribe, e-mail
> > <mysql-unsubscribe-jerry=metalcat.net@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-thread132541@stripped>
> > To unsubscribe, e-mail
> <mysql-unsubscribe-pgrigor=hoobly.com@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