Mysql uses TMPDIR for sorting, multiple large tempfiles indicates heavy queries that should be optimised and/or missing indexes. Deleting those files while the

Mysql uses TMPDIR for sorting, multiple large tempfiles indicates heavy queries that should be optimised and/or missing indexes. Deleting those files while the server runs is an awesome way to "f@ck s*it up"! Do you really trust Mysql to behave nicely in that situation? Add more disk space and point TMPDIR somewhere else than /tmp, /var/tmp or /usr/tmp!