[Freeswitch-users] Queries per second with MySQL backed

[William King]

I'd suggest turning on a query log for a minute or two and getting a
count of how many unique queries are being run. Start from there. If
there is a misconfigured sip client that is hammering the registration
that could cause some of the query load.

William King
Senior Engineer
Quentus Technologies, INC
1037 NE 65th St Suite 273
Seattle, WA 98115
Main:   (877) 211-9337
Office: (206) 388-4772
Cell:   (253) 686-5518
william.king at quentustech.com

On 09/05/2013 05:13 PM, Tim St. Pierre wrote:
> Hello,
> 
> I have a redundant FS setup, where I'm using an external MySQL server
> for Core DB, as well as Sofia profiles, Voice Mail, and a little Limit DB.
> 
> I'm sitting at 143 queries per second, on an idle box.  Can someone tell
> me if this is normal, or should I be treating this as a problem?  During
> the day when we see 40-60 sessions, database IO doesn't change that
> much.  We don't normally see more than 3-4 calls per second, which is
> why I think it's strange to see so much database activity on what is
> really a small system as far as Freeswitch's capabilities are concerned.
> 
> Here's some info:
> -475 SIP clients registered across three profiles (most on 1, about 40
> on the second, and only 2 on the third, as it's our IPv6 internal profile).
> -The above profiles also have presence, with an average of 8
> subscriptions per phone
> -Two more profiles for trunks, no registrations on them
> -Registration is every 20 minutes, and MWI notifies and registration
> updates are sent on register.
> 
> Database IO seems to be mostly disk bound, as CPU is next to nothing,
> but disks run between 40 and 120 TPS, not much more than 2MB/s though.
> I have SSDs in the database machine.
> 
> Any thoughts?
> 
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
> 
> 
> 
> 
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
> 
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>