I'm importing a fairly large set of databases into a system which has a / partition only 10GB large. After a previous failed import, I dropped the database, but noticed /var/lib/mysql didn't exactly empty out - Now I'm watching the root partition fill up with this file:
$ sudo lsof / | grep deleted mysqld 53058 mysql 41u REG 253,0 951599104 5523 /tmp/MLR7HVLj (deleted)
This file is growing large enough (2GB) that I'm starting to worry that it'll crash my system. Is this a known problem (Old centos 6 mysql version 5.1) with trying to import a database after it's been dropped already, and is mysql aware of limited space in the partition it's filling up with a deleted file?