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@antioche.eu.org>
--