Add [trac] mysql_storage_engine option instead of editting my.cnf
|Reported by:||Jun Omae||Owned by:|
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
my.cnfcould be removed if:
- The storage engine was specified in a trac.ini variable such as
MySQLConnector.to_sqlwas modified to include the
ENGINEtable option in
- The modules in the
upgradepackage were modified to use the
ENGINEtable option either directly or indirectly by use of a helper function (such as
We could set the
default_tmp_storage_engine variables in session on connecting database, to remove the requirement.
SET @@session.default_storage_engine = 'InnoDB';
[trac] mysql_storage_engine option is empty (default), the session variables is not set and global variables is referred.