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

Peter Olsson peter.olsson at visionutveckling.se
Tue Feb 14 00:05:37 MSK 2012


I just looked quickly on the code, and there is a thread created at load time, that will execute this query once every 100ms, so this should cause 10 queries per second, and because of the db connection verification in FS it will also cause a "SELECT 1" before each query. So you should have 20 queries per second.

I'm not sure if this could be done in a different way, the author would have to answer that. However, this should not cause any problems on a properly configured MySQL server. You should be able to handle thousands of queries per second on a MySQL server.

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

It's actually doing like 50 queries per second... i'd just like to
understand if this is normal and  if so, why?

On Mon, Feb 13, 2012 at 3:39 PM, Peter Olsson
<peter.olsson at visionutveckling.se> wrote:
> 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
> ___________

<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:4f3975d632761156120760!




Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users mailing list