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
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 indexe
