[OpenSER-Devel] [ openser-Feature Requests-1851484 ] Change Storage Engine for MySQL tables to InnoDB

[SourceForge.net]

Feature Requests item #1851484, was opened at 2007-12-15 14:55
Message generated for change (Comment added) made by saguti
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743023&aid=1851484&group_id=139143

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: tools
Group: ver devel
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Sergio Gutierrez (saguti)
Assigned to: Nobody/Anonymous (nobody)
Summary: Change Storage Engine for MySQL tables to InnoDB

Initial Comment:

By changing the storage engine of MySQL tables to InnoDB, would it be possible to use the power, performance and scalability in the OpenSER database; InnoDB is included by default with the MySQL distrbution, so, it should not create a portability problem.



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

>Comment By: Sergio Gutierrez (saguti)
Date: 2007-12-18 03:14

Message:
Logged In: YES 
user_id=1960760
Originator: YES

The attached patches implements within openserdbctl.mysql a function which
allows to convert the tables related to a particular module to InnoDB MySQL
storage engine and define variables in openserdbctl.base to control which
set of tables could be converted to this Storage Engine (So that the
scripts asks it).
As said, it works in a per module basis, reading from the create scripts
the table names associated.

Also, the patch renames the variable TABLE to MODULE in the for cycles
which create several tables (Standard and Extra modules) so that the index
of the for be more expressive.
File Added: InnoDBPatch.tar

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743023&aid=1851484&group_id=139143