[Freeswitch-users] High load on database server

[Cliff Wells]

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