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 I was kinda figuring that mod_callcenter was just running select statements.... I will need to test out mod_fifo Is there anything to be done with mod_callcenter to correct this behavior short of rewriting the code? On Fri, Jun 20, 2014 at 12:55 PM, William King <william.king@quentustech.com
wrote:
If you can, try using mod_fifo instead of mod_callcenter. mod_callcenter has a inner loop running very rapidly where it is constantly doing select statements to the DB looking for new calls into the system.
William King Senior Engineer Quentus Technologies, INC 1037 NE 65th St Suite 273 Seattle, WA 98115 Main: (877) 211-9337 Office: (206) 388-4772 Cell: (253) 686-5518 william.king@quentustech.com
On 06/20/2014 09:39 AM, Joel White wrote:
A bit more information. When enabling mod_voicemail to write to PostgreSQL the activity is low. When I enable mod_callcenter to write to PostgreSQL the queries are going berserk.
If anyone has any guidance for me it would be greatly appreciated
On Fri, Jun 20, 2014 at 12:27 PM, Joel White <joelewhite@gmail.com <mailto:joelewhite@gmail.com>> wrote:
I was wondering why when I enabled PostgreSQL in Freeswitch, the PostgreSQL XID is incrementing at an extreme pace. I do not have hardly any transactions being inserted into the db. It looks like most all of the queries are SELECT statements.
Is this normal? Or is there something that I need to tweak in freeswitch?
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org