Re: stopped while creating index.
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]
Re: stopped while creating index.
Tom wrote: 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. perror 116 Error code 116: Stale NFS file handle You aren't trying to use NFS to store your tables are you? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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.
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]
