On Tue, Sep 4, 2018 at 12:29 PM RjOllos <[email protected]> wrote: > > > > On Tuesday, September 4, 2018 at 3:24:36 AM UTC, RjOllos wrote: >> >> I don't see a way to set a persistent default storage engine for each >> database/schema. However, rather than requiring the MySQL instance default >> storage engine to be set (in the system-wide my.cnf configuration), we could >> possibly have a trac.ini configuration option to specify the storage engine >> and explicitly set the default for the session before creating the tables, >> or use the ENGINE option when creating tables: >> https://dev.mysql.com/doc/refman/8.0/en/storage-engine-setting.html > > > The proposed option would be [trac] mysql_storage_engine, or [mysql] > storage_engine.
Trac requires that both default_storage_engine and default_tmp_storage_engine are InnoDB. MySQLConnector.to_sql() respecting the option for storage engine sounds good but we're directly using "CREATE TEMPORARY TABLE ..." in trac/upgrades/*.py without the to_sql() method. The "CREATE TEMPORARY TABLE ..." uses storage engine configured in the default_tmp_storage_engine. -- Jun Omae <[email protected]> (大前 潤) -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/trac-users. For more options, visit https://groups.google.com/d/optout.
