Re: indexing operation running for few hours

[Brent Baisley]

Your key_buffer_size and sort_buffer_size configuration variables play 
a role in the speed of your indexes, including creation and 
modification. If these are set low, creating an index can be pretty 
slow. 43 minutes seems like and extremely long time to create an index 
on only 160K records. It took me about two minutes to create an index 
on a date field on a table with 100K records. This was on a 1.3Ghz Mac 
laptop.

I would stop the indexing process, adjust your configuration variables, 
restart MySQL and try the indexing again.

On Jan 20, 2005, at 10:06 AM, sam wun wrote:
Hi,
I don't know what is wrong with running indexing on this table. It 
have been last for nearly 3 hours.
here is the command I run at the prompt of mysql> :
alter table inventory add index(basename);

Because it is running indexing, all operation seems hang up.
As far as I can remember I only injected 2300+ records in this table, 
compared to the transaction table in the same database which has 
160000 records ,this table is a tiny one in size. I run index on the 
trasactoin table, and it only took 43 min finishsed indexting on the 
date field.

Can anybody tell me what is going on?
Thanks
Sam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/[EMAIL PROTECTED]


--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]