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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]