InnoDB should perform almost as good as well - but you will need to tweak it. If you have as much RAM (reserved for MySQL) as the size of your database it will also use memory only, except when writing UPDATE/INSERT/DELETE of course. It's a common missunderstanding that you can install a database server with default settings and just go on. It's just like you would install FreeSWITCH and never modify the dialplan . it's a good start, but you will surely need to make changes to get it working the way you want. Anyway, this is not a database mailing list, so I won't go any further than this :) /Peter ________________________________________ Från: freeswitch-users-bounces@lists.freeswitch.org [freeswitch-users-bounces@lists.freeswitch.org] för Tim St. Pierre [fs-list@communicatefreely.net] Skickat: den 14 februari 2012 02:33 Till: FreeSWITCH Users Help Ämne: Re: [Freeswitch-users] mod_callcenter overloading database when using MySQL via unixODBC 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
_________________________________________________________________________ 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 !DSPAM:4f39b88132761488312585!