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>