[imp] Hi guys - DESPERATE plea for help here...

[Charlie Reitsma]

apache 1.3.27/php 4.3.1/mysql 3.23.54a/php_accelerator 1.3.3r2
horde 2.2.1/imp 3.2.1/turba 1.2/kronolith 1.0/mnemo 1.1/nag 1.1
6 imp servers: 3 are on the same subnet as the mysql server
everything except vfs for attachments is in mysql
mysql settings being discussed:
connect_timeout 5
max_connections 600
max_used_connections 201
wait_timeout 28800
php.ini settings being discussed:
mysql.allow_persistent = On
mysql.connect_timeout = -1

Quoting Nigel Cass <N.Cass at Hull.ac.uk>:

> No - I actually have that set way too high really - 2048 connections. Also
> very unlikely to hit that when timeouts are set to 10 seconds. 
> 
> Perhaps I should be looking to completely disable persistent connections in
> php.ini.....
> 
> What is everyone else doing with RELENG horde,imp and turba accessing a
> remote mysql database for preferences ??
> 
> Nige.
> 
> > -----Original Message-----
> > From: Shawn Robinson [mailto:Shawn.Robinson at telus.com]
> > Sent: 01 May 2003 19:59
> > To: Nigel Cass; imp
> > Subject: Re: [imp] Hi guys - DESPERATE plea for help here...
> > 
> > Are you hitting your maximum_connections on your mysql?
> > 
> > You can bump that value up in your my.cnf file.
> > 
> > 
> > At 10:43 AM 2003/05/01 +0100, Nigel Cass wrote:
> > >Upgraded to the latest RELENG of horde, imp and turba today. Also started
> > >using the custom session handler now provided in the RELENG version.
> > >
> > >Intermittently (but often enough to make me look stupid :( ) we are
> > >experiencing DB errors - resulting in horde.log errors like the below....
> > >
> > >May 01 08:45:40 HORDE [emergency] [imp] DB Error: connect failed:
> > >[nativecode=Link to server lost, unable to reconnect] ** Array [on line
> > 108
> > >of "/usr/local/apache/htdocs/horde/lib/Prefs/sql.php"]
> > >
> > >I'm guessing it's because I've set connection timeout to be 10 seconds in
> > >mysql - Which I believe I set because I was under the impression that
> > this
> > >was good practice as you can never guarantee that the same apache daemon
> > >will perform every operation that a user does anyway.
> > >
> > >Please help as I'm stuck - it FEELS like a session problem yet I'm seeing
> > >the problem reported as Prefs/sql.php.
> > >
> > >Interesting to note is that the preferences are stored on a remote
> > database
> > >and the sessions are stored on a local database..
> > >
> > >HELP ?
> > >
> > >Nigel.
> > >
> > >
> > >
> > >--
> > >IMP mailing list
> > >Frequently Asked Questions: http://horde.org/faq/
> > >To unsubscribe, mail: imp-unsubscribe at lists.horde.org
> > 
> 
> 
> 
> --
> IMP mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe at lists.horde.org
> 


Charlie Reitsma
Systems Engineer