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
