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....
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! Bill. ----- Original Message ----- From: Andreas Fink To: Bill Brigden Cc: [EMAIL PROTECTED] Sent: Friday, September 12, 2003 2:37 PM Subject: 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] ------------------------------------------------------------------
