how to change \tmpdir directory or increase size? | Unix Linux Forums | UNIX for Dummies Questions & Answers

  Go Back    


UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !!

how to change \tmpdir directory or increase size?

UNIX for Dummies Questions & Answers


Closed Thread    
 
Thread Tools Search this Thread Display Modes
    #1  
Old 06-07-2006
ray ray is offline
Registered User
 
Join Date: Jun 2006
Last Activity: 7 June 2006, 8:04 AM EDT
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
how to change \tmpdir directory or increase size of var\tmp?

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

Last edited by ray; 06-07-2006 at 05:38 AM..
Sponsored Links
    #2  
Old 06-07-2006
tayyabq8's Avatar
tayyabq8 tayyabq8 is offline Forum Advisor  
Ex-Moderator
 
Join Date: Nov 2004
Last Activity: 16 December 2013, 12:55 AM EST
Location: Bahrain
Posts: 592
Thanks: 3
Thanked 7 Times in 3 Posts
Try symbolic link

Check this thread Symbolic Link and try to search these forums with the keyword symbolic link.
Sponsored Links
    #3  
Old 06-07-2006
ray ray is offline
Registered User
 
Join Date: Jun 2006
Last Activity: 7 June 2006, 8:04 AM EDT
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
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
    #4  
Old 06-07-2006
tayyabq8's Avatar
tayyabq8 tayyabq8 is offline Forum Advisor  
Ex-Moderator
 
Join Date: Nov 2004
Last Activity: 16 December 2013, 12:55 AM EST
Location: Bahrain
Posts: 592
Thanks: 3
Thanked 7 Times in 3 Posts
Ok, can you post here output of command:
Code:
df -v

dont forget to wrap your output with CODE tags.
Sponsored Links
    #5  
Old 06-07-2006
ray ray is offline
Registered User
 
Join Date: Jun 2006
Last Activity: 7 June 2006, 8:04 AM EDT
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
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 ?
Sponsored Links
    #6  
Old 06-07-2006
tayyabq8's Avatar
tayyabq8 tayyabq8 is offline Forum Advisor  
Ex-Moderator
 
Join Date: Nov 2004
Last Activity: 16 December 2013, 12:55 AM EST
Location: Bahrain
Posts: 592
Thanks: 3
Thanked 7 Times in 3 Posts
Yeah, we can acheive solution for you thru symlinks, just post the output of
Code:
df -v

Sponsored Links
    #7  
Old 06-07-2006
ray ray is offline
Registered User
 
Join Date: Jun 2006
Last Activity: 7 June 2006, 8:04 AM EDT
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
The system is FreeBsd

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

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
How to delete some of the files in the directory, if the directory size limits the specified size shaal89 Shell Programming and Scripting 0 02-10-2012 08:22 AM
Increase size to sd[b-c] kopper UNIX for Dummies Questions & Answers 1 05-21-2011 08:06 PM
How can I increase size of /tmp directory smartgupta Solaris 5 11-10-2009 09:51 AM
increase size jyoti HP-UX 1 04-14-2006 11:08 AM
increase size of /tmp pkappaz UNIX for Dummies Questions & Answers 2 07-02-2003 11:49 AM



All times are GMT -4. The time now is 02:41 AM.