make sure you have it setup so it can do transactions or multiple statements.<div><br><br><div class="gmail_quote">On Mon, Oct 24, 2011 at 5:11 PM, Cliff Wells <span dir="ltr">&lt;<a href="mailto:cliff@develix.com">cliff@develix.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im">On Mon, 2011-10-24 at 17:36 -0400, Tim St. Pierre wrote:<br>
<br>
&gt; Database is MySQL 5.5.  I&#39;m seeing 18 queries per second, mostly complicated internal<br>
&gt; joins on tables like sip_dialogs and sip_subscriptions.<br>
&gt;<br>
&gt; Freeswitch is Version 1.0.head (git-7531fed 2011-08-17 11-27-20 -0500) and hardly breaking<br>
&gt; a sweat, while the database server is at 100% CPU load.<br>
<br>
<br>
</div>You need to optimize your database. Most likely you need to index tables<br>
that are used in joins (I doubt further optimization is needed for such<br>
a small dataset and such a light load).  I don&#39;t use MySQL, but I recall<br>
it has a way to log slow queries.  You should turn this on and use the<br>
output to figure out the right queries to optimize.  Don&#39;t blindly<br>
create needless indexes as this will actually slow it more.<br>
<font color="#888888"><br>
Cliff<br>
</font><div><div></div><div class="h5"><br>
<br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br>Anthony Minessale II<br><br>FreeSWITCH <a href="http://www.freeswitch.org/">http://www.freeswitch.org/</a><br>ClueCon <a href="http://www.cluecon.com/">http://www.cluecon.com/</a><br>
Twitter: <a href="http://twitter.com/FreeSWITCH_wire">http://twitter.com/FreeSWITCH_wire</a><br><br>AIM: anthm<br><a href="mailto:MSN%3Aanthony_minessale@hotmail.com">MSN:anthony_minessale@hotmail.com</a><br>GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com">PAYPAL:anthony.minessale@gmail.com</a><br>
IRC: <a href="http://irc.freenode.net">irc.freenode.net</a> #freeswitch<br><br>FreeSWITCH Developer Conference<br><a href="mailto:sip%3A888@conference.freeswitch.org">sip:888@conference.freeswitch.org</a><br><a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org">googletalk:conf+888@conference.freeswitch.org</a><br>
pstn:+19193869900<br>
</div>