the unused option max_tmp_tables still can be set

The documentation mentions that the "max_tmp_tables" option is considered unused, providing no further explanation. Nevertheless, it remains accessible for configuration and retrieval through the subsequent commands.

SELECT @@max_tmp_tables;
SET max_tmp_tables=10;

https://mariadb.com/kb/en/server-system-variables/#max_tmp_tables