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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
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
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--_5539918e-f58a-4db8-8012-aa07720b2295_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
run a quick df
>df
Martin Gainty=20
______________________________________________=20
Verzicht und Vertraulichkeitanmerkung/Note de d=E9ni et de confidentialit=
=E9
=20
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaeng=
er sein=2C so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiter=
leitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient l=
ediglich dem Austausch von Informationen und entfaltet keine rechtliche Bin=
dungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen w=
ir keine Haftung fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut =EAtre privil=E9gi=E9. Si vous n'=EAtes=
pas le destinataire pr=E9vu=2C nous te demandons avec bont=E9 que pour sat=
isfaire informez l'exp=E9diteur. N'importe quelle diffusion non autoris=E9e=
ou la copie de ceci est interdite. Ce message sert =E0 l'information seule=
ment et n'aura pas n'importe quel effet l=E9galement obligatoire. =C9tant d=
onn=E9 que les email peuvent facilement =EAtre sujets =E0 la manipulation=
=2C nous ne pouvons accepter aucune responsabilit=E9 pour le contenu fourni=
..
> From: lists@voidship.net
> To: mysql@lists.mysql.com
> Subject: Re: Table problem
> Date: Thu=2C 9 Jul 2009 14:07:08 -0400
>=20
> 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'=3B try to repair it. How do I know which t=
able
> > is causing this error?
> >
> >
> > TIA=2C
> >
> > ZK
>=20
> You could be running out of space on your temp partition.. if a query is=
=20
> either creating an explicit temporary table or generating one as part of=
=20
> execution=2C it may be filling it up.
>=20
> kabel
>=20
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmgainty@hotmail.c=
om
>=20
____________________________________________________________ _____
Hotmail=AE has ever-growing storage! Don=92t worry about storage limits.=20
http://windowslive.com/Tutorial/Hotmail/Storage?ocid=3DTXT_T AGLM_WL_HM_Tuto=
rial_Storage_062009=
--_5539918e-f58a-4db8-8012-aa07720b2295_--
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 tab=
le in the database. The total space in each database is 350MB. The delete=
d 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 ther=
e anything that I may not be taking into consideration.
=0AThanks,=0A=
ZK
=0A--- On Thu, 7/9/09, kabel
=0A> From: kabel
: mysql@lists.mysql.com=0A> Date: Thursday, July 9, 2009, 11:07 AM=0A> On T=
hursday 09 July 2009 01:56:37 pm=0A> Zakai Kinan wrote:=0A> > =A0I hav=
e been getting this error on a=0A> database:=A0 Incorrect key file for=0A> =
> table '/tmp/#sql_a99_0.MYI'; try to repair it.
> How do I know which=
table=0A> > is causing this error?=0A> >=0A> >=0A> > TIA,=0A> >=0A> > ZK=
=0A> =0A> You could be running out of space on your temp partition..=0A> if=
a query is =0A> either creating an explicit temporary table or generating=
=0A> one as part of =0A> execution, it may be filling it up.=0A> =0A> kabel=
=0A> =0A> -- =0A> MySQL General Mailing List=0A> For list archives: http://=
lists.mysql.com/mysql=0A> To unsubscribe:=A0 =A0 http://lists.mysql.com/mys=
ql?unsub=3Dtitanyen2000@yahoo.com=0A> =0A>
=0A
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg