yes, this is the default folder its configured.
On 6/12/08, Boyd, Todd M. <[EMAIL PROTECTED]> wrote: > > From: Ananda Kumar [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 12, 2008 10:27 AM > To: Boyd, Todd M. > Cc: mysql > Subject: Re: enable and disable keys > > /tmp has 16GB free space > On 6/12/08, Boyd, Todd M. <[EMAIL PROTECTED]> wrote: > > -----Original Message----- > > From: Ananda Kumar [mailto:[EMAIL PROTECTED] > > Sent: Thursday, June 12, 2008 9:41 AM > > To: [EMAIL PROTECTED] > > Cc: mysql > > Subject: Re: enable and disable keys > > > > We have 200GB of free space on the file system where our database is > > located. > > > > ---8<--- snip > > If the system is *nix, there's a high probability that the area used for > temporary storage (unless specifically defined by a MySQL configuration) > and the area that houses your database files are on different > partitions--possibly even different storage devices altogether. > > Is this the case? > > > >> Enable kyes goes fine for couple of hrs with "REPAIR BY TMP", but > > then > > >> switches to "REPAIR BY KEYCACHE" and writes a log in the error log > > >> file "Warning: > > >> Enabling keys got errno 28, retrying" > > >> > > >> What could be the problem. > > >> > > >> System has 8 cpu and 16GB RAM > > >> > > >> I have set myisam_max_sort_file_size=98GB > > >> myisam_sort_buffer_size=750MB. > > >> > > >> /tmp folder has 16GB free space. > > ---8<--- snip > > > > OS error code 28: No space left on device > > > > > > I would say you are running out of space. > > Sorry if this question is "stupid," but... okay, your /tmp folder has 16GB > available for use. Is this the folder that MySQL has been configured to use? > I understand that it should be by default, but it doesn't hurt to examine > every facet of a problem with confusing roots. > > > Todd Boyd > Web Programmer > > > >