Queries per second with MySQL backed
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?
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
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@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@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
participants (3)
-
Ken Rice
-
Tim St. Pierre
-
William King