two servers were having the same problem and they each have 1GB of space in the temp dir.
I was able to fix the problem by recreating the biggest table in the database. The total
space in each database is 350MB. The deleted table's size was 500kb. The mysql version
is 5.0.51a. I am afraid that when the table gets to that size it is going to crapped out
again. Is there anything that I may not be taking into consideration.
--- On Thu, 7/9/09, kabel <lists@stripped> wrote:
> From: kabel <lists@stripped>
> Subject: Re: Table problem
> To: mysql@stripped
> Date: Thursday, July 9, 2009, 11:07 AM
> On Thursday 09 July 2009 01:56:37 pm
> Zakai Kinan wrote:
> > I have been getting this error on a
> database: Incorrect key file for
> > table '/tmp/#sql_a99_0.MYI'; try to repair it.
> How do I know which table
> > is causing this error?
> > TIA,
> > ZK
> You could be running out of space on your temp partition..
> if a query is
> either creating an explicit temporary table or generating
> one as part of
> execution, it may be filling it up.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1