List:General Discussion« Previous MessageNext Message »
From:Manuel Bouyer Date:February 4 2002 10:47pm
Subject:Re: sysctl & process limitations
View as plain text  
On Mon, Feb 04, 2002 at 03:43:40PM -0700, Randy Arabie wrote:
> On Mon, 4 Feb 2002, William R. Mussatto wrote:
> 
> > Have you checked on the ulimit for the user that is mysql?
> 
> I did, but had only set it "dynamically".  I did raise it quite high, 
> 5000 I believe.  After that I initiated the load, but from a "normal" 
> user shell which had the default proc.[shell_pid].rlimit.descriptors.soft=64
> limitation.  Hence my question, from where does the load inherit its limit.

What a minute ... you're loading the tables to a 'mysqld' process, using
the 'mysql' command, rigth ?
Maybe it's just the mysql command which runs out of files descriptors ?
Did you try to raise the limit of the shell before starting it ?

-- 
Manuel Bouyer <bouyer@stripped>
--
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