List:General Discussion« Previous MessageNext Message »
From:Tom Date:May 12 2005 9:11am
Subject:stopped while creating index.
View as plain text  
Hey, all.

Hardware: Itiaum 2 with 1.3G cpu * 4 and 8G RAM.
OS: Red Hat Enterprise Advanced Server 3.0
Mysql: mysql-standard-4.0.24-gnu-ia64-glibc23

I created a index on a large table with more than 100,000,000 records by the following command.
mysql> create index scn_ra on twomass_scn (ra);

It went good within 20 hours although it costs nearly 8G RAM. Then it stopped and the err log say Warning: Enabling keys got errno 116, retrying. It has not gone on by now.
I cannot figure out why and I really appreciate any suggestion.

Thanks.



Eswine.

Thread
stopped while creating index.Tom12 May
  • RE: stopped while creating index.Partha Dutta12 May
    • Re: stopped while creating index.Tom13 May
      • Re: stopped while creating index.gerald_clark13 May