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
> &g
Did you try to raise the limit of the shell before starting it ?
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
On Mon, 4 Feb 2002, Manuel Bouyer wrote:
> 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 ?
Right.
cesses.
--
Cheers!
Randy
========
Randy Arabie
GnuPG Key Info --
Fingerprint: 7E25 DFA2 EF72 9551 9C6C 8AA6 6E8C A0F5 7E33 D981
Key ID: 7C603AEF
http://www.ar
bviously, the process rlimits cannot exceed the limits set in the kernel.
But, between the other two, which one takes precedence...the shell from
which the command was invoked or the actual mysqld process?
--
Cheers!
Randy
====
Rand
On Sat, 2 Feb 2002, Dan Nelson wrote:
> In the last episode (Feb 02), Randy Arabie said:
> > On Sat, 2 Feb 2002, Dan Nelson wrote:
> > mysql.
> > > > kern.maxfiles = 1772
> > >
> > > Raise that to (say) 5000. I assume netbsd has an /etc/sysctl.conf
On Sat, 2 Feb 2002, Dan Nelson wrote:
> > kern.maxfiles = 1772
>
> Raise that to (say) 5000. I assume netbsd has an /etc/sysctl.conf you
> can use, or you can do it manually via "sysctl -w kern.maxfiles=5000" .
How high can I go??
Tried 5000, and it still bombs at the same point. I set that
On Sat, 2 Feb 2002, Manuel Bouyer wrote:
> On Sat, Feb 02, 2002 at 10:33:21AM -0700, Randy Arabie wrote:
> >
> > > You may also want to ktrace mysqld while trying to load the
> > > database to get more details.
> >
> > Tried this. I'm not much
On Sat, 2 Feb 2002, Manuel Bouyer wrote:
> On Sat, Feb 02, 2002 at 08:23:49AM -0700, Randy Arabie wrote:
> > Environment:AlphaStation 255 w/ 64 MB RAM
> > NetBSD 1.5.2 - custom kernel
> > MySQL 3.23.47
> >
> > I'm tryi
Environment:AlphaStation 255 w/ 64 MB RAM
NetBSD 1.5.2 - custom kernel
MySQL 3.23.47
I'm trying to load data into tables in a mysql database. When I feed the
load script into the database it fails about 3/4 through. Error follows:
ERROR 1105 at line 11: Fi
10 matches
Mail list logo