I have some questions about this problem:
I run KANNEL under a small VPS, with processor 1Gb and RAM 250Mb
this may be a problem?
how much memory needs for KANNEL+SQLBOX well working?
because sqlbox use tables(kannel_dlr,kannel_sqlbox_send_sms) at the same
time with me, may be the cause that I don't use TRANSACTIONS.
The best way to modify these tables are to use transactions?
If I want to send billions of SMS needs I do some specific changes under
config files?
Thanks!
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!
