[SR-Users] SQlite in memory

[Alex Balashov]

Okay, but at a paltry 20 CPS -- or even several multiples of that --
none of this should be an issue. There's something else going on.

On Wed, Feb 27, 2019 at 10:28:54AM -0800, Julien Chavanton wrote:

> *https://www.kamailio.org/docs/modules/5.2.x/modules/db_sqlite.html#db_sqlite.p.db_set_journal_mode
> <https://www.kamailio.org/docs/modules/5.2.x/modules/db_sqlite.html#db_sqlite.p.db_set_journal_mode>*
> 
> On Wed, Feb 27, 2019 at 10:27 AM Julien Chavanton <jchavanton at gmail.com>
> wrote:
> 
> >
> > Hi, you can use the WAL mode, so that readers are never delayed.
> >
> > Just make sure all the connections to the DB are using the WAL mode.
> >
> > The downside is that the writers can be delayed sometimes, similar to
> > Postgres read only replica
> >
> > On Wed, Feb 27, 2019 at 9:57 AM Duarte Rocha <duarterocha91 at gmail.com>
> > wrote:
> >
> >> Greetings Alex,
> >>
> >> At the moment i'm trying to debug some issues with the server and try
> >> some solutions to see the impact.
> >> With little load i'm getting some percentage of "503 Server Unavaliable"
> >> errors from Kamailio. I made some testing without using database for
> >> anything but Dispatcher and Accounting and the performance got way better.
> >>
> >> Right now, on this server, under as little as 20CPS Kamailio is returning
> >> "503" on 1-2% of all calls. However, my CPU and Memory look like this:
> >>
> >> %Cpu(s): 20.3 us, 6.1 sy, 0.0 ni, 73.3 id, 0.0 wa, 0.0 hi, 0.2 si, 0.2 st
> >>
> >>
> >> Memory :
> >>
> >>               total used free shared buff/cache available
> >> Mem: 1830 1172 382 109 274 375
> >> Swap: 819 49 770
> >>
> >> I have around 100 processes for Kamailio.
> >>
> >> Cheers
> >> _______________________________________________
> >> Kamailio (SER) - Users Mailing List
> >> sr-users at lists.kamailio.org
> >> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
> >>
> >

> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users


-- 
Alex Balashov | Principal | Evariste Systems LLC

Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free) 
Web: http://www.evaristesys.com/, http://www.csrpswitch.com/