OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: Table problem

From: kabel (listsvoidship.net)
Date: Thu Jul 09 2009 - 13:07:08 CDT


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.

kabel

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql