[Freeswitch-users] mod_callcenter overloading database when using MySQL via unixODBC
peter.olsson at visionutveckling.se
Tue Feb 14 00:35:17 MSK 2012
Follow the steps below and tweak the MySQL server. Especially make sure you have enough RAM and that you have increased the InnoDB buffer pool size. As I said, in a properly configured server this shouldn't be even noticeable.
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 22:15
Till: FreeSWITCH Users Help
Ämne: Re: [Freeswitch-users] mod_callcenter overloading database when using MySQL via unixODBC
20 queries per second * number of FS servers, in this case 20 * 2 = 40
queries per second...
I'm just running this in a testing environment but it definitely bogs
down the mysql server.
On Mon, Feb 13, 2012 at 4:05 PM, Peter Olsson
<peter.olsson at visionutveckling.se> wrote:
> 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.
Professional FreeSWITCH Consulting Services:
consulting at freeswitch.org
Official FreeSWITCH Sites
FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org
Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users