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

[Tim St. Pierre]

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>
>
> _________________________________________________________________________
> 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
>