On Tuesday, September 4, 2018 at 4:14:24 AM UTC-7, Jun Omae wrote: > > 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. >
Thanks for the feedback. Summarized the discussion in: https://trac.edgewall.org/ticket/10993#comment:8 - Ryan -- 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.
