[SR-Users] SQlite in memory

[Duarte Rocha]

I use database for lots of configs. On any given first request i do around
10 queries.

A while ago i measured the processing time  (using bm_timer) when i was
still using MySql and got times of around 6ms per first Invite and around
2ms for other in-dialog requests.

While i think those are big processing times, i don't think they should be
the problem at a rate as low as 20CPS.

Thank you for your help :)

A quarta, 27/02/2019, 18:35, Duarte Rocha <duarterocha91 at gmail.com>
escreveu:

> Ok, i reduced the number of processes and tried a few different values,
> but the performance hasn't changed a lot.
>
> How can i debug this and find the bottleneck in my system?
>
> A quarta, 27/02/2019, 17:56, Duarte Rocha <duarterocha91 at gmail.com>
> escreveu:
>
>> 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
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20190227/1ecec008/attachment.html>