Sound like you need to look into mod_perl, mod_dbi so you can have
persistant
database connections for your server.
Mike
----- Original Message -----
From: Eric Peters <[EMAIL PROTECTED]>
To: Michael Boman <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, December 21, 1999 3:23 AM
Subject: Re: Qmail is killing my mySQL server!
> makes you think about that doesn't it <grin>
>
> you probably want to consult the mysql mailing list for perf tuning
>
> Eric
>
> On Tue, 21 Dec 1999, Michael Boman wrote:
> > On Mon, Dec 20, 1999 at 11:55:25PM -0800, Eric Peters wrote:
> > > its probably rather simple - your probably using the decaprecated
mysql_connect
> > > in the CGI possibly - rather than the mysql_real_connect api -
> > >
> > > well to be simpler than that make sure your majority of the
connections are
> > > connecting through teh mysql named pipe (the socket) rather than
tcp/ip
> > > connections
> > >
> > > Eric
> > >
> >
> > Err.. It's on three different computers: Webserver, Mailserver, mySQL
server.
> >
> > /Mike
> >
> > > On Mon, 20 Dec 1999, Michael Boman wrote:
> > > > I am running following setup:
> > > >
> > > > qmail 1.03 + mysql patch
> > > > tcpserver etc.
> > > >
> > > > Right now qmail is killing the mySQL database server with requests.
I've
> > > > seen ppl here on the list with 30k-50k users and I wonder how you
manage
> > > > to keep the mySQL server alive.
> > > >
> > > > We have about 10k clients. On our homepage there is a CGI program
that
> > > > checks your email the moment you login.
> > > >
> > > > Problems so far:
> > > >
> > > > The maximum connections to the mySQL server exceeds the limit,
causing
> > > > downtime on our mail- and web server as it depends on the same
mySQL
> > > > server.
> > > >
> > > > So, is there any way to keep the mySQL connections down while
keeping
> > > > a high uptime of web- and mail server? Anyone written a
proxy/wrapper
> > > > for mySQL to limit the number of connections to the real mySQL
server?
> > > >
> > > > Future setup: qmail + vpopmail with even higher number of users.
> > > >
> > > > Please advice
> > > >
> > > > Michael Boman
> > > >
> > > > PS
> > > > Having a separate mySQL servers for mail and web is not a option, as
> > > > it would give our CGI programs more to do and by that making
> > > > the web-server load too high... Plus it would be another server
> > > > to manage.
> > > > DS
> > > >
> > > >
> > > > --
> > > > W I Z O F F I C E . C O M - Your Online Wizard
> > > > 16 Tannery Lane, Cristal Time Building, #06-00, Singapore 347778
> > > > Ring : (65) 844 3228 [ext 118] Fax : (65) 842 7228
> > > > email : [EMAIL PROTECTED] URL : http://www.wizoffice.com
> > > --
> > >
> > > ----------------------------------------------------------------------
> > > Eric Peters
> > > I Do: http://www.tekmetrics.com/transcript.jsp?pid=143745
> > > [EMAIL PROTECTED] - [EMAIL PROTECTED] - [EMAIL PROTECTED]
> > > ----------------------------------------------------------------------
> >
> > --
> > W I Z O F F I C E . C O M - Your Online Wizard
> > 16 Tannery Lane, Cristal Time Building, #06-00, Singapore 347778
> > Ring : (65) 844 3228 [ext 118] Fax : (65) 842 7228
> > email : [EMAIL PROTECTED] URL : http://www.wizoffice.com
> --
>
> ----------------------------------------------------------------------
> Eric Peters
> I Do: http://www.tekmetrics.com/transcript.jsp?pid=143745
> [EMAIL PROTECTED] - [EMAIL PROTECTED] - [EMAIL PROTECTED]
> ----------------------------------------------------------------------
>
