pschmehl_lists at tx.rr.com
Thu Jun 19 17:53:47 UTC 2008
--On Thursday, June 19, 2008 11:09:57 -0500 Jeffrey Goldberg
<jeffrey at goldmark.org> wrote:
> 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
# tunefs -p /var
tunefs: ACLs: (-a) disabled
tunefs: MAC multilabel: (-l) disabled
tunefs: soft updates: (-n) enabled
tunefs: gjournal: (-J) disabled
tunefs: maximum blocks per file in a cylinder group: (-e) 2048
tunefs: average file size: (-f) 16384
tunefs: average number of files in a directory: (-s) 64
tunefs: minimum percentage of free space: (-m) 8%
tunefs: optimization preference: (-o) time
tunefs: volume label: (-L)
> 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.)
I looked all over their website and didn't see a place or an email address to
submit bug reports unless you're an enterprise customer.
As if it wasn't already obvious,
my opinions are my own and not
those of my employer.
More information about the freebsd-questions