<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>We made some investigations on our Production database. We set
mysql slow log to 0.02 sec and we did not discover any long
running qeuries concerning presence.</p>
<p>The command<br>
</p>
<p><tt> select * from INFORMATION_SCHEMA.PROCESSLIST where
command <> 'Sleep';</tt><br>
</p>
<p>shows, that presence queries run between 0.1 and 1 milliseconds.
So I do not really feel, that the Mysql database is the bottleneck
here. MySQL show about 10-15%CPU on an 8 core machine. Freeswitch
runs at about 50% CPU on a different 8 core machine.</p>
<p>Nevertheless we have severe problems with presence. I have e.g. a
Snom phone and a Yealink phone on my desk with a BLF for a 3rd
phone, which is not in a call at present. BLF on Snom is "on" and
BLF on Yealink is "blinking". Both should be "off". This is very
strange to me. How can this happen? BTW when this system was under
no load, before we migrated our customers, everything worked fine.<br>
</p>
<p>So any help is very much appreciated here. <br>
</p>
<p>Another question is still:<br>
</p>
<ul>
<li>does anybody have an idea how to query all internal presence
status from Freewitch or maybe how to correct it?</li>
<ul>
<li>e.g. "sofia_presence_data list number@domain" returns e.g.</li>
</ul>
</ul>
<p><tt>status|rpid|user_agent|network_ip|network_port</tt><tt><br>
</tt><tt>unknown|unknown|N510 IP
PRO/42.250.00.000.000|xx.xxx.xxx.xx|21549</tt><tt><br>
</tt><tt>unknown|unknown|Yealink SIP-T41S 66.83.0.35
805EC025FDA9|xx.xx.xxx.xxx|20901</tt><tt><br>
</tt></p>
<p><tt><br>
</tt></p>
<blockquote>
<ul>
<li>and "sofia_presence_data status number@domain" always
returns<br>
</li>
</ul>
</blockquote>
<p><tt>unknownunknown</tt><br>
<br>
</p>
<blockquote>
<ul>
<li>Database table "sip_subscriptions" however is fine<br>
</li>
</ul>
</blockquote>
<p><br>
</p>
<p>Best regards</p>
<p>Peter<br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">Am 10.03.21 um 18:07 schrieb Guillermo
Ruiz Camauer:<br>
</div>
<blockquote type="cite"
cite="mid:CAPNTnnrkQhLQGXftzooAYNVhYR1XMrf-_xnzZeqW=vZO3dJ2AQ@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">From your description, it sounds like the DB is not
keeping up with the updates FreeSwitch is making. Have you
tried tuning the db? More memory, faster/more disks?
<div><br>
</div>
<div>Guillermo</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Wed, Mar 10, 2021 at 1:16
PM Peter Steinbach <<a href="mailto:lists@telefaks.de"
moz-do-not-send="true">lists@telefaks.de</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<p>Hello</p>
<p><br>
</p>
<p>we have a Freeswitch installation for a multi tenant
environment. We have extensively tested our Freeswitch for
all call scenarios and all worked fine. This is the good
news.<br>
</p>
<p>However, under higher load (>250 Channels and
>6000 Subscriptions), presence does not seem to work
reliably. I've found some ealier posts on this issue,
which seem to lead to the following 2 solutions</p>
<ul>
<li>use PostgreSQL (we use Mariadb via ODBC, also tested
mod_mariadb, which made things worse)</li>
<li>Move presence handling to Kamailio <br>
</li>
</ul>
<p>As your environment is based on MySQL, we do not want to
move to PostgreSQL without knowing, whether this will
improve the situation.</p>
<p>So far we are catching events via ESL or even grepping
the network and correct the status of presence informatons
sent to the phone. However we discover, that even if we
send corrected PRESENCE_IN via event socket, our
Freeswitch keeps on sending the wrong BLF information
afterwards to the phone. Means BLFs are blinking or in
state red event if the watched phone is not in a call. So
at present we are grepping all presence informations on
the network, crosscheck this with the channels table and
resend the corrected BLF status via event_socket if
needed. But still this is not sufficiant.<br>
</p>
<p>So I am now asking the community: What is your approach
to overcome this? <br>
</p>
<ul>
<li>Do newer Freeswitch versions perform better for this
case?(Ours is "FreeSWITCH Version
1.10.5-release+git~20200818T185121Z")</li>
<li>which work have you done to overcome this?</li>
<li>does anybody have an idea how to query all internal
presence status from Freewitch or maybe how to correct
it?<br>
</li>
</ul>
<p>Thank you in advance. Any help is appreciated.<br>
</p>
<p>Peter</p>
</div>
_________________________________________________________________________<br>
<br>
The FreeSWITCH project is sponsored by SignalWire <a
href="https://signalwire.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://signalwire.com</a><br>
Enhance your FreeSWITCH install with disruptive priced SMS and
PSTN services.<br>
Build your next product on our scalable cloud platform.<br>
<br>
Join our online community to chat in real time <a
href="https://signalwire.community" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://signalwire.community</a><br>
<br>
Professional FreeSWITCH Services<br>
<a href="mailto:sales@freeswitch.com" target="_blank"
moz-do-not-send="true">sales@freeswitch.com</a><br>
<a href="https://freeswitch.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="https://freeswitch.com/oss" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.com/oss</a><br>
<a href="https://freeswitch.org/confluence" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.org/confluence</a><br>
<a href="https://cluecon.com" rel="noreferrer" target="_blank"
moz-do-not-send="true">https://cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target="_blank" moz-do-not-send="true">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="https://freeswitch.com" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://freeswitch.com</a></blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail_signature">Guillermo Ruiz Camauer<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire <a class="moz-txt-link-freetext" href="https://signalwire.com">https://signalwire.com</a>
Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services.
Build your next product on our scalable cloud platform.
Join our online community to chat in real time <a class="moz-txt-link-freetext" href="https://signalwire.community">https://signalwire.community</a>
Professional FreeSWITCH Services
<a class="moz-txt-link-abbreviated" href="mailto:sales@freeswitch.com">sales@freeswitch.com</a>
<a class="moz-txt-link-freetext" href="https://freeswitch.com">https://freeswitch.com</a>
Official FreeSWITCH Sites
<a class="moz-txt-link-freetext" href="https://freeswitch.com/oss">https://freeswitch.com/oss</a>
<a class="moz-txt-link-freetext" href="https://freeswitch.org/confluence">https://freeswitch.org/confluence</a>
<a class="moz-txt-link-freetext" href="https://cluecon.com">https://cluecon.com</a>
FreeSWITCH-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a class="moz-txt-link-freetext" href="https://freeswitch.com">https://freeswitch.com</a></pre>
</blockquote>
<pre class="moz-signature" cols="72">
</pre>
</body>
</html>