[OpenSIPS-Devel] [ opensips-Patches-3488679 ] Index param in b2b_entities.
SourceForge.net
noreply at sourceforge.net
Sun Feb 19 14:27:55 CET 2012
Patches item #3488679, was opened at 2012-02-17 13:10
Message generated for change (Comment added) made by anca_vamanu
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: Closed
>Resolution: Fixed
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!
----------------------------------------------------------------------
>Comment By: Anca Vamanu (anca_vamanu)
Date: 2012-02-19 05:27
Message:
Hi Ryan,
You are right, an index was needed for the 'param' column. I have updated
the schema. Thank you for the patch.
Regards,
Anca
----------------------------------------------------------------------
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