[OpenSIPS-Devel] [ opensips-Patches-2580715 ] Changes mysql store engine for location

[SourceForge.net]

Patches item #2580715, was opened at 2009-02-09 01:10
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086412&aid=2580715&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: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Sergio Gutierrez (saguti)
Assigned to: Nobody/Anonymous (nobody)
Summary: Changes mysql store engine for location

Initial Comment:

The default  value of store engine for location table is not convenient for a big number of users, as MyISAM locks whole table when executing updates; It would be more convenient to use InnoDB for this table, as it uses locking at row level; InnoDB is by default avaiable in MySQL 5.0.X, and it can be enabled at compilation time in MySQL 5.1.X.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086412&aid=2580715&group_id=232389