[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