Hi,

We're stuck after the Unix admin left without prior notice.
We have a web application running on mySQL.
it seems that the \tmpdir for mySQL is mount to
var\tmp directory which has only 60 MB of available disk space
running any big query fails due to the size limitation

I don't have enough information about what applications are running to clean the tmp directory..

I need a quick help until we hire another admin.

Question:

How can i increase the size of the tmp Directory to allow more swapping ?

How can i reconfigure mySQL to another tmp directory?

Any other solution for my problem is highly appreciated.

Thanks

Check this thread Symbolic Link and try to search these forums with the keyword symbolic link.

This can be little bit complicated for a non unix user.

I am worried that i might screw up anything on the server, can u be detailed of steps to be taken..

I appreciate your help

Ok, can you post here output of command: dont forget to wrap your output with CODE tags.

From my understanding after i read about symbolic links that it is used to link a file to another file in a directory

the issue that mySQL doesn't have a specific file, it just uses var\tmp to create temporarily file when it executes queries then deletes them...

So my problem mainly is in the size of the var\tmp directory itself..not in a specific file.

Can it be solved with softlinks ?

Yeah, we can acheive solution for you thru symlinks, just post the output of

The system is FreeBsd

Filesystem 512-blocks Used Avail Capacity Mounted on
/dev/ad4s1d 507356 327368 139400 70% /var