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

Mon Feb 13 23:39:32 MSK 2012

If your MySQL server won't handle load for a couple of queries per second you'll really need to tweak the MySQL configuration. I didn't look much more into this though, there might of course also be a missing index or something like that.

Start by tweaking the MySQL server (default config is more or less useless for any real work), especially the InnoDB buffer pool size is important. Also enable slow query logging, and log queries without indexes - this might give you a hint for what you need to do.

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

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

!DSPAM:4f396faf32766962924742!