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@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org