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:
age -
From: "Partha Dutta" <[EMAIL PROTECTED]>
To: "'mySQL list'"
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 t
)
--
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
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
