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@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
-- Ken http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org irc.freenode.net #freeswitch