Re: [OpenSIPS-Users] Fine tuning high CPS and msyql queries

2020-06-15 Thread Calvin Ellison
I attempted to reproduce the original breakdown around 3000 CPS using the
default 212992 byte receive buffer and could not, which tells me I broke a
cardinal rule of load testing and changed more than one thing at a time.
Also, don't do load testing when tired. I suspect that I had also made a
change to the sipp scenario recv/sched loops, or I had unknowingly
broken something while checking out the tuned package.

I deeply appreciate Alex's instance that I was wrong and to keep digging. I
am happy to retract my claim regarding "absolutely terrible sysctl
defaults". Using synchronous/blocking DB queries, the 8-core server reached
14,000 CPS, at which point I declared it fixed and went to bed. It could
probably go higher: there's only one DB query with a <10ms response time,
Memcache for the query response, and some logic to decide how to respond.
There's only a single non-200 final response, so it's probably as
minimalist as it gets.

If anyone else is trying to tune their setup, I think Alex's advice to "not
run more than 2 * (CPU threads) [children]" is the best place to start. I
had inherited this project from someone else's work under version 1.11 and
they had used 128 children. They were using remote DB servers with much
higher latency than the local DBs we have today, so that might have been
the reason. Or they were just wrong to being with.

The Description for Asynchronous Statements is extremely tempting and was
what started me down that path; it might be missing a qualification that
Async can be an improvement for slow blocking operations, but the
additional overhead may be a disadvantage for very fast blocking
operations.

Thank you to everyone who responded to this topic.

Regards,

*Calvin Ellison*
Senior Voice Operations Engineer
calvin.elli...@voxox.com


On Fri, Jun 12, 2020 at 6:42 PM Alex Balashov 
wrote:
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] cluster/cassandra cache

2020-06-15 Thread Vlad Patrascu

Hi Slava,

Can you open a ticket on Github for this? And also include there the 
Cassandra version and other relevant information (as per the issue 
template).


Regards,

On 09.06.2020 23:57, Slava Bendersky via Users wrote:

Hello Everyone,
Opensips v3.1 dev can't connect properly to Cassandra cluster.

1591735692.141 [ERROR] (cluster_connector.cpp:190:void 
datastax::internal::core::ClusterConnector::on_connect(datastax::internal::core::ControlConnector*)): 
Unable to establish a control connection to host 10.100.101.9 because 
of the following error: Underlying connection error: Received error 
response 'Invalid or unsupported protocol version (66); supported 
versions are (3/v3, 4/v4, 5/v5-beta)' (0x020A)

 Any help, thank you.

volga629

___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users