Looking to increase the /tmp on the linux server?

or getting frequent Mysql error due to /tmp running out of steps ?

below are the steps to increased /tmp partition,

##Stop Mysql in server##

/etc/init.d/mysql stop
###Find and kill the tailwatchd process###

pstree -p | grep tailwatchd
kill -9  < process ID>

#### Copy the /tmp to backup###

cp -prf /tmp /tmp.bak

###Set the /tmp to 2GB now###

dd if=/dev/zero of=/usr/tmpDSK bs=1024k count=2048

###Now find the size of tmp partition###

du -sch /usr/tmpDSK

### unmount /tmp partition

umount /tmp

###Format the /tmp partition###

mkfs -t ext3 /usr/tmpDSK

###Remount in secure environment###

/scripts/securetmp

###Now check size it should be 2GB###

df -h