Definitely need persistant connections. We use M$ SQL 7 for our
authentication via RADIATOR which is an sql based radius server. It uses
persistant connections (via perl::DBI) and we have no problems with 10k+
users.
jpd
At 09:18 AM 12/21/99 -0500, you wrote:
>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]
>> ----------------------------------------------------------------------
>>
>
>
>
