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

[Jun Omae]

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.

[Ryan J Ollos]

Milestone renamed

[Ryan J Ollos]

Milestone renamed