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
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]
----------------------------------------------------------------------
