← Back to team overview

maria-discuss team mailing list archive

Re: R: default_tmp_storage_engine=NULL


Well, I can't think many cases where InnoDB is not the default engine. But, if it is not, why should you use it for temporary tables?
If you mainly use TokuDB, maybe don't want to mix the engines. If you use MyISAM, maybe you don't want transactional temporary tables.
I still think that MEMORY makes sense in all cases :)


Gio 9/2/17, Ian Gilfillan <ian@xxxxxxxxxxx> ha scritto:

 Oggetto: Re: [Maria-discuss] R:  default_tmp_storage_engine=NULL
 A: "Maria Discuss" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
 Data: Giovedì 9 febbraio 2017, 10:32
 > I
 beleive that there is a difference if default_storage_engine
 != innodb, because in that case, default_tmp_storage_engine
 will not be InnoDB.
 that's the case. So why is this desirable in MariaDB as
 opposed to 
 MySQL's implementation?
 Mailing list: https://launchpad.net/~maria-discuss
 Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
 Unsubscribe : https://launchpad.net/~maria-discuss
 More help   : https://help.launchpad.net/ListHelp