[Freeswitch-users] Queries per second with MySQL backed

[Tim St. Pierre]

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?