[Freeswitch-users] Queries per second with MySQL backed

[Ken Rice]

You forget that 475 registered UACs generate a fair bit of traffic that
would generate a fair number of queries depending on the re-registration
interval, presence, etc...

Theres other things that also hit the core db...

On 9/5/13 7:13 PM, "Tim St. Pierre" <fs-list at communicatefreely.net> 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

-- 
Ken
http://www.FreeSWITCH.org
http://www.ClueCon.com
http://www.OSTAG.org
irc.freenode.net #freeswitch