[OpenSIPS-Devel] [ opensips-Patches-3488679 ] Index param in b2b_entities.
SourceForge.net
noreply at sourceforge.net
Fri Feb 17 22:10:20 CET 2012
Patches item #3488679, was opened at 2012-02-17 13:10
Message generated for change (Tracker Item Submitted) made by rrb3942
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=1086412&aid=3488679&group_id=232389
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: trunk
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Ryan Bullock (rrb3942)
Assigned to: Nobody/Anonymous (nobody)
Summary: Index param in b2b_entities.
Initial Comment:
This adds an index on the 'param' column in the b2b_entities table for mysql. When opensips deletes from the b2b_entities table it only references the param column. Without an index this forces mysql to do a full table scan for every delete. This index should greatly speed up these queries.
Adding this index on our production system cut mysql cpu usage by more than half.
I also bumped the table version for b2b_entities and updated the db schema (hope I did this correctly).
Thanks!
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=1086412&aid=3488679&group_id=232389
More information about the Devel
mailing list