Thank you, Partha.
What I really meant was that the process of creating index was stopped and I couldn't figure out and search out the log meaning 'Warning: Enabling keys got errno 116, retrying'. So I am not sure I will run into such problem next time.
----- Original Message -----
From: "Partha Dutta" <partha@stripped>
To: "'mySQL list'" <mysql@stripped>
Sent: Thursday, May 12, 2005 6:23 PM
Subject: RE: stopped while creating index.
> 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.
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=zhaoh@stripped
>
>
>
