Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 12 Jan 1998 21:14:51 -0800 (PST)
From:      Doug White <dwhite@gdi.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
Message-ID:  <Pine.BSF.3.96.980112211159.22079z-100000@gdi.uoregon.edu>
In-Reply-To: <Pine.SOL.3.96.980108155120.29253I-100000@elect6.jrc.it>

next in thread | previous in thread | raw e-mail | index | archive | help
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





Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.3.96.980112211159.22079z-100000>