<div dir="ltr"><div><div><div>I disabled the DB writes. I would say that it was hitting the DB at ~2 queries per second... that is just an estimate, but over the course of 30 minutes the XID had got up to 4,000<br><br></div>
I was kinda figuring that mod_callcenter was just running select statements....<br><br></div>I will need to test out mod_fifo<br><br></div>Is there anything to be done with mod_callcenter to correct this behavior short of rewriting the code?<br>
<br><br><div><div><br></div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Jun 20, 2014 at 12:55 PM, William King <span dir="ltr"><<a href="mailto:william.king@quentustech.com" target="_blank">william.king@quentustech.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">If you can, try using mod_fifo instead of mod_callcenter. mod_callcenter<br>
has a inner loop running very rapidly where it is constantly doing<br>
select statements to the DB looking for new calls into the system.<br>
<div class="im HOEnZb"><br>
William King<br>
Senior Engineer<br>
Quentus Technologies, INC<br>
1037 NE 65th St Suite 273<br>
Seattle, WA 98115<br>
Main: <a href="tel:%28877%29%20211-9337" value="+18772119337">(877) 211-9337</a><br>
Office: <a href="tel:%28206%29%20388-4772" value="+12063884772">(206) 388-4772</a><br>
Cell: <a href="tel:%28253%29%20686-5518" value="+12536865518">(253) 686-5518</a><br>
<a href="mailto:william.king@quentustech.com">william.king@quentustech.com</a><br>
<br>
</div><div class="im HOEnZb">On 06/20/2014 09:39 AM, Joel White wrote:<br>
> A bit more information. When enabling mod_voicemail to write to<br>
> PostgreSQL the activity is low. When I enable mod_callcenter to write<br>
> to PostgreSQL the queries are going berserk.<br>
><br>
> If anyone has any guidance for me it would be greatly appreciated<br>
><br>
><br>
> On Fri, Jun 20, 2014 at 12:27 PM, Joel White <<a href="mailto:joelewhite@gmail.com">joelewhite@gmail.com</a><br>
</div><div class="im HOEnZb">> <mailto:<a href="mailto:joelewhite@gmail.com">joelewhite@gmail.com</a>>> wrote:<br>
><br>
> I was wondering why when I enabled PostgreSQL in Freeswitch, the<br>
> PostgreSQL XID is incrementing at an extreme pace. I do not have<br>
> hardly any transactions being inserted into the db. It looks like<br>
> most all of the queries are SELECT statements.<br>
><br>
> Is this normal? Or is there something that I need to tweak in<br>
> freeswitch?<br>
><br>
><br>
><br>
><br>
><br>
><br>
</div><div class="HOEnZb"><div class="h5">> _________________________________________________________________________<br>
> Professional FreeSWITCH Consulting Services:<br>
> <a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
> <a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
><br>
> FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
> <a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
><br>
> Official FreeSWITCH Sites<br>
> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
> <a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
> <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
><br>
> FreeSWITCH-users mailing list<br>
> <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
><br>
<br>
_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</div></div></blockquote></div><br></div>