how to change \tmpdir directory or increase size?


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers how to change \tmpdir directory or increase size?
# 1  
Old 06-07-2006
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 06:38 AM..
# 2  
Old 06-07-2006
Try symbolic link

Check this thread Symbolic Link and try to search these forums with the keyword symbolic link.
# 3  
Old 06-07-2006
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
Ok, can you post here output of command:
Code:
df -v

dont forget to wrap your output with CODE tags.
# 5  
Old 06-07-2006
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 ?
# 6  
Old 06-07-2006
Yeah, we can acheive solution for you thru symlinks, just post the output of
Code:
df -v

# 7  
Old 06-07-2006
The system is FreeBsd

Filesystem 512-blocks Used Avail Capacity Mounted on
/dev/ad4s1d 507356 327368 139400 70% /var
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Red Hat

Increase the filesystem size

Hi I am using oracle linux 6.4. My hard drive capacity is 500 GB. my filesystem size onbly 50GB. I would like to extend my filesystem size to around 100GB. I tried many codes but still I am not able. this is the output of df -h : Filesystem Size Used Avail Use% Mounted on... (6 Replies)
Discussion started by: farshad
6 Replies

2. Red Hat

Increase Font size

Hi friends I want increase font size in linux can anybody help me plese Example:this is my in put Filesystem Size Used Avail Use% Mounted on /dev/mapper/VolGroup00-LogVol00 18G 2.5G 14G 15% / /dev/sda2 ... (1 Reply)
Discussion started by: vasuibm
1 Replies

3. Shell Programming and Scripting

How to delete some of the files in the directory, if the directory size limits the specified size

To find the whole size of a particular directory i use "du -sk /dirname".. but after finding the direcory's size how do i make conditions like if the size of the dir is more than 1 GB i hav to delete some of the files inside the dir (0 Replies)
Discussion started by: shaal89
0 Replies

4. UNIX for Dummies Questions & Answers

Increase size to sd[b-c]

hi guys I am working on my vmware workstation. I have a /dev/sdb which is 5GB. I am using LVM. Now I increase /dev/sdb 2 more GB. fdisk -l shows 7 GB but pvscan still shows 5GB. how do I make my system recognize the new 7GB added and be able to add those to my physical volumen and... (1 Reply)
Discussion started by: kopper
1 Replies

5. Solaris

increase metadevice size

Hi, I am having two metadevices d50 and d100 which are used to created soft partitions as and when required. d50 and d100 are metadevices formed on different disks. d50 -- disks 0 & 1 d100 -- disks 2 & 3 I have a soft partition d70 os 50 GB on d50. Now there is no free space on d50. ... (1 Reply)
Discussion started by: sag71155
1 Replies

6. UNIX for Dummies Questions & Answers

Increase salt size

Unix protect its password by using salt It that mean larger the salt size the more secure? if the salt size increase greatly, will the password still able to be cracked? thank you for helping (1 Reply)
Discussion started by: cryogen
1 Replies

7. Solaris

how to increase the size of the allotment

Hi all, I have a 130gb HDD of which 95b is taken up by various partitions of windows xp... I partitioned my HDD and gave solaris 10gb of space, but now owing to some development stuff i need to increase the space!!! How do i do it!! Please note that i do have ~20gb of space left still...... (2 Replies)
Discussion started by: wrapster
2 Replies

8. HP-UX

increase size

Hi All, one of the mount point in Hp ux server has reached 95% its a data base file and can not be deleted. so i want to know how to increase the size of mount point i am new to unix ,please help me (1 Reply)
Discussion started by: jyoti
1 Replies

9. UNIX for Dummies Questions & Answers

increase size of /tmp

My /tmp is full, and the oracle installation is crashing. How can I increase the size of /tmp, even though I have allocated all the available disk space to other partitions? (2 Replies)
Discussion started by: pkappaz
2 Replies

10. Programming

How to increase the size of the stack

Hi!!, could someone tell me how to increase the stack size in HP-UX? Thanx (7 Replies)
Discussion started by: jyotipg
7 Replies
Login or Register to Ask a Question