Re: smsbox sending dlr's....

fredag 12. september 2003, 16:14, skrev Bill Brigden:
> it goes through a php script, which does 1 select and 1 update..
>
> I wasnt doing persistent connections for the reason that I thought around
> 50 apache processes all with persistent connections to the database would
> cause more errors as the max number of connection in mysql would be
> reached....

Use mysql_popen instead of mysql_open. Our server is not even sweating when 
the DLR's pour in.

> Out of interest, is there only one thread in smsbox that does the http
> dlr's requests? If so, why was it spawning so many apache threads when
> using keepalive would have meant only one was used...
>
> Let me know if I have got the wrong end of the stick!

I don't know.. ;-) But give persistent connections a try. If you have a load 
problem now, then it can be because of opening a database connection every 
time.

-- 
Med vennlig hilsen,
Eurobate ASA

Arne K. Haaje
Senior Network Engineer
--------------------------------------------------------------------
    Eurobate ASA - Postboks 5212 Majorstua - 0303 Oslo - Norway
Phone: +47 23 22 73 73 - Fax: +47 23 22 73 74 - Mob: +47 92 88 44 66
                    http://www.eurobate.com/