On Tue, Feb 05, 2002 at 08:34:34AM -0700, Randy Arabie wrote:
> 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 mysq
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 r
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.p
> 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 i
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.
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
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_p
On Mon, Feb 04, 2002 at 12:01:11PM -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've checked a lot of things.
>
> Which would apply:
>
> kern.maxfiles
> proc.[mysqld_pid].rlimit.de
D]>, [EMAIL PROTECTED],
> [EMAIL PROTECTED]
> Subject: Re: sysctl & process limitations
>
> On Mon, 4 Feb 2002, William R. Mussatto wrote:
>
> > Have you checked on the ulimit for the user that is mysql?
>
> I've checked a lot of things.
>
> Wh
On Mon, 4 Feb 2002, William R. Mussatto wrote:
> Have you checked on the ulimit for the user that is mysql?
I've checked a lot of things.
Which would apply:
kern.maxfiles
proc.[mysqld_pid].rlimit.descriptors.soft
proc.[shell_pid].rlimit.descriptors.soft
Obviously, th
EMAIL PROTECTED],
> [EMAIL PROTECTED]
> Subject: Re: sysctl & process limitations
>
> In the last episode (Feb 02), Randy Arabie said:
> > On Sat, 2 Feb 2002, Dan Nelson wrote:
> > mysql.
> > > > kern.maxfiles = 1772
> > >
> > > Raise that to
On Sat, Feb 02, 2002 at 09:14:27PM -0700, Randy Arabie wrote:
> I don't think so. I raised the limit for mysqld descriptors to 5000.
>
> # sysctl -w proc.220.rlimit.descriptors.hard=unlimited
> # sysctl -w proc.220.rlimit.descriptors.soft=unlimited
>
> The kernel maxfiles was already set to 500
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 you
> > > can use, or you can do it manually v
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 you
> > can use, or you can do it manually via "sysctl -w kern.maxfiles=5000" .
>
> How high can
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 analyzing a kernel trace, but I could see
> >
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 analyzing a kernel trace, but I could see
> from the trace that the file was opened. And, it appea
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 trying to load data into tables in a mysql databa
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 trying to load data into tables in a mysql database. When I feed the
> load script into the database it
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
20 matches
Mail list logo
