How to change "tmpdir" on a running MySQL instance
Seems like there is no easy and unobtrusive way to do it. However there is a way to increase the size of the tmpfs.


Change the size in /etc/fstab accordingly
Issue a mount -o remount and it will be resized without a need to release file handle locks.