Re: smsbox sending dlr's....

how do you add it into mysql? if you run into maxclients problem then 
you most probably dont use persistent connections. with PHP and 
persisten connections (mysq_pconnect), the updates are instant. if not 
persisten, it does open/close a MySQL session every time which can take 
a few seconds. Multiply this by the max load and your server will spend 
99% of the time opening/closing database access.

On Freitag, September 12, 2003, at 11:37  Uhr, Bill Brigden wrote:

> Hi,
>
> We've been using our kannel server for sending out a few large sets of
> messages (around 700k)... We've been having problems though, not with 
> the
> sending to kannel, or kannel sending them out - but when messages are
> rejected at the submit_sm level, ie - error code back in the 
> submit_sm_resp,
> kannel is sending back the dlr to one of our webservers to put them 
> into a
> database, the apache and mysql processes are getting hammered to 
> death!!
>
> I found if I cut down the maxclients / threads on apache, all that 
> happens
> is apache gets tied up completely while they are coming through and 
> then
> smsbox puts a lot of "could not post to...." in the error logs - 
> meaning a
> bit of manual work in grep'ing and re-requesting the dlr url's.
>
> Is there a way to limit the number of smsbox processes that send dlr's 
> out,
> so - using keepalive, it will only use one apache thread? (It may 
> already do
> this, though just wondering what can be done...)
>
> Any ideas welcome!
>
> Bill.
>
>
>
Andreas Fink
Global Networks Switzerland AG

------------------------------------------------------------------
Tel: +41-61-6666333  Fax: +41-61-6666334   Mobile: +41-79-2457333
Global Networks, Inc. Clarastrasse 3, 4058 Basel, Switzerland
Web: http://www.global-networks.ch/      [email protected]
------------------------------------------------------------------