What type of table is this? MyISAM or InnoDB?
What are your system variable settings when you issued the CREATE INDEX
command?
If this is a MyISAM table, then MySQL will spend time re-creating the data
file first before creating ALL of the indexes including the new one.
If you already have indexes on the table, you can speed up some of the
processing time:
SET SESSION myisam_repair_threads = 2;
(This will enable parallel index build for the indexes)
SET SESSION myisam_sort_buffer_size = SOME LARGE VALUE;
(This buffer will be used during the CREATE INDEX for sorting MyISAM
indexes)
--
Partha Dutta, Senior Consultant
MySQL Inc, NY, USA, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
> -----Original Message-----
> From: Tom [mailto:zhaoh@stripped]
> Sent: Thursday, May 12, 2005 5:12 AM
> To: mysql@stripped
> Subject: stopped while creating index.
>
> 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.
