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" <[EMAIL PROTECTED]> To: "'mySQL list'" <mysql@lists.mysql.com> 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:[EMAIL PROTECTED] > > Sent: Thursday, May 12, 2005 5:12 AM > > To: mysql@lists.mysql.com > > 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/[EMAIL PROTECTED] > > >
