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/
