From owner-freebsd-questions  Tue Jan 13 16:53:59 1998
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Received: (from majordom@localhost)
          by hub.freebsd.org (8.8.8/8.8.8) id QAA01139
          for questions-outgoing; Tue, 13 Jan 1998 16:22:33 -0800 (PST)
          (envelope-from owner-freebsd-questions@FreeBSD.ORG)
Received: from gdi.uoregon.edu (gdi.uoregon.edu [128.223.170.30])
          by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id PAA06924
          for <freebsd-questions@FreeBSD.ORG>; Tue, 13 Jan 1998 15:36:33 -0800 (PST)
          (envelope-from dwhite@gdi.uoregon.edu)
Received: from localhost (dwhite@localhost)
          by gdi.uoregon.edu (8.8.7/8.8.8) with SMTP id VAA22441;
          Mon, 12 Jan 1998 21:14:51 -0800 (PST)
          (envelope-from dwhite@gdi.uoregon.edu)
Date: Mon, 12 Jan 1998 21:14:51 -0800 (PST)
From: Doug White <dwhite@gdi.uoregon.edu>
Reply-To: Doug White <dwhite@resnet.uoregon.edu>
To: Dirk-Willem van Gulik <Dirk.vanGulik@jrc.it>
cc: freebsd-questions@freebsd.org,
        MSQL/Perl Mailing list <msqlperl@franz.ww.tu-berlin.de>
Subject: Re: mSQL-2.0.3 and FreeBSD 2.2.5 or 3.0 SNAP
In-Reply-To: <Pine.SOL.3.96.980108155120.29253I-100000@elect6.jrc.it>
Message-ID: <Pine.BSF.3.96.980112211159.22079z-100000@gdi.uoregon.edu>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Sender: owner-freebsd-questions@freebsd.org
Precedence: bulk

On Thu, 8 Jan 1998, Dirk-Willem van Gulik wrote:

> On a WWW system; we are using the common combo
> of Apache, Perl and mSQL. Since a recent change 
> where we have increased the free text and in
> context search capabilities, we are regulary
> seeing several of our index files of mSQL 2.0.3
> explode. Both on BSD 2.2.5 and 3.0 snap's.

Oh joy.

> We can reproduce it by cat-ting a 4 Mbyte
> file of inserts into the  'msql DBASE'
> command, so there seems little relation with
> the perl/apache environment.
> 
> The symptom is that a *.idx file grows quickly and
> suddenly all time is spend in kernel land. With
> no timely return; i.e. things like Alt-F1,2 etc
> still work, as does pinging, telnet-connect; but 
> any typing or other user land feedback is 
> completely out. Another recent change is that we
> now have some 150 tables, rather than the original
> 25 or so.
> 
> Anyone any ideas as where to look ? mmap() ?

/etc/login.conf.  I wonder if you are hitting the per-process limits.  

Try running `ulimit' or editing /etc/login.conf's limits.

Doug White                              | University of Oregon  
Internet:  dwhite@resnet.uoregon.edu    | Residence Networking Assistant
http://gladstone.uoregon.edu/~dwhite    | Computer Science Major