From owner-freebsd-questions Thu Jan 8 07:01:36 1998 Return-Path: Received: (from root@localhost) by hub.freebsd.org (8.8.7/8.8.7) id HAA21756 for questions-outgoing; Thu, 8 Jan 1998 07:01:36 -0800 (PST) (envelope-from owner-freebsd-questions) Received: from mrelay.jrc.it (mrelay.jrc.it [139.191.1.65]) by hub.freebsd.org (8.8.7/8.8.7) with SMTP id HAA21751 for ; Thu, 8 Jan 1998 07:01:27 -0800 (PST) (envelope-from Dirk.vanGulik@jrc.it) Received: from elec.isei.jrc.it (elec.jrc.it) by mrelay.jrc.it (4.1/EB-950131-C) id AA20775; Thu, 8 Jan 98 16:01:35 +0100 Received: from elect6.jrc.it by elec.isei.jrc.it (4.1/EI-3.0m) id AA03293; Thu, 8 Jan 98 15:59:30 +0100 Posted-Date: Thu, 8 Jan 1998 15:58:41 +0100 (MET) Date: Thu, 8 Jan 1998 15:58:41 +0100 (MET) From: Dirk-Willem van Gulik X-Sender: dirkx@elect6.jrc.it Reply-To: Dirk-Willem van Gulik To: freebsd-questions@freebsd.org Cc: MSQL/Perl Mailing list Subject: mSQL-2.0.3 and FreeBSD 2.2.5 or 3.0 SNAP Message-Id: Reply-Path: Dirk.vanGulik@jrc.it Mime-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-questions@freebsd.org X-Loop: FreeBSD.org Precedence: bulk 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. 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() ? DW http://cils.ceo.org http://enrm.ceo.org dirkx@technologist.com Dirk.vanGulik@jrc.it +39 332 78 0014 +39 332 78 9549 fax +39 332 78 9185 ISEI/ESBA; The Center For Earth Observation Joint Research Centre of the European Communities, Ispra, Italy