Quoting Rene: This post explains about using mysql triggers to keep track of dlr reports > without the need of smsbox or http calls: > > > > http://www.blogalex.com/archives/322 > > > Special thanks to Alejandro Guerrieri for letting me guest-blog on his > blog. >
2013/11/17 dorin <[email protected]> > also you can avoid at all using webserver (calling dlr-url) if you tweak > sqlbox source or define a trigger in database to update relevant tables > with needed information. > I can't catch the idea, Will be helpful for me if you will describe in > detail what do you mean. > > > > On 16.11.2013 23:10, spameden wrote: > > Either tune Apache2 according to your needs or (better) use nginx + > php-fpm. > > nginx + php-fpm both consumes much less memory than apache2. > > also you can avoid at all using webserver (calling dlr-url) if you tweak > sqlbox source or define a trigger in database to update relevant tables > with needed information. > > > 2013/11/16 dorin <[email protected]> > >> After I insert phone numbers into send_sms table, >> bearerbox-smsbox-sqlbox starts a lot of Apache processes that essentially >> increasing RAM. >> Conclusion: More Phone numbers into send_sms table more Apache processes >> are started and more memory are used. >> I increased my server RAM from 250MB to 1GB and now I can insert 100SMS >> into send_sms table at once. >> >> What do you think about this situation? >> >> On 15.11.2013 15:21, spameden wrote: >> >> >> >> >> 2013/11/15 dorin <[email protected]> >> >>> you are right! >>> in OOM-killer list is Mysql and Apache. >>> As I understand, I must increase urgent my RAM. >> >> >> As Rene pointed out before it has nothing to do with kannel at all. >> >> And I'd suggest avoid using Apache at all on VPS environment, stick to >> nginx+php-fpm if you need php functionality. >> >> For kannel sending service you'd need 1-2GB of memory depends really on >> your setup and amounts of messages staying in a kannel's internal queue. >> >>> >>> >>> On 15.11.2013 10:39, spameden wrote: >>> >>>> Check your dmesg as well as syslog entries, mysqld might be killed by >>>> OOM-killer. >>>> >>>> 2013/11/15 dorin <[email protected]>: >>>> >>>>> How many entries are there typically in that table? >>>>> >>>>> I have a cron that insert's every 1 min 10 SMS - it works fine. >>>>> If I increase for ex. 50 SMS inserts every 1 min - time by time mysql >>>>> loses >>>>> connection for a sec maximum. >>>>> but if I increase 100SMS per 1min - 100% mysql loses connection for a >>>>> small >>>>> time or for some seconds. In this time I lose the incoming data. >>>>> But realy 10 SMS or 100SMS per second is a very small value. >>>>> When I sending distribution SMS, processor shows me medium loaded >>>>> value: >>>>> 40%; RAM = 60% - 65% >>>>> >>>>> Tomorrow want to change MySql version. >>>>> now it's >>>>> mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (i486) using >>>>> readline >>>>> 6.1 >>>>> if the problem will persist, I will install MariaDB >>>>> >>>>> >>>>> On 15.11.2013 9:57, Rene Kluwen wrote: >>>>> >>>>>> The index on 'id' won't help you a lot. >>>>>> How many entries are there typically in that table? >>>>>> >>>>>> Having said that... sqlbox doesn't use the dlr table at all. So it's >>>>>> not >>>>>> your problem. >>>>>> >>>>>> == Rene >>>>>> >>>>>> >>>>>> -----Original Message----- >>>>>> From: users [mailto:[email protected]] On Behalf Of dorin >>>>>> Sent: donderdag 14 november 2013 12:12 >>>>>> To: spameden >>>>>> Cc: [email protected] >>>>>> Subject: Re: Big problem with sqlbox >>>>>> >>>>>> Thanks spameden for your reply >>>>>> >>>>>> "first of all what's the kannel/sqlbox version you're running?" >>>>>> >>>>>> I'm using kannel - 1.5 and sqlbox - I'm not really sure, I think 0.7; >>>>>> >>>>>> "you might need to tweak some settings. " >>>>>> >>>>>> Really I had set MyIsam all kannel tables. I have changed from MyIsam >>>>>> to >>>>>> InnoDb. Will familiarize soon with MariaDB too. Do you mean only >>>>>> these two >>>>>> tweaks? >>>>>> >>>>>> "check indexes on dlr table as well."I have indexed id column. >>>>>> >>>>>> Here is my dlr table >>>>>> CREATE TABLE IF NOT EXISTS `kannel_dlr`( >>>>>> `id` INT(11) NOT NULL AUTO_INCREMENT, >>>>>> `smsc` VARCHAR(40) DEFAULT NULL, >>>>>> `ts` VARCHAR(40) DEFAULT NULL, >>>>>> `destination` VARCHAR(40) DEFAULT NULL, >>>>>> `source` VARCHAR(40) DEFAULT NULL, >>>>>> `service` VARCHAR(40) NOT NULL, >>>>>> `url` VARCHAR(255) DEFAULT NULL, >>>>>> `mask` INT(10) DEFAULT NULL, >>>>>> `status` VARCHAR(40) DEFAULT NULL, >>>>>> `boxc` VARCHAR(40) DEFAULT NULL, >>>>>> `CampaignID` INT(11) NOT NULL, >>>>>> `RelOwnerUserID` INT(11) NOT NULL, >>>>>> `RelOperatorID` INT(11) NOT NULL, >>>>>> PRIMARY KEY (`id`), >>>>>> UNIQUE KEY `id` (`id`), >>>>>> UNIQUE INDEX UK_oempro_kannel_dlr_id (id) >>>>>> ) ENGINE = INNODB DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1; >>>>>> >>>>>> >>>>>> >>>>>> On 14.11.2013 12:28, spameden wrote: >>>>>> >>>>>>> first of all what's the kannel/sqlbox version you're running? >>>>>>> >>>>>>> check your mysql setup, you might need to tweak some settings. >>>>>>> >>>>>>> i'm strongly suggest using InnoDB instead of MyISAM, also take a look >>>>>>> at MariaDB (it's a fork of mysql, very nicely working). >>>>>>> >>>>>>> check indexes on dlr table as well. >>>>>>> >>>>>>> we've been using kannel to send about millions of sms messages daily >>>>>>> (MT) without any problems. >>>>>>> >>>>>>> 2013/11/14 dorin <[email protected]>: >>>>>>> >>>>>>>> Hello all! >>>>>>>> I have a big problem ! >>>>>>>> >>>>>>>> I need to send via KANNEL 5000 of SMS. >>>>>>>> >>>>>>>> When I insert into table kannel_sqlbox_send_sms every minute 10 SMS >>>>>>>> - >>>>>>>> all works fine. But this method is very slow If I try to increase >>>>>>>> inserting SMS, for example (100SMS) MySql stops working and I got >>>>>>>> this error: >>>>>>>> >>>>>>>> MySQL Error: MySql Error: Couldn't connect to database - Lost >>>>>>>> connection to MySQL server at 'reading initial communication >>>>>>>> packet', >>>>>>>> system error: 111 >>>>>>>> >>>>>>>> In ideal I wish to do one insert with 5000 rows >>>>>>>> >>>>>>>> Memory,Proccessor is not loaded. >>>>>>>> My configuration is SMSBox+SQLBox+BearerBox; >>>>>>>> >>>>>>>> Please give me some Ideas! >>>>>>>> >>>>>>>> >>>>>> >>>>>> >>>>>> >>>> >>> >> >> > >
