What indexes would you recommend on the LCR table?
-- Bjorn
-----Original Message----- From: serusers-bounces@iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of Juha Heinanen Sent: Saturday, November 12, 2005 8:48 AM To: Stefan Prelle Cc: serusers@lists.iptel.org Subject: [Serusers] LCR question
Stefan Prelle writes:
I am having huge performance problems. The OpenSER drops to
effectivly > 1 CPS. My lcr table contains only 20 entries and I have just 2 gateways > configured, so this shouldn't be a problem.
currently load_gws() makes a complex mysql query, but only one mysql query per second seems very slow to me. load_gws could be rewritten totally in c, but so far nobody has had time to do so.
-- juha
_______________________________________________ Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Bjorn Asmul writes:
What indexes would you recommend on the LCR table?
the ones that are automatically installed:
CREATE TABLE lcr ( prefix varchar(16) NOT NULL, from_uri varchar(128) NOT NULL DEFAULT '%', grp_id INT UNSIGNED NOT NULL, priority TINYINT UNSIGNED NOT NULL, KEY Key1 (prefix), KEY Key2 (from_uri), KEY Key3 (grp_id) ) $TABLE_TYPE;
-- juha
-
Bjorn Asmul -
Juha Heinanen