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

[Vik Killa]

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>