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?