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]
------------------------------------------------------------------


Reply via email to