This might help:
http://dev.mysql.com/doc/refman/5.1/en/temporary-files.html
On Jun 11, 2009, at 12:51 AM, Mike Spreitzer wrote:
> I find my MySQL Community Edition 5.1.34 server running out of space
> on
> /tmp (which is indeed small). Why is it using /tmp? How much free
> space
> do I need on /tmp? Can/should I make the server use a different
> location
> instead of /tmp?
>
> Thanks,
> Mike Spreitzer
--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com