mariadb mad file take all space in hard drive

by Guillermo   Last Updated May 15, 2019 16:00 PM

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?

Tags : mariadb

Related Questions

Updated April 01, 2015 12:00 PM

Updated March 29, 2015 15:00 PM

Updated June 05, 2015 22:00 PM

Updated October 30, 2017 00:00 AM