If I start the server with --default-tmp-storage-engine=MyISAM, it works as expected. If I start it with a unique prefix, e.g. --default-tmp-storage-eng=MyISAM, the server writes the following messages on startup:
2015-08-07 21:27:55 139794374498144 [Note] Using unique option prefix 'default-tmp-storage-eng' is error-prone and can break in the future. Please use the full name 'default-tmp-storage-engine' instead.
|
2015-08-07 21:27:55 139794374498144 [Warning] 'default-tmp-storage-engine' is MySQL 5.6 compatible option. To be implemented in later versions.
|
and the variable does not get set:
MariaDB [test]> select @@default_tmp_storage_engine;
|
+------------------------------+
|
| @@default_tmp_storage_engine |
|
+------------------------------+
|
| NULL |
|
+------------------------------+
|
1 row in set (0.01 sec)
|