I've mapped my MySQL datadir to a different (and bigger) disk with 900GB
[root@web ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/xvda1 40G 24G 14G 64% /
tmpfs 7.4G 0 7.4G 0% /dev/shm
/dev/xvdb1 886G 658G 184G 79% /mnt/cbsvolume1
The /tmp is located in the smaller 40GB disk
[root@web ~]# df -h /tmp
Filesystem Size Used Avail Use% Mounted on
/dev/xvda1 40G 24G 14G 64% /
It appears MySQL is using the /tmp directory and because of that I'm running sometimes out of disk space when trying to perform big MySQL operations.
How can I change the /tmp
to also use the bigger disk?
/tmp
isn't even located on a disk./tmp
to betmpfs
, which isn't the case.