Tuning MySQL would be the first thing I would do. Download and run this small script, http://mysqltuner.pl and it would show you some configurable parameters of MySQL which may greatly enhance your DB performance. On Tue, Oct 25, 2011 at 5:49 PM, Anthony Minessale <anthony.minessale@gmail.com> wrote:
make sure you have it setup so it can do transactions or multiple statements.
On Mon, Oct 24, 2011 at 5:11 PM, Cliff Wells <cliff@develix.com> wrote:
On Mon, 2011-10-24 at 17:36 -0400, Tim St. Pierre wrote:
Database is MySQL 5.5. I'm seeing 18 queries per second, mostly complicated internal joins on tables like sip_dialogs and sip_subscriptions.
Freeswitch is Version 1.0.head (git-7531fed 2011-08-17 11-27-20 -0500) and hardly breaking a sweat, while the database server is at 100% CPU load.
You need to optimize your database. Most likely you need to index tables that are used in joins (I doubt further optimization is needed for such a small dataset and such a light load). I don't use MySQL, but I recall it has a way to log slow queries. You should turn this on and use the output to figure out the right queries to optimize. Don't blindly create needless indexes as this will actually slow it more.
Cliff
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
-- Anthony Minessale II
FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire
AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
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