: 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
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:
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
)
--
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