List:General Discussion« Previous MessageNext Message »
From:Peter Grigor Date:February 16 2003 10:58pm
Subject:Re: CREATE INDEX is sooo slow! any ideas?
View as plain text  
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
>
>

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