When the data disk is full and overloaded, the way out is to create and soft link and move the .frm and the .idb files into that link location.