List:General Discussion« Previous MessageNext Message »
From:Randy Arabie Date:February 5 2002 3:34pm
Subject:Re: sysctl & process limitations
View as plain text  
On Tue, 5 Feb 2002, Manuel Bouyer wrote:

> On Tue, Feb 05, 2002 at 07:59:20AM -0700, Randy Arabie wrote:
> > On Mon, 4 Feb 2002, Randy Arabie wrote: 
> > 
> > > Right.  Like this:
> > > 
> > > mysql -u someuser -p -D somedatabase < ./data.sql
> > > 
> > > No.  I didn't raise the shell limits, I rose the kernel maxfiles and 
> > > the mysqld process proc.pid.rlimit.descriptors.soft limit.
> > > 
> > > I'll try the shell tonight.
> > 
> > Summary of Last Nights activities:
> > 
> > 	1) Switched back to the GENERIC kernel.
> > 	2) Edit /etc/sysctl.conf; added a line kern.maxfiles=5000
> > 	3) Reboot
> > 	4) Bump hard and soft proc.[mysqld_pid].rlimit.descriptors up to 2500.
> > 	5) Bump hard and soft proc.[shell_pid].rlimit.descriptors up to 2500.
> > 	6) Attempt to load the data, failure once again, same error message:
> > 
> > 	"ERROR 1017 at line 445: Can't find file: './geeklog/userinfo.frm' (errno:
> 23)"
> > 
> > 	7) fstat | wc -l shows 203 open files (done immediately following step 6
> above.
> > 	8) fstat | grep mysqld | wc -l shows mysqld only has 64 open files.
> > 	9) The database only has 38 tables, and the datafile I'm trying to load is
> only
> > 		37 KB.
> > 
> > Someone suggested a few days ago that perhaps the error reported is not
> accurate.  How would 
> > I test that?
> > 
> > My 'gut' says this is probably an easily resolved configuration issue, but I'm
> stumped on 
> > where to go next.
> 
> Now I would try to ktrace both mysqld and the mysql loading the
> tables ... 

You mention that, mysqld AND mysql.  You will note above that when I checked mysqld with
fstat,
there were only 64 files open.  That, coincidentally, is the default
proc.curproc.rlimit.descriptors.soft 
setting.

Does mysqld fork they mysql process, which may not be inheriting the limits set for
mysqld?

Can I add a line in /etc/sysctl.conf to allow all processes to have a greater default soft
limit for 
descriptors?

Or could I recompile my kernel to change that?  I looked in kernel config and didn't see
the options 
to change such things.

-- 

Cheers!

Randy

Thread
sysctl & process limitationsRandy Arabie2 Feb
  • Re: sysctl & process limitationsManuel Bouyer2 Feb
    • Re: sysctl & process limitationsRandy Arabie2 Feb
      • Re: sysctl & process limitationsManuel Bouyer2 Feb
        • Re: sysctl & process limitationsRandy Arabie2 Feb
Re: sysctl & process limitationsRandy Arabie3 Feb
Re: sysctl & process limitationsDan Nelson3 Feb
  • Re: sysctl & process limitationsRandy Arabie3 Feb
    • Re: sysctl & process limitationsManuel Bouyer3 Feb
  • Re: sysctl & process limitationsWilliam R. Mussatto4 Feb
    • Re: sysctl & process limitationsRandy Arabie4 Feb
      • Re: sysctl & process limitationsWilliam R. Mussatto4 Feb
      • Re: sysctl & process limitationsManuel Bouyer4 Feb
    • Re: sysctl & process limitationsRandy Arabie4 Feb
      • Re: sysctl & process limitationsManuel Bouyer4 Feb
        • Re: sysctl & process limitationsRandy Arabie5 Feb
          • Re: sysctl & process limitationsRandy Arabie5 Feb
            • Re: sysctl & process limitationsManuel Bouyer5 Feb
              • Re: sysctl & process limitationsRandy Arabie5 Feb
                • Re: sysctl & process limitationsManuel Bouyer5 Feb
                  • Re: sysctl & process limitationsRandy Arabie5 Feb