Re: opensmppbox consume a lot of MEM

2013-11-16 Thread Minh Tuan
Yes, other boxs and processes stood still for weeks. Only opensmppbox increase mem usage by time, even can monitor by eyes. Now it's reaching to 41.2% of server memory from 0.2% as previous mail. The increasing speed along with traffic volume as my observation. I used some commands to check actual

RE: opensmppbox consume a lot of MEM

2013-11-16 Thread Rene Kluwen
Just trying to debug this problem. What if you increase max-connections in group = mysql-connection? I cannot see the mysql initialization in your logs. It should say: MYSQL: Connected to server at … MYSQL: server version …, client version ... But appearantly it does connect. So that

Re: Big problem with sqlbox

2013-11-16 Thread dorin
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 a

Re: Big problem with sqlbox

2013-11-16 Thread spameden
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 in

Re: Big problem with sqlbox

2013-11-16 Thread dorin
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, spamed

Re: Big problem with sqlbox

2013-11-16 Thread spameden
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 > also you