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

[Vik Killa]

Tim:
So you actually have mod_callcenter running on more than FS instance
with a shared DB ?

On Mon, Feb 13, 2012 at 8:33 PM, Tim St. Pierre
<fs-list at communicatefreely.net> wrote:
> I had a similar problem with MySQL not being able to keep up.
>
> I changed the engine from innoDB to MEMORY and my CPU load went from 99%
> to 4%, and my disk IO had a similar drop.
>
> alter table XXX engine='MEMORY';
>
> Do you really need the calls in your queue to persist?  The only caveat
> - if you are running a multi-master mysql setup, restarting a server
> will propagate a "delete from XXX" query that flushes the tables, so
> keep that in mind.
>
> -Tim
>
> Vik Killa wrote:
>> It is bogging down my MySQL server.
>>
>> On Mon, Feb 13, 2012 at 3:07 PM, Peter Olsson
>> <peter.olsson at visionutveckling.se> wrote:
>>
>>> I don't see much about an overload here, a few queries per second should be hardly noticable on the MySQL instance?
>>>
>>>
 <snip>