13 messages in com.mysql.lists.mysqlRe: CREATE INDEX is sooo slow! any i...
FromSent OnAttachments
david16 Feb 2003 14:47 
Peter Grigor16 Feb 2003 14:58 
Jerry16 Feb 2003 15:00 
Peter Grigor16 Feb 2003 15:11 
Jerry16 Feb 2003 15:12 
david16 Feb 2003 15:13 
Peter Grigor16 Feb 2003 15:27 
david16 Feb 2003 15:39 
Michael T. Babcock16 Feb 2003 19:34 
Dan Nelson16 Feb 2003 20:46 
Sergei Golubchik17 Feb 2003 00:19 
Sergei Golubchik17 Feb 2003 00:30 
Michael T. Babcock17 Feb 2003 03:18 
Subject:Re: CREATE INDEX is sooo slow! any ideas?
From:david (sim@theworld.com)
Date:02/16/2003 03:13:01 PM
List:com.mysql.lists.mysql

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" <sim@theworld.com> To: <mys@lists.mysql.com> 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 <mysq@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-pgrigor=hoob@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php