[Freeswitch-users] mod_callcenter overloading database when using MySQL via unixODBC
vipkilla at gmail.com
Mon Feb 13 23:47:56 MSK 2012
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.
Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users