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 <rjol...@gmail.com> 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 trac-users+unsubscr...@googlegroups.com. To post to this group, send email to trac-users@googlegroups.com. Visit this group at https://groups.google.com/group/trac-users. For more options, visit https://groups.google.com/d/optout.
