[OpenSIPS-Users] database connections

[Kyle Romulas]

Stan,

Have you considered optimizing your DB?  We are handling thousands of calls per minute with a cluster of proxies balanced via SRV and using a centralized DB server.  We had to optimize when we discovered that under peak call periods we were exceeding the default T1 timer for responding to UAC INVITES.

If you are using MySQL, we found the following two links highly beneficial to increasing the performance of our DB.
http://www.debianhelp.co.uk/mysqlperformance.htm
http://hackmysql.com/mysqlreport

We run the report weekly to maintain performance.

Cheers.

- Kyle
DoubleHorn Communications-Platform Services, LLC

----- Original Message -----
From: "Stanisław Pitucha" <viraptor at gmail.com>
To: "OpenSIPS users mailling list" <users at lists.opensips.org>
Sent: Saturday, March 20, 2010 8:18:17 AM GMT -06:00 US/Canada Central
Subject: [OpenSIPS-Users] database connections

Hi,
I'm trying to reduce the number of connections to the database, because
the current setup is completely killing table cache unfortunately. 20
children (6 listening ips) * 5 modules.... not nice. I was wondering if
there is any way to cut the number of connections via the virtual db
module. If I set it up, I should get only the virtual connection up
(with one DB per process) and other modules would be using it - is this
right?
Do I lose anything this way? Like prepared queries functionality, or any
other speedup?

Are there any other db connection limiting ideas I could use?

Thanks,
Stan

_______________________________________________
Users mailing list
Users at lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users