Bug #60036 make tmpdir variable changeable during runtime
Submitted: 9 Feb 2011 6:57
Reporter: Bogdan Kecman Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5.5 OS:Any
Assigned to: CPU Architecture:Any

[9 Feb 2011 6:57] Bogdan Kecman 
Description:
Sometimes one would need to change where temporary tables are being created without having to restart mysql server. It would be great if tmpdir variable could be changed in runtime.

How to repeat:
mysql> set global tmpdir = '/other/tmp2';
ERROR 1238 (HY000): Variable 'tmpdir' is a read only variable
mysql> 

Suggested fix:
.
[20 Nov 2013 10:36] martin fuxa 
btw same with #53119
[3 Dec 2014 7:12] Daniël van Eeden 
This looks like a duplicate of Bug #50291