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

[Peter Olsson]

InnoDB should perform almost as good as well - but you will need to tweak it. If you have as much RAM (reserved for MySQL) as the size of your database it will also use memory only, except when writing UPDATE/INSERT/DELETE of course.

It's a common missunderstanding that you can install a database server with default settings and just go on. It's just like you would install FreeSWITCH and never modify the dialplan . it's a good start, but you will surely need to make changes to get it working the way you want.

Anyway, this is not a database mailing list, so I won't go any further than this :)

/Peter
________________________________________
Från: freeswitch-users-bounces at lists.freeswitch.org [freeswitch-users-bounces at lists.freeswitch.org] för Tim St. Pierre [fs-list at communicatefreely.net]
Skickat: den 14 februari 2012 02:33
Till: FreeSWITCH Users Help
Ämne: Re: [Freeswitch-users] mod_callcenter overloading database when using MySQL via unixODBC

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
>


_________________________________________________________________________
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:4f39b88132761488312585!