My disk is full, an .MAD file in tmpdir takes up all the space on the file system (50G out of 110G)
[Warning] mysqld: Disk is full writing '/var/tmp/#sql_b6f_0.MAD' (Errcode: 28). Waiting for someone to free space
I execute the service mysqld stop and it works but it didn't remove the file. I execute the service mysqld start and fail because of the free sapace available.
It's safe to remove by hand the file? How can I set a max size for mad files to avoid this problem?