Edgewall Software

Opened 6 years ago

Last modified 3 years ago

#13080 new enhancement

Add [trac] mysql_storage_engine option instead of editting my.cnf

Reported by: Jun Omae Owned by:
Priority: normal Milestone: next-dev-1.7.x
Component: database backend Version:
Severity: major Keywords: mysql
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:


Cloned from ticket:10993#comment:8:

This issue might be revisited in the future, for now I'm just summarizing the discussion in gdiscussion:trac-users:MO_KSSQMdnU.

The requirement to set default_storage_engine and default_tmp_storage_engine in my.cnf could be removed if:

  • The storage engine was specified in a trac.ini variable such as [trac] mysql_storage_engine or [mysql] storage_engine
  • MySQLConnector.to_sql was modified to include the ENGINE table option in TABLE CREATE statements
  • The modules in the upgrade package were modified to use the ENGINE table option either directly or indirectly by use of a helper function (such as MySQLConnector.to_sql)

We could set the default_storage_engine and default_tmp_storage_engine variables in session on connecting database, to remove the requirement.

SET @@session.default_storage_engine = 'InnoDB';

PoC: [f877c7e1d/jomae.git] (jomae.git@t10993_storage_option).

If [trac] mysql_storage_engine option is empty (default), the session variables is not set and global variables is referred.

Attachments (0)

Change History (2)

comment:1 by Ryan J Ollos, 5 years ago

Milestone: next-dev-1.3.xnext-dev-1.5.x

Milestone renamed

comment:2 by Ryan J Ollos, 3 years ago

Milestone: next-dev-1.5.xnext-dev-1.7.x

Milestone renamed

Modify Ticket

Change Properties
Set your email in Preferences
as new The ticket will remain with no owner.
The ticket will be disowned.
as The resolution will be set. Next status will be 'closed'.
The owner will be changed from (none) to anonymous. Next status will be 'assigned'.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.