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.