On Fri, May 25, 2012 at 11:59 PM, Nicholas Bamber <[email protected]> wrote: > Patrick, > Some ideas. Not sure how the application works so not sure which is > most liekly to be deoable. > > * There is a --default-storage-engine=type start up option. If you let the > standard mysql scripts manage the mysqld process that one might not work. > > * It should be possible to convert that option into an option entry in the > my.cnf file. You should also be able to own your own my.cnf fragment in say > /etc/mysql/conf.d/otrs2 .
Both are unacceptable, aren't they? Packages should not set MySQL-side options like the defaulst storage engine. > * If you only need to enforce the default engine in upgrade scripts (or the > creation of tables is confined in some other way) then this SQL would do it: > > set default_storage_engine = 'MyISAM'; This looks to be the only simple option. > However that will only persist as long as that connection. > > * Again you can use this SQL: > > set global default_storage_engine = 'MyISAM'; Again, not acceptable, IMO/ Olaf -- To UNSUBSCRIBE, email to [email protected] with a subject of "unsubscribe". Trouble? Contact [email protected]
