[imp] MySQL session limits.

Patrick Boutilier boutilpj@ednet.ns.ca
Thu, 19 Oct 2000 08:09:16 -0300


Chris Crowley wrote:

> Horde Imps-
>
> Thanks in advance for the feedback, and the time.
>
> I am currently experiencing the following problem on an 500 MhZ IBM
> Netfinity server with 128MB RAM which is serving both mysql and the httpd.
>
> Occasionally, the server's CPU load average sky-rockets. Sometimes as high
> as the 70's or 80's. If I restart the httpd server, the load average drops
> and the server is working fine again. (The users seem to be using IMP more.)

We have that problem running on a Dell 2300 (PII450 w/512 Meg RAM) as well. We
are using Linux kernel 2.2.18pre11 and it hasn't happenned as much lately. What
OS are you using?


>
>
> Any similar experiences? I increased my max_connections setting to 300 about
> one month ago. ( I had to hard code it into the startup script, because
> putting it in my.cnf did not work.)
>

What version of MySql?


>
> Some horde info from phpMyAdmin:
>
> Database 'horde'
> --------------------------
> active_sessions        4374
> imp_addr                852
> imp_pref                213
>
> Is that active sessions number realistic? Does that table get cleared when
> the mysqld is restarted?
>

The table doesn't get cleared when mysqld restarts. However I have noticed that
when a user logs out their session record does not get deleted from the active
sessions table. Is this normal behaviour?



>From bary@isp.pl Date:   Thu, 19 Oct 2000 13:19:41 +0200
Return-Path: <bary@t19.ds.pwr.wroc.pl>
Mailing-List: contact imp-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list imp@lists.horde.org
Received: (qmail 23629 invoked from network); 19 Oct 2000 11:20:15 -0000
Received: from piast.t19.ds.pwr.wroc.pl (root@156.17.215.247)
  by horde.org with SMTP; 19 Oct 2000 11:20:15 -0000
Received: (from localhost user: 'bary', uid#1228)
	by piast.t19.ds.pwr.wroc.pl id <S116446AbQJSLTl>;
	Thu, 19 Oct 2000 13:19:41 +0200
Date:   Thu, 19 Oct 2000 13:19:41 +0200
Sender: Przemyslaw Barczuk <bary@t19.ds.pwr.wroc.pl>
From:   =?iso-8859-2?Q?Przemys=B3aw_Barczuk?= <bary@isp.pl>
To:     imp@lists.horde.org
Message-ID: <20001019131941.A7340@t19.ds.pwr.wroc.pl>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-2
Content-Transfer-Encoding: 8bit
User-Agent: Mutt/1.0.1i
Subject: problems with sending an email

Hi
I have some problems with sending an email. When I put button send IMP shows
me:
Warning: errflg=2, text=Can't get status of mailbox {localhost:110}: invalid
remote specification in /usr/share/horde/imp/status.php3 on line 112

in IE ... and 
Document contains no data.
 in Netscape.
Have You got the same problem ???

I use Debian (potato) imp 2.2.3 php3 3.0.17 and mysql 3.22.32-3.

			Przemysław
-- 
Przemysław 'Bary' Barczuk
System & Network administrator
tel. (071) 37-08-464
bary@isp.pl