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.