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 > <[EMAIL PROTECTED]> 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 ([EMAIL PROTECTED]) > Adjunct Information Security Officer > The University of Texas at Dallas > AVIEN Founding Member > http://www.utdallas.edu > _______________________________________________ > [EMAIL PROTECTED] mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "[EMAIL PROTECTED]" -- DoubleF "There was a boy called Eustace Clarence Scrubb, and he almost deserved it." -- C. S. Lewis, The Chronicles of Narnia
Description: PGP signature