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