[Freeswitch-users] mod_callcenter overloading database when using MySQL via unixODBC

[Peter Olsson]

I don't see much about an overload here, a few queries per second should be hardly noticable on the MySQL instance?

/Peter
________________________________________
Från: freeswitch-users-bounces at lists.freeswitch.org [freeswitch-users-bounces at lists.freeswitch.org] för Vik Killa [vipkilla at gmail.com]
Skickat: den 13 februari 2012 20:57
Till: FreeSWITCH Users Help
Ämne: [Freeswitch-users] mod_callcenter overloading database when using MySQL via unixODBC

I have 2 FS servers sharing a mysql database via ODBC.
There are 2 queues loaded in mod_callcenter and there is absolutely
zero activity around mod_callcenter. The mysql.log is showing many
queries a few times per second like:
"select 1"
"SELECT queue,uuid,session_uuid,cid_number,cid_name,joined_epoch,(1329162473-joined_epoch)+base_score+skill_score
AS score, state, abandoned_epoch FROM members WHERE state = 'Waiting'
OR state = 'Abandoned' OR (serving_agent = 'ring-all' AND state =
'Trying') ORDER BY score DESC"

Even if i run "callcenter_config queue unload support1 at default" to
unload the queues from both FS servers, the mysql.log still doing the
queries. The only way the queries stop is if i do "unload
mod_callcenter"
Here is my callcenter.conf:

<configuration name="callcenter.conf" description="Call Center Module">
<settings>
<param name="odbc-dsn" value="freeswitch:freeswitch:freeswitch"/>
</settings>
<queues>
<queue name="support1 at default">
<param name="strategy" value="longest-idle-agent"/>
<param name="moh-sound" value="local_stream://moh/8000"/>
<param name="time-base-score" value="system"/>
<param name="max-wait-time" value="0"/>
<param name="max-wait-time-with-no-agent" value="0"/>
<param name="max-wait-time-with-no-agent-time-reached" value="5"/>
<param name="tier-rules-apply" value="false"/>
<param name="tier-rule-wait-second" value="300"/>
<param name="tier-rule-wait-multiply-level" value="true"/>
<param name="tier-rule-no-agent-no-wait" value="false"/>
<param name="discard-abandoned-after" value="60"/>
<param name="abandoned-resume-allowed" value="false"/>
</queue>
<queue name="support2 at default">
<param name="strategy" value="longest-idle-agent"/>
<param name="moh-sound" value="local_stream://moh/8000"/>
<param name="time-base-score" value="system"/>
<param name="max-wait-time" value="0"/>
<param name="max-wait-time-with-no-agent" value="0"/>
<param name="max-wait-time-with-no-agent-time-reached" value="5"/>
<param name="tier-rules-apply" value="false"/>
<param name="tier-rule-wait-second" value="300"/>
<param name="tier-rule-wait-multiply-level" value="true"/>
<param name="tier-rule-no-agent-no-wait" value="false"/>
<param name="discard-abandoned-after" value="60"/>
<param name="abandoned-resume-allowed" value="false"/>
</queue>
</queues>
</configuration>

_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting at freeswitch.org
http://www.freeswitchsolutions.com




Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

!DSPAM:4f3969df32768328019793!