← Back to team overview

maria-discuss team mailing list archive

Re: default_tmp_storage_engine=NULL


Hi, Ian!

On Feb 09, Ian Gilfillan wrote:
> What is the purpose/effect of having MariaDB's 
> default_tmp_storage_engine setting default to NULL instead of the 
> default used in MySQL, Innodb? I can't see any obvious differences in 
> behaviour.

NULL means "same as default_storage_engine"
That is, no matter what you change your default_storage_engine to be,
temporary tables will always use the same engine.

Chief Architect MariaDB
and security@xxxxxxxxxxx

Follow ups