tmpdir running out of space

--0015174c108c6132e50498f0edaa
Content-Type: text/plain; charset=ISO-8859-1

Hello, everybody!

I'm new to MySQL, and I hope somebody can help me.
I have a 3.7G database and a 10G tmpdir.
Sometimes the tmpdir runs out of space, and I get the following message on
the logs:
[ERROR] /usr/libexec/mysqld: Incorrect key file for table
'/tmp/tmpdir/#sql_22f_33.MYI'; try to repair it
Server load increases a lot, and MySQL eventually crashes.
My question is: how can I find out what query is using so much tmpdir space?
How much space should I allocate to this disk?

Santiago Soares
Fone: (41) 8488-0537

--0015174c108c6132e50498f0edaa--

Re: tmpdir running out of space

> I'm new to MySQL, and I hope somebody can help me.
> I have a 3.7G database and a 10G tmpdir.
> Sometimes the tmpdir runs out of space, and I get the following message on
> the logs:
> [ERROR] /usr/libexec/mysqld: Incorrect key file for table
> '/tmp/tmpdir/#sql_22f_33.MYI'; try to repair it
> Server load increases a lot, and MySQL eventually crashes.
> My question is: how can I find out what query is using so much tmpdir
> space?
> How much space should I allocate to this disk?

Hi Santiago,

Ensure the /tmp directory on large MySQL servers is greater than the value
of myisam_max_sort_file_size.

re:
http://itsecureadmin.com/2010/02/mysql-tmp-usage-with-optimi ze-table-command/

Thanks,
Josh Miller, RHCE/VCP



--
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