mariadb mad file take all space in hard drive

Guillermo asked:

My disk is full, an .MAD file in tmpdir takes up all the space on the file system (50G out of 110G)

from log:

[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?

My answer:

That file is a temporary table that MariaDB wrote to disk because it was too large to keep in memory. If you’ve stopped the database, then the query which caused the table to be created is no longer running, so it is safe to delete the file. But you also need to investigate why that file was created and fix the underlying problem, or it will happen again.

View the full question and any other answers on Server Fault.

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.