Phantom /var full messages

Sergey Zaharchenko doublef at
Fri Sep 10 10:12:35 PDT 2004

On Fri, Sep 10, 2004 at 11:57:57AM -0500,
 Paul Schmehl probably wrote:
> --On Friday, September 10, 2004 11:23:11 AM -0400 Jerry McAllister 
> <jerrymc at> wrote:
> >If you are doing database stuff, then I can't imagine having a /var
> >of less than a few GB, unless you move a lot of stuff out of /var and
> >create links.   See some recent previous posts on the subject.
> (BTW, /var is 31GB)
> ^^^^^^^^^^^^^^^^^^^
> Did you miss this?

Actually, I mentioned that 31 is `a few' for some values of `a few'

I have no experience with mysql, but I'd think something is creating
tons of smaller files and not closing them, rather than a program
keeping a 31G file open (inflating 400M to 31G should be difficult even
for mysql). Try (yet another ugly fstat hack)

# fstat | grep /var | grep mysqld | wc -l

to show the number of files open by the mysqld process (or any other
process if you change the name) in the /var fs.

Did you try asking on a mysql-related list?

> >
> >
> Paul Schmehl (pauls at
> Adjunct Information Security Officer
> The University of Texas at Dallas
> AVIEN Founding Member
> _______________________________________________
> freebsd-questions at mailing list
> To unsubscribe, send any mail to "freebsd-questions-unsubscribe at"

"There was a boy called Eustace Clarence Scrubb, and he almost deserved
		-- C. S. Lewis, The Chronicles of Narnia
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url :

More information about the freebsd-questions mailing list