List:General Discussion« Previous MessageNext Message »
From:david Date:February 16 2003 11:40pm
Subject:Re: CREATE INDEX is sooo slow! any ideas?
View as plain text  
Thanks.  So, after I've travelled to Seattle to get my coffee, do you think 
that creating this index will speed up the select queries?

Would it be faster if I had created separate tables and indexed them 
individually?

What is the thoughts about searching text fields for text.  Is it best to 
store the text in a text field or is it best to tokenize out the terms and 
create a word table with index?

Thanks
David


At 06:27 PM 2/16/2003 -0500, Peter Grigor wrote:
>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
> >
> >
>
>
>---------------------------------------------------------------------
>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-thread132550@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