Phantom /var full messages

[Sergey Zaharchenko]

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 clunix.cl.msu.edu> 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'
earlier.

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 utdallas.edu)
> Adjunct Information Security Officer
> The University of Texas at Dallas
> AVIEN Founding Member
> http://www.utdallas.edu
> _______________________________________________
> freebsd-questions at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "freebsd-questions-unsubscribe at freebsd.org"

-- 
DoubleF
"There was a boy called Eustace Clarence Scrubb, and he almost deserved
it."
		-- 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 : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20040910/5f30fc59/attachment.bin