On Jun 19, 2008, at 9:40 AM, Paul Schmehl wrote:
As you can see from the df -i I posted (to which you responded),
inode exhaustion is not an issue.
You are probably right about that, but could you also post the result of
sudo tunefs -p /var
That won't tell us what is in use, but it will confirm whether /var
was set up with funky parameters or not. Also, the last time I ran
out of inodes, the error messages made it clear that that was what was
happening instead of merely giving a disk full error.
I'm leaning toward some sort of bug in mysql version 5.0.51 which
creates a temporary file (in the wrong place) and then doesn't
release it until it exhausts the space on the drive. In any case,
I'm going to report it to the mysql folks as such and hope they can
figure out what the cause is.
That would be my guess. I haven't seen a mention of that of the mysql
lists, but I don't follow the lists closely. (For the most part, I
just go and clean out the mail folder they collect in every week or so.)
Cheers,
-j
--
Jeffrey Goldberg http://www.goldmark.org/jeff/