default-storage-engine=INNODB
RjOllos於 2018年9月4日星期二 UTC+8上午10時00分41秒寫道:
On Monday, September 3, 2018 at 6:58:08 PM UTC-7, Mingxing Tian wrote:Which version of Trac and which version of MySQL?- RyanI have found out that something went wrong. I changed the default engine of the entire database instance to InnoDB.
I think you should not check the engine of the entire instance, but one of the specific database engines. This is an optimization. local.
default-storage-engine=INNODB
Unfortunately, configuration changes must be made to the database instance, not the database.
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: