[SR-Users] SQlite in memory

Julien Chavanton jchavanton at gmail.com
Wed Feb 27 19:28:54 CET 2019


*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
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20190227/23c9c6d7/attachment.html>


More information about the sr-users mailing list