OpenSIPS/OpenSER-a versatile SIP Server / Patches / #60 Changes mysql store engine for location

#60 Changes mysql store engine for location

Status: open

Owner: nobody

Labels: None

Priority: 5

Updated: 2009-02-09

Created: 2009-02-09

Creator: Sergio Gutierrez

Private: No

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.

Discussion

Sergio Gutierrez - 2009-02-09

Changes in schema to enable InnoDB type for MySQL tables, and change engine for location table.

schema.tar

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Changes mysql store engine for location

Group

Searches

Help

#60 Changes mysql store engine for location

Discussion